Followed SQL errors when updating to version 6101:
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE field = 'wid' and extra REGEXP 'auto_increment'' at line 1 query: SHOW COLUMNS FROM workflows WHERE field = 'wid' and extra REGEXP 'auto_increment' in /home/xcomkids/public_html/sites/all/modules/contributions/workflow/workflow.install on line 403.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE field = 'sid' and extra REGEXP 'auto_increment'' at line 1 query: SHOW COLUMNS FROM workflow_states WHERE field = 'sid' and extra REGEXP 'auto_increment' in /home/xcomkids/public_html/sites/all/modules/contributions/workflow/workflow.install on line 404.
user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE field = 'tid' and extra REGEXP 'auto_increment'' at line 1 query: SHOW COLUMNS FROM workflow_transitions WHERE field = 'tid' and extra REGEXP 'auto_increment' in /home/xcomkids/public_html/sites/all/modules/contributions/workflow/workflow.install on line 405.
user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE workflows DROP PRIMARY KEY in /home/xcomkids/public_html/includes/database.mysql-common.inc on line 386.
user warning: Multiple primary key defined query: ALTER TABLE workflows CHANGE wid `wid` INT NOT NULL auto_increment, ADD PRIMARY KEY (wid) in /home/xcomkids/public_html/includes/database.mysql-common.inc on line 520.
user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE workflow_states DROP PRIMARY KEY in /home/xcomkids/public_html/includes/database.mysql-common.inc on line 386.
user warning: Multiple primary key defined query: ALTER TABLE workflow_states CHANGE sid `sid` INT NOT NULL auto_increment, ADD PRIMARY KEY (sid) in /home/xcomkids/public_html/includes/database.mysql-common.inc on line 520.
user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE workflow_transitions DROP PRIMARY KEY in /home/xcomkids/public_html/includes/database.mysql-common.inc on line 386.
user warning: Multiple primary key defined query: ALTER TABLE workflow_transitions CHANGE tid `tid` INT NOT NULL auto_increment, ADD PRIMARY KEY (tid) in /home/xcomkids/public_html/includes/database.mysql-common.inc on line 520.
The following queries were executed
workflow module
Update #6100
ALTER TABLE {workflows} ADD `options` LONGTEXT DEFAULT NULL
UPDATE {workflows} SET options = 'a:2:{s:16:"comment_log_node";i:1;s:15:"comment_log_tab";i:1;}'
Update #6101
Failed: ALTER TABLE {workflows} DROP PRIMARY KEY
Failed: ALTER TABLE {workflows} CHANGE wid `wid` INT NOT NULL auto_increment, ADD PRIMARY KEY (wid)
Failed: ALTER TABLE {workflow_states} DROP PRIMARY KEY
Failed: ALTER TABLE {workflow_states} CHANGE sid `sid` INT NOT NULL auto_increment, ADD PRIMARY KEY (sid)
Failed: ALTER TABLE {workflow_transitions} DROP PRIMARY KEY
Failed: ALTER TABLE {workflow_transitions} CHANGE tid `tid` INT NOT NULL auto_increment, ADD PRIMARY KEY (tid)
Comments
Comment #1
jvandyk commentedhttp://drupal.org/node/353798