GoFuckYourself.com - Adult Webmaster Forum - View Single Post

darnit · 08-12-2005, 05:41 PM

Hi,

Im setting up a directory script and am trying to change the description field type from VARCHAR (255 limit) to LONGTEXT to allow for longer descriptions however I'm getting the following error:

Error

SQL-query :

ALTER TABLE `PLD_LINK` CHANGE `DESCRIPTION` `DESCRIPTION` LONGTEXT DEFAULT NULL

MySQL said:

#1170 - BLOB column 'DESCRIPTION' used in key specification without a key length

Ive tried setting the lenght to 1000 but the error still occurs.

08-12-2005, 05:41 PM
darnit Confirmed User Join Date: Jul 2001 Location: Teh Interweb Posts: 2,439	Geeky MySQL Problem Hi, Im setting up a directory script and am trying to change the description field type from VARCHAR (255 limit) to LONGTEXT to allow for longer descriptions however I'm getting the following error: Error SQL-query : ALTER TABLE `PLD_LINK` CHANGE `DESCRIPTION` `DESCRIPTION` LONGTEXT DEFAULT NULL MySQL said: #1170 - BLOB column 'DESCRIPTION' used in key specification without a key length Ive tried setting the lenght to 1000 but the error still occurs.