I've just hit the "WD php: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'status'" error on a drush install of the module over a clean Commerce Kickstart:
root@ns1:/home/example.com/public_html#
drush en commerce_license_billing -y
commerce_license_billing was not found. [warning]
The following projects provide some or all of the extensions not found: [ok]
commerce_license_billing
Would you like to download them? (y/n): y
Project commerce_license_billing (7.x-1.0-beta3) downloaded to sites/all/modules/commerce_license_billing. [success]
The following projects have unmet dependencies: [ok]
commerce_license_billing requires commerce_license, advancedqueue
Would you like to download them? (y/n): y
Project commerce_license (7.x-1.3) downloaded to sites/all/modules/commerce_license. [success]
Project commerce_license contains 3 modules: commerce_license_role, commerce_license_example, commerce_license.
Project advancedqueue (7.x-1.0-beta2) downloaded to sites/all/modules/advancedqueue. [success]
Project advancedqueue contains 2 modules: advancedqueue_example, advancedqueue.
The following projects have unmet dependencies: [ok]
commerce_license_billing requires entity_bundle_plugin
Would you like to download them? (y/n): y
Project entity_bundle_plugin (7.x-1.0-beta2) downloaded to sites/all/modules/entity_bundle_plugin. [success]
The following extensions will be enabled: commerce_license_billing, entity_bundle_plugin, commerce_license, advancedqueue
Do you really want to continue? (y/n): y
WD php: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'status': CREATE [error]
TABLE {advancedqueue} (
`item_id` INT unsigned NOT NULL auto_increment COMMENT 'Primary Key: Unique item ID.',
`name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The queue name.',
`uid` INT unsigned NOT NULL COMMENT 'The user to which the item belongs.',
`title` VARCHAR(400) NOT NULL COMMENT 'The title of this item.',
`data` LONGBLOB NULL DEFAULT NULL COMMENT 'The arbitrary data for the item.',
`result` LONGBLOB NULL DEFAULT NULL COMMENT 'The arbitrary result for the item, only significant if advancedqueue.status
0',
`expire` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the claim lease expires on the item.',
`status` TINYINT NOT NULL DEFAULT 'ADVANCEDQUEUE_STATUS_QUEUED' COMMENT 'Indicates whether the item has been processed (-1
= queue, 0 = processing, 1 = successfully processed, 2 = failed).',
`created` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the item was created.',
`processed` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the item was processed.',
PRIMARY KEY (`item_id`),
INDEX `queue` (`name`, `status`, `expire`, `created`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores items in queues.'; Array
(
)
in db_create_table() (line 2720 of /home/example.com/public_html/includes/database/database.inc).
Cannot modify header information - headers already sent by (output started at [warning]
/usr/share/pear/drush/includes/output.inc:38) bootstrap.inc:1224
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'status': CREATE TABLE {advancedqueue} (
`item_id` INT unsigned NOT NULL auto_increment COMMENT 'Primary Key: Unique item ID.',
`name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The queue name.',
`uid` INT unsigned NOT NULL COMMENT 'The user to which the item belongs.',
`title` VARCHAR(400) NOT NULL COMMENT 'The title of this item.',
`data` LONGBLOB NULL DEFAULT NULL COMMENT 'The arbitrary data for the item.',
`result` LONGBLOB NULL DEFAULT NULL COMMENT 'The arbitrary result for the item, only significant if advancedqueue.status <> 0',
`expire` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the claim lease expires on the item.',
`status` TINYINT NOT NULL DEFAULT 'ADVANCEDQUEUE_STATUS_QUEUED' COMMENT 'Indicates whether the item has been processed (-1 = queue, 0 = processing, 1 = successfully processed, 2 = failed).',
`created` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the item was created.',
`processed` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the item was processed.',
PRIMARY KEY (`item_id`),
INDEX `queue` (`name`, `status`, `expire`, `created`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores items in queues.'; Array
(
)
in db_create_table() (line 2720 of /home/example.com/public_html/includes/database/database.inc).
Drush command terminated abnormally due to an unrecoverable error.
Comments
Comment #1
bojanz commentedThe error shows that advancedqueue is failing to install. Moving the issue to that issue queue, and looking into it.
Comment #3
bojanz commentedPushed a fix, tagged advancedqueue beta3.