Sql problum-any help appreciated very much

New Member Joined: May 17, 2007 Posts: 12

hello, when i try to import sql (spplied with a php nuke mod) i get the following error:

Code i am trying to import:-

Code:

CREATE TABLE nuke_simpleshop (


id int(255) NOT NULL auto_increment,


sku varchar(255) NOT NULL default '',


name varchar(255) NOT NULL default '',


description longtext NOT NULL default '',


price varchar(30) NOT NULL default '',


image varchar(30) NOT NULL default '',


category varchar(30) NOT NULL default '',


spotlight varchar(30) NOT NULL default '',


condition varchar(30) NOT NULL default '',


status varchar(30) NOT NULL default '',


provider varchar(30) NOT NULL default '',


contact varchar(30) NOT NULL default '',


deal varchar(30) NOT NULL default '',


hits int(255) NOT NULL default '',


  PRIMARY KEY  (id)


) TYPE=MyISAM;

Error I get:-

Code:

MySQL said: Documentation


#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 'condition varchar(30) NOT NULL default '',


status varchar(30) NOT NULL default ' at line 10

TYVM

registered · Posted: Tue May 22, 2007 10:30 am

Worked for me. Do you have spaces or tabs before each line? Might try remove those if there are

registered · Posted: Wed May 23, 2007 5:57 am

I don't recall where I read it, so sorry, but I think "id" might be a reserved word in one of hte mySQL versions. arun4444, you may want to do a search on the mySQL site for "reserved words" as it pertains to your mySQL version.

Posted: Wed May 23, 2007 7:33 am

thank you very much Smile

condition was a reserved word. used backticks

ty very much

Posted: Wed May 23, 2007 6:44 pm

scary to use backticks. better use prefixes

Posted: Fri May 25, 2007 6:09 am

For others interested in the various lists of Reserved Words, here they are:

Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login!

Not sure where I read about "id"... going to have to keep searching, but regardless, doesn't matter. It cause you to look in the right place anyways and get yourself up and running. That is a good thing.