increase length of Forum’s Description?

[Oleks]

Hi,

I am wandering is the number of characters in Forum's description limited to approximately 200. How I can increase length of Forum's Description?

Thank you.

[Zachery]

its limited to 250 characters by the mysql field type, youll need to change it from varchar to text. this reuqires modifying the database, if you have never done that before i suggest backing up before you try

[Oleks]

Oh, I guess I am I trouble.
Could you possibly guide me through this?
Thank you.

P.S.
Actually, why not to include this option into the Admin CP.

[Guest]

Run this query:

ALTER TABLE `vb3_forum` CHANGE `description` `description` BLOB NOT NULL

[Oleks]

Hi Brad.loo,
I am a newbie to mysql.
Please, give me an idea how to run this query:

Run this query:

ALTER TABLE `vb3_forum` CHANGE `description` `description` BLOB NOT NULL

Thank you.

[Oleks]

Please, please. I need a help with this question.

Please, please.
I need a help with this question.
Thank you.

[the Sandman]

Do you have access to cPanel > MySQL Databases > phpMyAdmin? If so, go to phpMyAdmin > Databases > vBulletin3 (this may have a prefix) > Forum (also may have a prefix). Now, find the "description" field and press the "Change" icon (hover over the icons to see their functions - don't press the wrong one) to the right of it. On the next screen, expand the dropdown menu in the "Type" field and click on MEDIUMTEXT (*NOT* MEDIUMINT). Click Save.

[Oleks]

Hi,
I am learning vBulletin forum engine and I am using my PC as a virtual server. I do not have access to cPanel. Is any other way exist how to change Forum's description limit? Standard vBulletin settings are limited to 250 characters.

Thank you.

[the Sandman]

Well, did you try running the query mentioned above:

ALTER TABLE `vb3_forum` CHANGE `description` `description` BLOB NOT NULL

in your AdminCP > Import & Maintenance > Execute SQL Query > Manual Query? If you don't have permission to execute queries you have to add your userid to the Query section of the includes > config.php file first.

[Oleks]

Well, did you try running the query mentioned above:

ALTER TABLE `vb3_forum` CHANGE `description` `description` BLOB NOT NULL

in your AdminCP > Import & Maintenance > Execute SQL Query > Manual Query? If you don't have permission to execute queries you have to add your userid to the Query section of the includes > config.php file first.

Hi,
No. I did not.
I am learning vBulletin and I did not realize how to run this query.
Your instructions has more details.
I will try tonight.

Thank you.

[mtha]

Run this query:

ALTER TABLE `vb3_forum` CHANGE `description` `description` BLOB NOT NULL

ONLY RUN if you HAVE vb3 as table prefix. otherwise, use

ALTER TABLE `forum` CHANGE `description` `description` BLOB NOT NULL

or whatever you have for the prefix.

[Oleks]

This is resolved.

Thank you.

[Floris]

Just for your info, vBulletin also has an option to run queries through the admin control panel

[dwagenheim]

ONLY RUN if you HAVE vb3 as table prefix. otherwise, use

ALTER TABLE `forum` CHANGE `description` `description` BLOB NOT NULL

or whatever you have for the prefix.

I ran this query and now my database is tweaked. I can get back in, but I have no idea what has been changed and how to put it back. Currently, the admincp off the forums is not coming up.

Dave

[Removed-1078464]

 ALTER TABLE `forum` CHANGE `description` `description` BLOB NOT NULL

Group,

I was told by someone to use the code below. I have used this code several times with version 3-0-7 and everything worked just fine without any problems what so ever.

I am just wondering what the difference between the two actually are, is there any difference?

ALTER TABLE forum CHANGE description description MEDIUMTEXT NOT NULL;

Does anyone know?

Thanks

Doug