Closed (fixed)
Project:
Block Queue
Version:
6.x-1.7
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
27 Aug 2009 at 10:20 UTC
Updated:
9 Sep 2009 at 20:05 UTC
BLOB/TEXT column 'title' can't have a default value query: CREATE TABLE blockqueue ( `bqid` INT unsigned NOT NULL auto_increment, `qname` VARCHAR(128) DEFAULT NULL, `title` LONGTEXT NOT NULL DEFAULT '', `size` INT unsigned DEFAULT NULL, `region` VARCHAR(128) DEFAULT NULL, PRIMARY KEY (bqid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in <drupal-root>\includes\database.inc on line 515.
BLOB/TEXT columns are not allowed to have default values (see MySQL 5.1 Reference Manual, "BLOB and TEXT columns cannot have DEFAULT values."). On a Windows platform this is treated as an error (aborting the installation without setting up the table), while on other platforms this is often treated as a warning (see http://dev.mysql.com/doc/refman/5.1/en/blob.html#c9390).
Comments
Comment #1
gogasan commentedresolved