upgrade error 1.15 to 2.0

[mcncyo]

I upgrade fine on my test server but when i went to upgrade my main server in a test directory i get this error.



Database error in vBulletin Upgrade: Invalid SQL: ALTER TABLE user
DROP biography,
DROP canpost,
CHANGE timezoneoffset timezoneoffset CHAR(4) NOT NULL,
ADD buddylist MEDIUMTEXT NOT NULL AFTER emailnotification,
ADD ignorelist MEDIUMTEXT NOT NULL AFTER buddylist,
ADD avatarid SMALLINT NOT NULL,
ADD styleid SMALLINT UNSIGNED NOT NULL AFTER email,
ADD showsignatures SMALLINT DEFAULT '1' NOT NULL,
ADD birthday DATE DEFAULT '0000-00-00' NOT NULL,
ADD maxposts SMALLINT DEFAULT '-1' NOT NULL,
ADD startofweek SMALLINT DEFAULT '1' NOT NULL,
ADD ipaddress CHAR(20) NOT NULL,
ADD referrerid INT UNSIGNED NOT NULL,
ADD pmfolders MEDIUMTEXT NOT NULL AFTER ignorelist,
ADD receivepm SMALLINT DEFAULT '1' NOT NULL AFTER pmfolders,
ADD emailonpm SMALLINT NOT NULL AFTER receivepm,
ADD pmpopup SMALLINT NOT NULL AFTER emailonpm,
ADD nosessionhash SMALLINT NOT NULL,
DROP INDEX idxgroups,
ADD INDEX (username)
mysql error: Unknown column 'ignorelist' in 'user'
mysql error number: 1054
Date: Thursday 22nd of February 2001 07:55:17 AM
Script: /cyotest/admin/upgrade1.php?step=8


Does anyone know why?

[mcncyo]

sorry wrong board,

What version of php does vbulletin 2.0 require

[PeF]

http://www.vbulletin.com/features/

Take a look at System Requirements.

[mcncyo]

I have php 4.0.2 and the latest version of mysql and i still get this error why? Is there a work around?

[mcncyo]

I also get this email sent to me

Database error in vBulletin Upgrade: Invalid SQL: ALTER TABLE user
DROP biography,
DROP canpost,
CHANGE timezoneoffset timezoneoffset CHAR(4) NOT NULL,
ADD buddylist MEDIUMTEXT NOT NULL AFTER emailnotification,
ADD ignorelist MEDIUMTEXT NOT NULL AFTER buddylist,
ADD avatarid SMALLINT NOT NULL,
ADD styleid SMALLINT UNSIGNED NOT NULL AFTER email,
ADD showsignatures SMALLINT DEFAULT '1' NOT NULL,
ADD birthday DATE DEFAULT '0000-00-00' NOT NULL,
ADD maxposts SMALLINT DEFAULT '-1' NOT NULL,
ADD startofweek SMALLINT DEFAULT '1' NOT NULL,
ADD ipaddress CHAR(20) NOT NULL,
ADD referrerid INT UNSIGNED NOT NULL,
ADD pmfolders MEDIUMTEXT NOT NULL AFTER ignorelist,
ADD receivepm SMALLINT DEFAULT '1' NOT NULL AFTER pmfolders,
ADD emailonpm SMALLINT NOT NULL AFTER receivepm,
ADD pmpopup SMALLINT NOT NULL AFTER emailonpm,
ADD nosessionhash SMALLINT NOT NULL,
DROP INDEX idxgroups,
ADD INDEX (username)
mysql error: Unknown column 'ignorelist' in 'user'
mysql error number: 1054
Date: Friday 23rd of February 2001 08:31:00 AM
Script: /cyotest/admin/upgrade1.php?step=8

[Martin]

defintely strange. could we get a little more info on your server? OS, webserver, etc?

[Mike Sullivan]

Use beta 2.

[mcncyo]

when i ask i didn't know there was a beta2 out. I already tried beta2 and it fix the problem.