Upgrade 7.0.9-7.1 - syntax error

Hello,

I am going to try and test upgrade my 7.0.9 to 7.1x, and I started per the instructions with the Upgrade Instructions from 7.0.9 to 7.1.0 page at: http://www.boonex.com/trac/dolphin/wiki/7.0.9-7.1.0.

I did everything, ran the upgrade script, and got this:

ALTER TABLE `sys_menu_bottom`ADD `Visible` set('non','memb') NOT NULL DEFAULT '',ADD `Active` tinyint(1) NOT NULL DEFAULT '1',ADD `Movable` tinyint(1) NOT NULL DEFAULT '1',ADD `Clonable` tinyint(1) NOT NULL DEFAULT '1',ADD `Editable` tinyint(1) NOT NULL DEFAULT '1',ADD `Deletable` tinyint(1) NOT NULL DEFAULT '1';: Duplicate column name 'Visible' 

After researching, I figured I could comment out the top lines in the sql file, since it appeared those objects were up to date, but then, I got to this:

ALTER TABLE `sys_menu_bottom`ALTER TABLE `sys_email_templates` CHANGE `ID` `ID` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;: 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 'TABLE `sys_email_templates` CHANGE `ID` `ID` INT(11) UNSIGNED NOT NULL AUTO_INCR' at line 1 

What am I doing wrong?

I have MySQL 5.1.70, Apache 2.2.25, PHP 5.4.20

Thank you!

I am also getting these emails, and not sure why from my Beta / test server upgrade.  I am guessing because it hasn't upgraded yet, but thought I would add it:

Database error in The Black Vault

Query:

SELECT * FROM `sys_objects_member_info` WHERE `object` = ''

Mysql error: Table 'blackvaultcom_beta.sys_objects_member_info' doesn't exist

Found error in the file '/home/beta/public_html/inc/classes/BxDolMemberInfoQuery.php' at line 27.
Called 'getRow' function with erroneous argument #0.

Your best bet would be to start over with files and database and check table sys_options and look for sys_temp_version and see if it says 7.0.9 or 7.1.0...  

seems to me you might have applied a beta upgrade for 7.1.0 a while ago or something. 

If you need a hand with it or just a second set of eyes let me know.  

I suggest you start from the beginning again if you can. That means restoring your 7.0.9 backup and repeating the whole procedure.

The errors you're getting are getting is because you did not copy the full syntax. It's AUTO_INCREMENT and not
AUTO_INCR

The second issue is because the script is looking for a non existing table sys_objects_member_info It could be that you missed out a step in the installation or that you just did not get that far (I did not read the upgrade instructions).

Hope this helps and good luck upgrading!

Don't forget that any custom templates will no longer work after the upgrade!

The sys_tmp_version does say 7.0.9 after restoring the database.

I am copying over the old files (takes forever, I have a huge site) so will try again.

okay, well i'll be around for a couple more hours tonight.