[SOLVED] #1064 - You have an error in your SQL syntax;

[valcon54]

Hello everyone.

Setup;

MySQL client version: 4.1.22

Server version: 4.1.22-standard

MySQL charset: UTF-8 Unicode (utf8)

phpMyAdmin - 2.11.0

 

 

Error

SQL query:

 

# --------------------------------------------------------

#

# Table structure for table `site_menu`

#

CREATE TABLE site_menu(

 

id int( 255 ) NOT NULL AUTO_INCREMENT ,

FILE text,

date int( 255 ) default NULL ,

ORDER int( 255 ) default NULL ,

PRIMARY KEY ( id )

) TYPE = MYISAM ;

 

 

 

MySQL said: 

 

#1064 - 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 'order int(255) default NULL,

  PRIMARY KEY  (id)

) TYPE=MyISAM' at line 5

 

I exported the sql data from one server running and older version and now im getting this error and dont understand how to fix it. I was told that ORDER is a reserved word that is causing this error.

 

any suggestions on how to fix this

 

[revraz]

Change your field name ORDER to something else since it's a reserved word.  You could use backticks around it, but you really should change it because you will be doing querries ORDER BY and you may confuse yourself.

 

Also, change the field name DATE too.

[valcon54]

Thanks for the reply now i understand whats going on. The pain starts now cause i have the edit a bunch of files for the php code to rename ORDER and DATE.