AbanteCart Community
eCommerce construction => Installation and Configuration => Upgrade => Topic started 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
-
This is kind of important guys.. Thoughts?
-
Okay for the record I find it pretty uncool the lack of responses..
-
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