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

gogasan’s picture

Status: Active » Closed (fixed)

resolved