Announcement

Collapse
No announcement yet.

vBulletin 4.2 - Column length too big error

Collapse
This topic is closed.
X
This is a sticky topic.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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 customization and demonstration site.
    vBulletin 5 Documentation - Updated every Friday. Report issues here.
    vBulletin 5 API - Full / Mobile
    Vote for your most annoying bugs.
    I am not currently available for vB Messenger Chats.
Working...
X