vBulletin 4.2 - Column length too big error

Collapse
This topic is closed.
X
This is a sticky topic.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Wayne Luke
    vBulletin Technical Support Lead
    • Aug 2000
    • 73981

    prefix_vb4_foruminstallanswered_title_rich vBulletin 4.2 - Column length too big error

    If you are using MySQL 4.1.X, you may receive an error when upgrading your vBulletin software to 4.2.0 or installing an new 4.2.0 package. This is due to the allowed length of the varchar character type. In MySQL 4.1.X or lower, this type of field can only be 255 characters long at the most. To resolve this you need to make a small change to your files at this time.

    UPGRADE
    In your upload/install/includes/class_upgrade_420a1.php file find:
    PHP Code:
    url VARCHAR(500NOT NULL DEFAULT ''
    Replace with:
    PHP Code:
    url varchar(250NOT NULL DEFAULT ''
    INSTALL
    In your upload/ /installs/mysql-schema.php file find:
    PHP Code:
    url VARCHAR(500NOT NULL DEFAULT ''
    Replace with:
    PHP Code:
    url VARCHAR(250NOT NULL DEFAULT ''

    We are sorry about the inconvenience this issue causes.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...