SQL errors upgrading from v4 (drupal5->drupal6)
| Project: | Simple Access |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
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...
