[RESOLVED] SQL syntax error..help!

Lucidious

I know absolutely nothing about SQL, yet I decided to download a db and upload it back to the server just out of curiosity. My site is now missing the top menu and components menu in the backend of Mambo. This site is for a client and I'm in big trouble here. I would really appreciate any help.

SQL query:

CREATE TABLE mos_components(

id int( 11 ) NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
link varchar( 255 ) NOT NULL default '',
menuid int( 11 ) unsigned NOT NULL default '0',
parent int( 11 ) unsigned NOT NULL default '0',
admin_menu_link varchar( 255 ) NOT NULL default '',
admin_menu_alt varchar( 255 ) NOT NULL default '',
OPTION varchar( 50 ) NOT NULL default '',
ordering int( 11 ) NOT NULL default '0',
admin_menu_img varchar( 255 ) NOT NULL default '',
iscore tinyint( 4 ) NOT NULL default '0',
params text NOT 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 'option varchar(50) NOT NULL default '',
ordering int(11) NOT

I can see that it is "option" that is causing the trouble, I have errors in other tables with entries such as "table" and "type" as well. Help!

fr600

You cannot use OPTION, change it to something else and it should work.

Lucidious

Thanks for the reply. I did change it to "options" and my components load, but functions are missing such as installing and uninstalling components. This is why I'm baffled here, because it worked before somehow. The option command is in my php files. I get the feeling that somehow, the db that I downloaded is not the same db that was running. How and why would it change?

nemonoman

Don't do dumb stuff like this with production databases!!!

Here's the fix: Backticks around the word OPTION ==> OPTION
Also since none of the other column names are all caps, it's LIKELY that the original database column name was option

CREATE TABLE mos_components(

id int( 11 ) NOT NULL AUTO_INCREMENT ,
name varchar( 50 ) NOT NULL default '',
link varchar( 255 ) NOT NULL default '',
menuid int( 11 ) unsigned NOT NULL default '0',
parent int( 11 ) unsigned NOT NULL default '0',
admin_menu_link varchar( 255 ) NOT NULL default '',
admin_menu_alt varchar( 255 ) NOT NULL default '',
OPTION varchar( 50 ) NOT NULL default '',
ordering int( 11 ) NOT NULL default '0',
admin_menu_img varchar( 255 ) NOT NULL default '',
iscore tinyint( 4 ) NOT NULL default '0',
params text NOT NULL ,
PRIMARY KEY ( id )
) TYPE = MYISAM

Lucidious

Ah thanks a million, that did the trick. LOL yes very dumb. But hey, at least I got a taste of SQL :o