Gossamer Forum
Home : General : Databases and SQL :

CREATe problems...

Quote Reply
CREATe problems...
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 Unsure

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!
Quote Reply
Re: [Andy] CREATe problems... In reply to
Anyone? Unsure

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!
Quote Reply
Re: [Andy] CREATe problems... In reply to
My first reaction wsa that maybe the key name is too long - that's just a guess.
Quote Reply
Re: [Paul] CREATe problems... In reply to
I tried removing the KEY stuff...and that didn't do anything. I've done it on my server, and it went fine. It must be a version thing. I've emailed the owner of the server I'm trying to install it on, and asked him if upgrading MySQL is a possibility. If not, then I told him the script will not be installable Frown

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!
Quote Reply
Re: [Andy] CREATe problems... In reply to
The version of MySQL they are using probably does not support full text indexes.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] CREATe problems... In reply to
Is there any way around this? According to their host, they are using version 3.22.32.

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!
Quote Reply
Re: [Andy] CREATe problems... In reply to
Quote:
As of Version 3.23.23, MySQL has support for full-text indexing and searching.


Quote:
Is there any way around this?


Yeah don't use full text =)

Last edited by:

Paul: Apr 5, 2003, 1:29 AM
Quote Reply
Re: [Paul] CREATe problems... In reply to
What I mean is, can I just edit the query so it doesn't use full text? Will it affect the script in any way? I've never used FULLTEXT stuff in my scripts....so I don't really know much about it Tongue

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!
Quote Reply
Re: [Andy] CREATe problems... In reply to
If the query is using FULL TEXT then yes, the query will fail.
Quote Reply
Re: [Paul] CREATe problems... In reply to
Ok...thanks Frown

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!