[Forum] Error Upgrading to 4.2

[lisa3876]

Just tried to upgrade to 4.2 from 4.1.11 and received this when I tried to go through the upgrade process...

An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: 420a1, Step 1 Database Error:1074
Column length too big for column 'url' (max = 255); use BLOB or TEXT instead
Query:

CREATE TABLE navigation ( navid INT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(20) NOT NULL DEFAULT '', navtype ENUM('tab','menu','link') NOT NULL DEFAULT 'tab', displayorder SMALLINT UNSIGNED NOT NULL DEFAULT '0', parent VARCHAR(20) NOT NULL DEFAULT '', url VARCHAR(500) NOT NULL DEFAULT '', state TINYINT UNSIGNED NOT NULL DEFAULT '0', scripts VARCHAR(30) NULL DEFAULT '', showperm VARCHAR(30) NULL DEFAULT '', productid VARCHAR(25) NOT NULL DEFAULT '', username VARCHAR(100) NOT NULL DEFAULT '', version VARCHAR(30) NOT NULL DEFAULT '', dateline INT NOT NULL DEFAULT '0', PRIMARY KEY (navid), UNIQUE KEY identity (name, productid), KEY productid (productid, state) )

[Armee25]

I have the same exact issue going from 4.1.12 to 4.2

[Zachery]

What version of MySQL are you running?

[lisa3876]

What version of MySQL are you running?

4.1

[Zachery]

http://dev.mysql.com/doc/refman/5.0/en/char.html

Basicly, Older versions of MySQL cannot use more than 255 characters in a varchar setting, I'll see if I can post a quick edit to get around the problem.

[Zachery]

In your upload/install/includes/class_upgrade_420a1.php file find:

                    url VARCHAR(500) NOT NULL DEFAULT '', 

Replace with

                    url varchar(250) NOT NULL DEFAULT '',