#1170 key specification without a key length

[grace5]

I know very little about MySQL

 

I am trying to alter a table for descriptions from a varchar(255) to a TEXT

as I want more space for description lenght.

I have tried this:

 

 

 

SQL query:

 

ALTER TABLE jade_sites CHANGE description description TEXT NOT NULL

 

MySQL said: 

 

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

 

 

 

if I try to edit thru phpMyAdmin

I get this error:

 

ALTER TABLE `jade_sites` CHANGE `description` `description` TEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL

 

MySQL said: 

 

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

 

 

any help would be thankfully received!

 

 

 

 

[AndyB]

ALTER TABLE `videos` CHANGE `artist` `artist` TEXT NOT NULL

 

That, and just that, worked perfectly for me when changing one of my tables. So try

 

ALTER TABLE `jade_sites` CHANGE `description` `description` TEXT NOT NULL

[grace5]

I get the same error:

 

 

Error

SQL query:

 

ALTER TABLE `jade_sites` CHANGE `description` `description` TEXT NOT NULL

 

MySQL said: 

 

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

 

[fenway]

That's because you have a key on this column... drop the key first.

[grace5]

how exactly is that done?

[fenway]

Show me the SHOW CREATE TABLE output...

[grace5]

how do I do that?

(sorry I am really not trying to be humble,I really don't know much about MySQL myphpadmin)

 

could this be it?

CREATE TABLE jade_sites ( id smallint(6) NOT NULL auto_increment, title varchar(100) NOT NULL default '0', url varchar(255) NOT NULL default '', dateadd datetime NOT NULL default '0000-00-00 00:00:00', id_cat smallint(6) NOT NULL default '0', description varchar(255) NOT NULL default '',

[bubblegum.anarchy]

grace5 - your create statement appears to be missing key/index definitions....is a index on `description` really necessary?

 

consider removing the index on `description` (removing the index may have adverse effects):

 

ALTER TABLE jade_sites

    DROP INDEX description,

    MODIFY description TEXT NOT NULL;

 

[grace5]

DROP INDEX description

 

thats  the  info I need to keep...

[grace5]

hey this was not solved,I have never replied as last poster did not (or was not clear) on what my happen if I "DROP index"

[bubblegum.anarchy]

I do not know what the `adverse affects` may be - but you can drop the index and then add the index later if the site slows of breaks, though the site should not break for lack of an index as far as I know.