Author Topic: 0.92 upgrade only mysql update fails  (Read 13733 times)

Offline Palamedes

  • Newbie
  • *
  • Posts: 36
  • Karma: +5/-0
    • View Profile
    • RandomStringOfWords
0.92 upgrade only mysql update fails
« 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
~Pal

Offline Palamedes

  • Newbie
  • *
  • Posts: 36
  • Karma: +5/-0
    • View Profile
    • RandomStringOfWords
Re: 0.92 upgrade only mysql update fails
« Reply #1 on: April 11, 2012, 11:21:17 AM »
This is kind of important guys..  Thoughts?
~Pal

Offline Palamedes

  • Newbie
  • *
  • Posts: 36
  • Karma: +5/-0
    • View Profile
    • RandomStringOfWords
Re: 0.92 upgrade only mysql update fails
« Reply #2 on: April 12, 2012, 09:40:15 PM »
Okay for the record I find it pretty uncool the lack of responses..
~Pal

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: 0.92 upgrade only mysql update fails
« Reply #3 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

“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

 

Powered by SMFPacks Social Login Mod