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 &#039;The arbitrary result for the item, only significant if advancedqueue.status <> 0&#039;, 
`expire` INT NOT NULL DEFAULT 0 COMMENT &#039;Timestamp when the claim lease expires on the item.&#039;, 
`status` TINYINT NOT NULL DEFAULT &#039;ADVANCEDQUEUE_STATUS_QUEUED&#039; COMMENT &#039;Indicates whether the item has been processed (-1 = queue, 0 = processing, 1 = successfully processed, 2 = failed).&#039;, 
`created` INT NOT NULL DEFAULT 0 COMMENT &#039;Timestamp when the item was created.&#039;, 
`processed` INT NOT NULL DEFAULT 0 COMMENT &#039;Timestamp when the item was processed.&#039;, 
PRIMARY KEY (`item_id`), 
INDEX `queue` (`name`, `status`, `expire`, `created`)
) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT &#039;Stores items in queues.&#039;; 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

bojanz’s picture

Title: WD php: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'status' » Syntax error or access violation: 1067 Invalid default value for 'status'
Project: Commerce License Billing » Advanced Queue
Version: 7.x-1.0-beta3 » 7.x-1.x-dev

The error shows that advancedqueue is failing to install. Moving the issue to that issue queue, and looking into it.

  • bojanz committed 33d7cb8 on 7.x-1.x
    Issue #2328227 by yngens2: Fixed Syntax error or access violation: 1067...
bojanz’s picture

Status: Active » Fixed

Pushed a fix, tagged advancedqueue beta3.

Status: Fixed » Closed (fixed)

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