While installing the Store component of the eCommerce module, on a drupal site, backed by a MySQL 5.0.77 database server, I got the following error:

* user warning: BLOB/TEXT column 'help' can't have a default value query: CREATE TABLE ec_workflow_statuses ( `workflow` INT unsigned NOT NULL auto_increment, `description` VARCHAR(255) NOT NULL, `help` TEXT NOT NULL DEFAULT '', `type` INT unsigned NOT NULL DEFAULT 0, `weight` INT NOT NULL, PRIMARY KEY (workflow) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\includes\database.inc on line 515.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (1, 'received', 0, 1) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (2, 'invoiced', 0, 2) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (10, 'in picking', 0, 3) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (8, 'packaged', 0, 4) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (3, 'shipped', 0, 5) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (4, 'awaiting customer response', 1, 6) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (5, 'canceled', 2, 7) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (6, 'completed', 1, 8) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
    * user warning: Table 'sengiit_dev.ec_workflow_statuses' doesn't exist query: INSERT INTO ec_workflow_statuses (workflow, description, type, weight) VALUES (7, 'security violation', 0, 9) in D:\Srv\Apache\htdocs\projects\sengi.it\sengiit-dev\sites\all\modules\ecommerce\ec_store\ec_store.install on line 32.
CommentFileSizeAuthor
#4 ec_store-text-fields-410498-4.patch3.36 KBazovsky
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

gordon’s picture

gordon CreditAttribution: gordon commented
Status: Active » Fixed

Thanks I have fixed this in dev. Will be apart of rc1

Anonymous’s picture

Anonymous (not verified) CreditAttribution: Anonymous commented

ok, good done! :)

Status: Fixed » Closed (fixed)

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

azovsky’s picture

azovsky CreditAttribution: azovsky commented
Version: 6.x-4.0-beta7 » 6.x-4.x-dev
Status: Closed (fixed) » Active
FileSize
ec_store-text-fields-410498-4.patch3.36 KB

The Error is still there in the latest version 6.x-4.x-dev 2012-Apr-29.
In ec_store.install file.

For fields with type 'text' need to remove 'default' and 'not null' attributes.

Here is a patch.