Gossamer Forum: General: Databases and SQL: CREATe problems...

Apr 2, 2003, 9:18 AM

Andy

Veteran / Moderator (18436 posts)

Apr 2, 2003, 9:18 AM

Post #1 of 10

Shortcut

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

Apr 3, 2003, 1:04 AM

Andy

Veteran / Moderator (18436 posts)

Apr 3, 2003, 1:04 AM

Post #2 of 10

Shortcut

Re: [Andy] CREATe problems... In reply to

Anyone?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Apr 3, 2003, 1:20 AM

Paul

Veteran (19537 posts)

Apr 3, 2003, 1:20 AM

Post #3 of 10

Shortcut

Re: [Andy] CREATe problems... In reply to

My first reaction wsa that maybe the key name is too long - that's just a guess.

Apr 3, 2003, 1:42 AM

Andy

Veteran / Moderator (18436 posts)

Apr 3, 2003, 1:42 AM

Post #4 of 10

Shortcut

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

Apr 4, 2003, 10:47 AM

Alex

Administrator (9387 posts)

Apr 4, 2003, 10:47 AM

Post #5 of 10

Shortcut

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.

Apr 5, 2003, 1:25 AM

Andy

Veteran / Moderator (18436 posts)

Apr 5, 2003, 1:25 AM

Post #6 of 10

Shortcut

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

Apr 5, 2003, 1:29 AM

Paul

Veteran (19537 posts)

Apr 5, 2003, 1:29 AM

Post #7 of 10

Shortcut

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

Apr 5, 2003, 1:43 AM

Andy

Veteran / Moderator (18436 posts)

Apr 5, 2003, 1:43 AM

Post #8 of 10

Shortcut

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