SQL errors upgrading from v4 (drupal5->drupal6)

jrychter - March 12, 2009 - 13:13
Project:Simple Access
Version:6.x-2.x-dev
Component:Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:active
Description

I have upgraded my Drupal from 5 to 6, installed the new simple_access module and ran update.php.

I get the following errors:

The following queries were executed
simple_access module
Update #4
No queries
Update #5
Failed: CREATE TABLE {simple_access_owner} ) /*!40100 DEFAULT CHARACTER SET UTF8 */
INSERT INTO {simple_access_owner} SELECT nid, 1, 1, 1 FROM {node};
Update #6
Failed: ALTER TABLE {simple_access_node} CHANGE `view` `sa_view` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_node} CHANGE `update` `sa_update` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_node} CHANGE `delete` `sa_delete` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_profiles_access} CHANGE `view` `sa_view` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_profiles_access} CHANGE `update` `sa_update` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_profiles_access} CHANGE `delete` `sa_delete` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_owner} CHANGE `view` `sa_view` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_owner} CHANGE `update` `sa_update` TINYINT unsigned NOT NULL DEFAULT 0
Failed: ALTER TABLE {simple_access_owner} CHANGE `delete` `sa_delete` TINYINT unsigned NOT NULL DEFAULT 0
Update #7
ALTER TABLE {simple_access_groups} CHANGE weight `weight` TINYINT NOT NULL DEFAULT 0
ALTER TABLE {simple_access_profiles} CHANGE weight `weight` TINYINT NOT NULL DEFAULT 0

More detailed information:

warning: Invalid argument supplied for foreach() in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 69.
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 ') /*!40100 DEFAULT CHARACTER SET UTF8 */' at line 2 query: CREATE TABLE simple_access_profiles ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/test2.rychter.com/pages/includes/database.inc on line 515.
warning: Invalid argument supplied for foreach() in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 69.
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 ') /*!40100 DEFAULT CHARACTER SET UTF8 */' at line 2 query: CREATE TABLE simple_access_profiles_access ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/test2.rychter.com/pages/includes/database.inc on line 515.
warning: Invalid argument supplied for foreach() in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 69.
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 ') /*!40100 DEFAULT CHARACTER SET UTF8 */' at line 2 query: CREATE TABLE simple_access_profiles_node ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/test2.rychter.com/pages/includes/database.inc on line 515.
user warning: Table 'simple_access_node' already exists query: CREATE TABLE simple_access_node ( `nid` INT unsigned NOT NULL DEFAULT 0, `gid` INT unsigned NOT NULL DEFAULT 0, `sa_view` TINYINT unsigned NOT NULL DEFAULT 0, `sa_update` TINYINT unsigned NOT NULL DEFAULT 0, `sa_delete` TINYINT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (nid, gid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/test2.rychter.com/pages/includes/database.inc on line 515.
user warning: Table 'simple_access_groups' already exists query: CREATE TABLE simple_access_groups ( `gid` INT NOT NULL auto_increment, `name` VARCHAR(50) NOT NULL, `weight` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (gid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/test2.rychter.com/pages/includes/database.inc on line 515.
user warning: Table 'simple_access_roles' already exists query: CREATE TABLE simple_access_roles ( `gid` INT unsigned NOT NULL DEFAULT 0, `rid` INT unsigned NOT NULL DEFAULT 0, PRIMARY KEY (gid, rid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/test2.rychter.com/pages/includes/database.inc on line 515.
warning: Invalid argument supplied for foreach() in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 69.
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 ') /*!40100 DEFAULT CHARACTER SET UTF8 */' at line 2 query: CREATE TABLE simple_access_owner ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /www/test2.rychter.com/pages/includes/database.inc on line 515.
user warning: Unknown column 'view' in 'simple_access_node' query: ALTER TABLE simple_access_node CHANGE `view` `sa_view` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'update' in 'simple_access_node' query: ALTER TABLE simple_access_node CHANGE `update` `sa_update` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'delete' in 'simple_access_node' query: ALTER TABLE simple_access_node CHANGE `delete` `sa_delete` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'view' in 'simple_access_profiles_access' query: ALTER TABLE simple_access_profiles_access CHANGE `view` `sa_view` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'update' in 'simple_access_profiles_access' query: ALTER TABLE simple_access_profiles_access CHANGE `update` `sa_update` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'delete' in 'simple_access_profiles_access' query: ALTER TABLE simple_access_profiles_access CHANGE `delete` `sa_delete` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'view' in 'simple_access_owner' query: ALTER TABLE simple_access_owner CHANGE `view` `sa_view` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'update' in 'simple_access_owner' query: ALTER TABLE simple_access_owner CHANGE `update` `sa_update` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.
user warning: Unknown column 'delete' in 'simple_access_owner' query: ALTER TABLE simple_access_owner CHANGE `delete` `sa_delete` TINYINT unsigned NOT NULL DEFAULT 0 in /www/test2.rychter.com/pages/includes/database.mysql-common.inc on line 520.

I don't understand why the corrupt SQL statement is being generated, so I am unable to fix the problem...

 
 

Drupal is a registered trademark of Dries Buytaert.