>>> [!note] Migrated issue <!-- Drupal.org comment --> <!-- Migrated from issue #2328227. --> Reported by: [yngens2](https://www.drupal.org/user/2829917) >>> <p>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:</p> <pre>root@ns1:/home/example.com/public_html#<br>drush en commerce_license_billing -y<br>commerce_license_billing was not found.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [warning]<br>The following projects provide some or all of the extensions not found:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [ok]<br>commerce_license_billing<br>Would you like to download them? (y/n): y<br>Project commerce_license_billing (7.x-1.0-beta3) downloaded to sites/all/modules/commerce_license_billing.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [success]<br>The following projects have unmet dependencies:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [ok]<br>commerce_license_billing requires commerce_license, advancedqueue<br>Would you like to download them? (y/n): y<br>Project commerce_license (7.x-1.3) downloaded to sites/all/modules/commerce_license.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [success]<br>Project commerce_license contains 3 modules: commerce_license_role, commerce_license_example, commerce_license.<br>Project advancedqueue (7.x-1.0-beta2) downloaded to sites/all/modules/advancedqueue.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [success]<br>Project advancedqueue contains 2 modules: advancedqueue_example, advancedqueue.<br>The following projects have unmet dependencies:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [ok]<br>commerce_license_billing requires entity_bundle_plugin<br>Would you like to download them? (y/n): y<br>Project entity_bundle_plugin (7.x-1.0-beta2) downloaded to sites/all/modules/entity_bundle_plugin.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [success]<br>The following extensions will be enabled: commerce_license_billing, entity_bundle_plugin, commerce_license, advancedqueue<br>Do you really want to continue? (y/n): y<br>WD php: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for 'status': CREATE&nbsp; [error]<br>TABLE {advancedqueue} (<br>`item_id` INT unsigned NOT NULL auto_increment COMMENT 'Primary Key: Unique item ID.', <br>`name` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'The queue name.', <br>`uid` INT unsigned NOT NULL COMMENT 'The user to which the item belongs.', <br>`title` VARCHAR(400) NOT NULL COMMENT 'The title of this item.', <br>`data` LONGBLOB NULL DEFAULT NULL COMMENT 'The arbitrary data for the item.', <br>`result` LONGBLOB NULL DEFAULT NULL COMMENT 'The arbitrary result for the item, only significant if advancedqueue.status <br>0', <br>`expire` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the claim lease expires on the item.', <br>`status` TINYINT NOT NULL DEFAULT 'ADVANCEDQUEUE_STATUS_QUEUED' COMMENT 'Indicates whether the item has been processed (-1<br>= queue, 0 = processing, 1 = successfully processed, 2 = failed).', <br>`created` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the item was created.', <br>`processed` INT NOT NULL DEFAULT 0 COMMENT 'Timestamp when the item was processed.', <br>PRIMARY KEY (`item_id`), <br>INDEX `queue` (`name`, `status`, `expire`, `created`)<br>) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT 'Stores items in queues.'; Array<br>(<br>)<br> in db_create_table() (line 2720 of /home/example.com/public_html/includes/database/database.inc).<br>Cannot modify header information - headers already sent by (output started at&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; [warning]<br>/usr/share/pear/drush/includes/output.inc:38) bootstrap.inc:1224<br>PDOException: SQLSTATE[42000]: Syntax error or access violation: 1067 Invalid default value for &amp;#039;status&amp;#039;: CREATE TABLE {advancedqueue} (<br>`item_id` INT unsigned NOT NULL auto_increment COMMENT &amp;#039;Primary Key: Unique item ID.&amp;#039;, <br>`name` VARCHAR(255) NOT NULL DEFAULT &amp;#039;&amp;#039; COMMENT &amp;#039;The queue name.&amp;#039;, <br>`uid` INT unsigned NOT NULL COMMENT &amp;#039;The user to which the item belongs.&amp;#039;, <br>`title` VARCHAR(400) NOT NULL COMMENT &amp;#039;The title of this item.&amp;#039;, <br>`data` LONGBLOB NULL DEFAULT NULL COMMENT &amp;#039;The arbitrary data for the item.&amp;#039;, <br>`result` LONGBLOB NULL DEFAULT NULL COMMENT &amp;#039;The arbitrary result for the item, only significant if advancedqueue.status &lt;&gt; 0&amp;#039;, <br>`expire` INT NOT NULL DEFAULT 0 COMMENT &amp;#039;Timestamp when the claim lease expires on the item.&amp;#039;, <br>`status` TINYINT NOT NULL DEFAULT &amp;#039;ADVANCEDQUEUE_STATUS_QUEUED&amp;#039; COMMENT &amp;#039;Indicates whether the item has been processed (-1 = queue, 0 = processing, 1 = successfully processed, 2 = failed).&amp;#039;, <br>`created` INT NOT NULL DEFAULT 0 COMMENT &amp;#039;Timestamp when the item was created.&amp;#039;, <br>`processed` INT NOT NULL DEFAULT 0 COMMENT &amp;#039;Timestamp when the item was processed.&amp;#039;, <br>PRIMARY KEY (`item_id`), <br>INDEX `queue` (`name`, `status`, `expire`, `created`)<br>) ENGINE = InnoDB DEFAULT CHARACTER SET utf8 COMMENT &amp;#039;Stores items in queues.&amp;#039;; Array<br>(<br>)<br> in db_create_table() (line 2720 of /home/example.com/public_html/includes/database/database.inc).<br>Drush command terminated abnormally due to an unrecoverable error. </pre>