Putting more characters at the forum description field...?

[stark427]

Hello there...

In my board I have several subforums.
Now, what I wanna do is that i want to be able to put more characters (than the number that is allowed now) into the description field of the forums...

Why do I need this?

as you see in the screenshot - I want to be able to put, in the forumhome page, links that will directly lead to the subforums...

problem is that the html code

<a href="http://www.synthpopavenue.gr/forumdisplay.php?s=&forumid=40">Modemen on the road</a>

takes it self a lot of characters. That leaves me with a very few left characters to use for the description... of the forum and the subfolders.

Moreover at the The Synthpop and Wave Avenue
I have 7 subforums... If I try to make them links.... I can't

So I need to find a way of increasing the allowed number of characters we can use for the description of a forum.

I hope Its clear what I'm asking for, and sorry if there is already a hack for this but I haven't found it even though I have searched...

thanx in advance

[filburt1]

In phpMyAdmin, alter the description column in the forum table to be mediumtext.

[stark427]

thanx for the reply Filburt

here is what I get when I go to the table "forum"

http://www.synthpopavenue.gr/images/various/myadmin1.jpg

and here is what I get for the description row :


http://www.synthpopavenue.gr/images/various/myadmin2.jpg

so I guess I have to change the "type" to "mediumtext" right?

what does this mean? what is mediumtext?

also, what about the "length/values" field? do I have to increase that value?

wouldn't it be a solution to leave it as char and only increase the value to ... 500? or more?

thanx in advance

[filburt1]

Right.

mediumtext holds more than CHAR(250).

No.

No because IIRC it only goes up to 255.

[stark427]

thanx.
It seems to be working great :cool: