By titouille on

Hello forum !!

I need some help, please. It's a stress installation, and I don't know how to resolve my problem...
When I import my sql script into the phpmyadmin interface, I have the following error displayed :

#
# Table structure for table 'locales_source'
#
CREATE TABLE /*!32300 IF NOT EXISTS*/locales_source(

lid int( 11 ) NOT NULL AUTO_INCREMENT ,
location varchar( 255 ) NOT NULL DEFAULT '',
source blob NOT NULL DEFAULT '',
PRIMARY KEY ( lid ) ,
INDEX source( source )
);

MySQL answer :

#1170 - BLOB/TEXT column 'source' used in key specification without a key length

I don't know how to resolve it... the server is a mysql 5 server.

Please help is required :)

Thanks in advance

⋅ Categories: Drupal 5.x

Comments

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

TEXT/BLOB indeces need a length specifed.

See http://forums.mysql.com/read.php?10,113556,113556#msg-113556 for example.

Here's the code used by locale.install, it should work.


#
# Table structure for table 'locales_source'
#
CREATE TABLE /*!32300 IF NOT EXISTS*/locales_source(
lid int( 11 ) NOT NULL AUTO_INCREMENT ,
location varchar( 255 ) NOT NULL DEFAULT '',
source blob NOT NULL DEFAULT '',
PRIMARY KEY ( lid ) ,
INDEX source( source( 30 ) )
)

You can generally find quick answers to these types of errors by Googling the last part of the error message.

http://www.google.com/search?q=used+in+key+specification+without+a+key+l...

--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.

titouille’s picture

titouille
Primary language French
commented

Thanks for your answer, it was ok with the add of the length.

I have searched on the web before posting it, but no found answer... I think it's because I had too many words for the search...

Thank you

http://www.sabugo.ch
http://www.titouille.ch

agentrickard’s picture

agentrickard
he/him
Primary language English
Location Georgia (US)
commented

Yes, often Google works better if you only use the last part of the error message. That's because the first part can contain installation-specific data.

--
http://ken.blufftontoday.com/
http://new.savannahnow.com/user/2
Search first, ask good questions later.