Upgrade Scripts for 2.3.4 Don't Give error for use without ALTER privelges

[Steve Machol]

Assuming no other steps were missed during the upgrade process, you can run this query to add that column:

ALTER TABLE useractivation ADD usergroupid SMALLINT UNSIGNED NOT NULL

[Vigile]

It looks like you did not run all steps of all upgrade scripts. Which scripts did you run?

And I have in fact seen the 'alter' error message given during upgrade proceses.

I ran all of that I was told to run on this page:

http://www.vbulletin.com/members/upgrade.html

22-27

[Steve Machol]

It looks like you did not run all steps of all upgrade scripts. Which scripts did you run?

And I have in fact seen the 'alter' error message given during upgrade proceses.

[Vigile]

Above says it all. I was getting this error email after upgrading from 2.2.8 to 2.3.4 after running all the upgrade scripts:

Database error in vBulletin 2.3.4:

Invalid SQL:

INSERT INTO useractivation

(useractivationid, userid, dateline, activationid, type, usergroupid)

VALUES

(NULL, 54306, 1075671839, '62342884', 1, 2)



mysql error: Unknown column 'usergroupid' in 'field list'

mysql error number: 1054

I searched the forum to find the appropriate ALTER command, and now it runs fine, but I never got an error on the upgrade scripts.

Just a note!