Expand the limits on Forum Description

[Cyricx]

There's some html coding and such I'm wanting to use in my forum description areas but alas when doing some of them tey exceed the 250 character limit.

I'm guessing it's a mysql query I need to run to increase the varchar for the description column on the forum table.

I've tried -

alter table forum.description varchar(500);

but it won't accept the syntax when it sees varchar =/

Anyone have any ideas on the syntax I'll need? =/

Thanks in advance!

[Cyricx]

NM, figured out a work around using templates. :)

[Black Vivi]

i kno u found anuther way, but just thought id let u kno varchar's maxlength is 255
ud have to chnage it to smalltext, tinytext or mediumtext

[Cyricx]

Ah kewl, thanks for the info :).

Was wondering if that could have been part of the problem. :)

[locatha]

Could you or someone explain how i could change the limit in the descriptions to something longer, i wish to use some HTML in there, just basic color codes and the like, but the 255 character limit makes that difficult. But if someone could give me some step and step instructions on how to do it, that would be great. Thanks.

[duboisi]

Someone please update this, if you know any way to expand the limits on the forum description, it would be quite helpful to me at this moment.

Thanks!

[g-force2k2]

Just run this query if you have MySQL Version 3.22.16a OR better
ALTER TABLE forum MODIFY description MEDIUMTEXT NOT NULL

OR run this query.
ALTER TABLE forum CHANGE description description MEDIUMTEXT NOT NULL

Regards,
g-force2k2

[duboisi]

I don't know how to do this. I realize that its probably pretty simple to run a query, but unfortunately, I've never learned this.

It seems quick and easy, can someone possible give instructions or help me out?

Happy New Year BTW!

[g-force2k2]

You can run the query via phpmyadmin or you can download FireFly's hack that allows you to run queries via admncp.

Regards,
g-force2k2

[ashley53680]

I was coming here to ask the very same thing...

Where is firefly's hack? (sorry I couldn't find it)

[duboisi]

It was actually very easy for me to run that query in my host's php control panel, worked great!

Thanks!

[ashley53680]

okay I found that I could also run the query on my control panel... I *think* I found what I need to edit, but how do you edit it?

[ashley53680]

nevermind, I got it!

I switched it to blob instead of the other choices.. is that okay too??