Announcement

Collapse
No announcement yet.

increase length of Forum’s Description?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Removed-1078464
    replied
    Huh ????

    Leave a comment:


  • Marco van Herwaarden
    replied
    The main difference is that a BLOB is stored binary, and MEDIUMTEXT is stored a a text value.

    Leave a comment:


  • Removed-1078464
    replied
    Code:
     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?

    Code:
    ALTER TABLE forum CHANGE description description MEDIUMTEXT NOT NULL;
    Does anyone know?

    Thanks

    Doug

    Leave a comment:


  • dwagenheim
    replied
    Originally posted by mtha
    ONLY RUN if you HAVE vb3 as table prefix. otherwise, use

    Code:
    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

    Leave a comment:


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

    Leave a comment:


  • Oleks
    replied
    This is resolved.

    Thank you.

    Leave a comment:


  • mtha
    replied
    Originally posted by Brad.loo
    Run this query:

    Code:
    ALTER TABLE `vb3_forum` CHANGE `description` `description` BLOB NOT NULL
    ONLY RUN if you HAVE vb3 as table prefix. otherwise, use

    Code:
    ALTER TABLE `forum` CHANGE `description` `description` BLOB NOT NULL
    or whatever you have for the prefix.

    Leave a comment:


  • Oleks
    replied
    Originally posted by the Sandman
    Well, did you try running the query mentioned above:
    Code:
    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.

    Leave a comment:


  • the Sandman
    replied
    Well, did you try running the query mentioned above:
    Code:
    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.

    Leave a comment:


  • Oleks
    replied
    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.

    Leave a comment:


  • the Sandman
    replied
    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.

    Leave a comment:


  • Oleks
    replied
    Please, please. I need a help with this question.

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

    Leave a comment:


  • Oleks
    replied
    Hi Brad.loo,
    I am a newbie to mysql.
    Please, give me an idea how to run this query:
    Originally posted by Brad.loo
    Run this query:
    Code:
    ALTER TABLE `vb3_forum` CHANGE `description` `description` BLOB NOT NULL


    Thank you.

    Leave a comment:


  • Guest's Avatar
    Guest replied
    Run this query:

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

    Leave a comment:


  • Oleks
    replied
    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.

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X