Announcement

Collapse
No announcement yet.

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

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Steve Machol
    replied
    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

    Leave a comment:


  • Vigile
    replied
    Originally posted by 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.
    I ran all of that I was told to run on this page:

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

    22-27

    Leave a comment:


  • Steve Machol
    replied
    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.

    Leave a comment:


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

    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!

Related Topics

Collapse

Working...
X