1
ManXP
MySQL Syntaxt Error
  • 2005/10/14 12:04

  • ManXP

  • Quite a regular

  • Posts: 231

  • Since: 2003/8/14


Hello,

My server is running MySQL 4.0.15. I backed up my XOOPS database and now when I need to restore it, I get an error about wrong MySQL syntax. The error is somewhere here (it's a quote from backup query):

........................
........................
  
KEY join (instanceid,visible,weight)
TYPE=MyISAM;


So error is displayed and other tables are not restored too. Do you have any ideas how should I change this syntax or fix a problem in any other way?

I searched Google for 2 hours and found nothing useful

2
rowdie
Re: MySQL Syntaxt Error
  • 2005/10/14 17:14

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


'join' is a reserved word in mysql.

Change the word 'join' to something else (doesn't matter what, as long as it's not another reserved word ) and it should work.

Rowd

MySQL reference : reserved words

3
ManXP
Re: MySQL Syntaxt Error
  • 2005/10/14 21:11

  • ManXP

  • Quite a regular

  • Posts: 231

  • Since: 2003/8/14


Thank you very much!

Worked just fine

Login

Who's Online

399 user(s) are online (306 user(s) are browsing Support Forums)


Members: 0


Guests: 399


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits