Database Upgrade issue 1.6.0 to 1.6.2

[Jim Riley]

I am attempting to upgrade my current database installed at 1.6.0 (everything has been working fine, but I need some of the VeriSign fixes) so I followed the instructions about upgrading the database by downloading the database upgrade files from the Squirrel cart site then through the shopping cart admin interface I loaded the "1[1].6.1_to_1.6.2_upgrade.sql" file. While running the "inport database backup file" utility (third icon in the options column) per the instructions. I received the following error...

Database Utilities

MySQL Error 1064 encountered on line #11: 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 'h################################################ ##############
Query was: h################################################# ################### ALTER TABLE `Warehouses` ADD `VAT_Enabled` TINYINT( 1 ) NOT NULL AFTER `Description` ;
No rows affected.

....
I saved a backup of my database but I didn't change anything else releated to the upgrade 1.6.0 to 1.6.2. Is there an issue with upgrading from 1.6.0 to 1.6.2? I didn't see that a database upgrade file is available for 1.6.0 to 1.6.1

Thanks for your help.

[Jim Riley]

After looking at a ton of help files I finally looked at the database update file with a source file editor. I'm not sure how but the first line of the update file had 'h' as the first character in the line of "#####", which I assumed to be comment indicators. Not knowing the syntax of this file I just removed the 'h' from the first line and re-ran the process. It worked.