AbanteCart Community

eCommerce construction => Installation and Configuration => Upgrade => Topic started by: Palamedes on April 10, 2012, 11:06:17 AM

Title: 0.92 upgrade only mysql update fails
Post by: Palamedes on April 10, 2012, 11:06:17 AM

When attempting to use either the SOURCE or the shell method of db update as provided here;
http://www.mysqlfaqs.net/mysql-faqs/Client-Server-Commands/How-to-run-SQL-script-files-in-mysql-client

the update sql script fails at both the --server line and the set @block_id line.

ERROR 1064 (42000): 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 '--server
('server', 'config_upload_max_size', '16000'),
('server', 'config_store' at line 2
Query OK, 1 row affected (0.00 sec)

ERROR 1064 (42000): 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 '' at line 1
ERROR 1064 (42000): 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 '@block_id' at line 1

~$ mysql --version
mysql  Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1

Title: Re: 0.92 upgrade only mysql update fails
Post by: Palamedes on April 11, 2012, 11:21:17 AM

This is kind of important guys..  Thoughts?

Title: Re: 0.92 upgrade only mysql update fails
Post by: Palamedes on April 12, 2012, 09:40:15 PM

Okay for the record I find it pretty uncool the lack of responses..

Title: Re: 0.92 upgrade only mysql update fails
Post by: abolabo on April 13, 2012, 07:19:38 AM

Hello.
Sorry for delay.

i have tried to upgrade db on my ubuntu linux and all fine.
First of all check this dev.mysql.com/doc/refman/5.0/en/batch-mode.html

you have to:
1 replace db prefix from table names by yours
2. remove all comments from sql (i dont' know why, but different mysql-server versions work strange with it)
3. run in shell
user@user> mysql -D your_database_name -u username -p password < abantecart_database_upgrade.sql