Can anyone see anything wrong with this query?
CREATE TABLE cms ( id int(10) unsigned NOT NULL auto_increment, name varchar(128) NOT NULL default '', bild varchar(128) binary NOT NULL default '', Deutsch text, Espanol text, Deutschhead varchar(255) NOT NULL default '', Espanolhead varchar(255) NOT NULL default '', English text NOT NULL, Englishhead varchar(255) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY name (name), KEY Oesterreichischhead (Espanolhead), KEY Oesterreichischhead_2 (Espanolhead), KEY Deutschhead (Deutschhead), KEY Oesterreichischhead_3 (Espanolhead), FULLTEXT KEY Oesterreichischhead_4 (Espanolhead), KEY Englishhead (Englishhead) ) TYPE=MyISAM
It has been bugging me all day. It works fine on certain servers, but on a couple, it spews up a SQL error;
MySQL said: You have an error in your SQL syntax near 'KEY Oesterreichischhead_4 (Espanolhead), KEY Englishhead (Englishhead) ) TYPE=M' at line 1.
Anyone got any ideas? I've been playing over this all day
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
CREATE TABLE cms ( id int(10) unsigned NOT NULL auto_increment, name varchar(128) NOT NULL default '', bild varchar(128) binary NOT NULL default '', Deutsch text, Espanol text, Deutschhead varchar(255) NOT NULL default '', Espanolhead varchar(255) NOT NULL default '', English text NOT NULL, Englishhead varchar(255) NOT NULL default '', PRIMARY KEY (id), UNIQUE KEY name (name), KEY Oesterreichischhead (Espanolhead), KEY Oesterreichischhead_2 (Espanolhead), KEY Deutschhead (Deutschhead), KEY Oesterreichischhead_3 (Espanolhead), FULLTEXT KEY Oesterreichischhead_4 (Espanolhead), KEY Englishhead (Englishhead) ) TYPE=MyISAM
It has been bugging me all day. It works fine on certain servers, but on a couple, it spews up a SQL error;
MySQL said: You have an error in your SQL syntax near 'KEY Oesterreichischhead_4 (Espanolhead), KEY Englishhead (Englishhead) ) TYPE=M' at line 1.
Anyone got any ideas? I've been playing over this all day
Cheers
Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
CREATe problems...