PDA

View Full Version : PLD_CATEGORY description


Just_a_girl
10-16-2005, 12:47 PM
How can I change the description field to longtext?
When I try to alter it i get this error:

MySQL said: Documentation
#1170 - BLOB/TEXT column 'DESCRIPTION' used in key specification without a key length

Ap0s7le
10-16-2005, 05:29 PM
Hi there.

I've not needed to do this yet, but yktan said you need to drop the field and create a new one.

If your DB already has data in it though, I've written a script that does all this for you and retains your data. I ran it on an install here and it works fine.

Have a great day :)

-Casey