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) )
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) )
Comment