PLD_CATEGORY description

[Just_a_girl]

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]

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