I just installed CTools (Chaos) and Panels and I am getting this error messages...

* user warning: BLOB/TEXT column 'conf' can't have a default value query: CREATE TABLE delegator_handlers ( `did` INT NOT NULL auto_increment, `name` VARCHAR(255) DEFAULT NULL, `task` VARCHAR(64) DEFAULT NULL, `subtask` VARCHAR(64) NOT NULL DEFAULT '', `handler` VARCHAR(64) DEFAULT NULL, `weight` INT DEFAULT NULL, `conf` LONGTEXT NOT NULL DEFAULT '', PRIMARY KEY (did), UNIQUE KEY name (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Apache\htdocs\drupal69\includes\database.inc on line 515.

* user warning: BLOB/TEXT column 'access' can't have a default value query: CREATE TABLE delegator_pages ( `pid` INT NOT NULL auto_increment, `name` VARCHAR(255) DEFAULT NULL, `admin_title` VARCHAR(255) DEFAULT NULL, `path` VARCHAR(255) DEFAULT NULL, `access` LONGTEXT NOT NULL DEFAULT '', `multiple` TINYINT DEFAULT 0, `menu` LONGTEXT NOT NULL DEFAULT '', `arguments` LONGTEXT NOT NULL DEFAULT '', PRIMARY KEY (pid), UNIQUE KEY name (name) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in C:\Apache\htdocs\drupal69\includes\database.inc on line 515.

Comments

frankaltea’s picture

frankaltea commented

I should have said CTools (Chaos) and Views...

merlinofchaos’s picture

merlinofchaos commented

Argh! silly schema API. Sigh.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

Fixed in CVS now.

frankaltea’s picture

frankaltea commented

The error, I think was in the part where it says:
`conf` LONGTEXT NOT NULL DEFAULT ''
`access` LONGTEXT NOT NULL DEFAULT ''
`menu` LONGTEXT NOT NULL DEFAULT '', `arguments` LONGTEXT NOT NULL DEFAULT '

From what I understand, longtext cannot have a default value.

I just checked delegator.install and these are still in there.

Apollo610’s picture

Apollo610 commented

Frank, the updated .install is in the lasted .dev release...

However I'm still getting an error when I enable the delegator module (and in looking at my DB, it doesn't look like any of the delegator tables were created). I wanted to test out Panels3/ctools but no luck so far.

user warning: Table 'civg.delegator_pages' doesn't exist query: SELECT * FROM delegator_pages in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\sites\all\modules\ctools\includes\export.inc on line 101.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.