When I tried to upgrade from 6.x-2.0-b3 to 6x-2.x-dev (build date 2008-Sep-29) I got the following errors:

    * 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 'TO view_old' at line 1 query: ALTER TABLE simple_access_node RENAME view TO view_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'view_old' in 'field list' query: UPDATE simple_access_node SET sa_view = view_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'view_old'; check that column/key exists query: ALTER TABLE simple_access_node DROP view_old in /var/www/update.php on line 130.
    * 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 'update TO update_old' at line 1 query: ALTER TABLE simple_access_node RENAME update TO update_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'update_old' in 'field list' query: UPDATE simple_access_node SET sa_update = update_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'update_old'; check that column/key exists query: ALTER TABLE simple_access_node DROP update_old in /var/www/update.php on line 130.
    * 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 'delete TO delete_old' at line 1 query: ALTER TABLE simple_access_node RENAME delete TO delete_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'delete_old' in 'field list' query: UPDATE simple_access_node SET sa_delete = delete_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'delete_old'; check that column/key exists query: ALTER TABLE simple_access_node DROP delete_old in /var/www/update.php on line 130.
    * 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 'TO view_old' at line 1 query: ALTER TABLE simple_access_profiles_access RENAME view TO view_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'view_old' in 'field list' query: UPDATE simple_access_profiles_access SET sa_view = view_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'view_old'; check that column/key exists query: ALTER TABLE simple_access_profiles_access DROP view_old in /var/www/update.php on line 130.
    * 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 'update TO update_old' at line 1 query: ALTER TABLE simple_access_profiles_access RENAME update TO update_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'update_old' in 'field list' query: UPDATE simple_access_profiles_access SET sa_update = update_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'update_old'; check that column/key exists query: ALTER TABLE simple_access_profiles_access DROP update_old in /var/www/update.php on line 130.
    * 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 'delete TO delete_old' at line 1 query: ALTER TABLE simple_access_profiles_access RENAME delete TO delete_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'delete_old' in 'field list' query: UPDATE simple_access_profiles_access SET sa_delete = delete_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'delete_old'; check that column/key exists query: ALTER TABLE simple_access_profiles_access DROP delete_old in /var/www/update.php on line 130.
    * 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 'TO view_old' at line 1 query: ALTER TABLE simple_access_owner RENAME view TO view_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'view_old' in 'field list' query: UPDATE simple_access_owner SET sa_view = view_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'view_old'; check that column/key exists query: ALTER TABLE simple_access_owner DROP view_old in /var/www/update.php on line 130.
    * 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 'update TO update_old' at line 1 query: ALTER TABLE simple_access_owner RENAME update TO update_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'update_old' in 'field list' query: UPDATE simple_access_owner SET sa_update = update_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'update_old'; check that column/key exists query: ALTER TABLE simple_access_owner DROP update_old in /var/www/update.php on line 130.
    * 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 'delete TO delete_old' at line 1 query: ALTER TABLE simple_access_owner RENAME delete TO delete_old in /var/www/update.php on line 125.
    * user warning: Unknown column 'delete_old' in 'field list' query: UPDATE simple_access_owner SET sa_delete = delete_old in /var/www/update.php on line 127.
    * user warning: Can't DROP 'delete_old'; check that column/key exists query: ALTER TABLE simple_access_owner DROP delete_old in /var/www/update.php on line 130.

Comments

gordon’s picture

gordon commented
Status: Active » Fixed

This has now been fixed and you will will need to delete the sa_* columns from the 3 tables above, and rerun update 6.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

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