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:
Replace with:
INSTALL
In your upload/ /installs/mysql-schema.php file find:
Replace with:
We are sorry about the inconvenience this issue causes.
UPGRADE
In your upload/install/includes/class_upgrade_420a1.php file find:
PHP Code:
url VARCHAR(500) NOT NULL DEFAULT '',
PHP Code:
url varchar(250) NOT NULL DEFAULT '',
In your upload/ /installs/mysql-schema.php file find:
PHP Code:
url VARCHAR(500) NOT NULL DEFAULT '',
PHP Code:
url VARCHAR(250) NOT NULL DEFAULT '',
We are sorry about the inconvenience this issue causes.