Database error in vBulletin 3.6.2: Invalid SQL: UPDATE vb3_user SET ### Bitfield: vb3_user.options ### options = IF(options & 8, options - 8, options), options = IF(options & 1024, options, options + 1024), options = IF(options & 16, options, options + 16), options = IF(options & 256, options - 256, options), options = IF(options & 512, options - 512, options), options = IF(options & 32, options - 32, options), options = IF(options & 2048, options, options + 2048), options = IF(options & 131072, options - 131072, options), options = IF(options & 4096, options - 4096, options), options = IF(options & 1, options, options + 1), options = IF(options & 2, options, options + 2), options = IF(options & 4, options, options + 4), options = IF(options & 64, options, options + 64), options = IF(options & 128, options - 128, options), options = IF(options & 32768, options - 32768, options), ### Bitfield: vb3_user.adminoptions ### adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions), adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions), usertitle = 'Administrator', customtitle = 0, username = 'Reager', email = '[email protected]', languageid = 1, homepage = '', birthday_search = '1984-08-05', birthday = '08-05-1984', showbirthday = 0, icq = '', aim = '', yahoo = '', msn = '', skype = '', parentemail = '', referrerid = 0, ipaddress = '65.78.218.129', posts = 0, usergroupid = 6, reputationlevelid = 5, reputation = 10, warnings = 0, infractions = 0, ipoints = 0, pmpopup = 0, autosubscribe = -1, threadedmode = 0, showvbcode = 1, styleid = 0, timezoneoffset = '-5', daysprune = 0, joindate = 1162352820, lastactivity = 1162352820, lastpost = 0, membergroupids = '', displaygroupid = 0 WHERE userid = 155; MySQL Error : Unknown column 'warnings' in 'field list' Error Number : 1054 Date : Tuesday, October 31st 2006 @ 10:59:29 PM Script : http://www.thechillcenter.com/forums/admincp/user.php?do=update Referrer : http://www.thechillcenter.com/forums/admincp/user.php?do=edit&u=155 IP Address : 67.141.79.197 Username : Karsinogen Classname : vb_database
Announcement
Collapse
No announcement yet.
Upgrading, Can't Edit Users
Collapse
X
-
Upgrading, Can't Edit Users
I am upgrading a 3.5.4 board to 3.6.2. I disabled hook system and uninstalled all hacks. I'm want to keep this version of my board as vanilla as I can, but I've run into a problem:
Code:Tags: None
-
This means you missed a step during the upgrade. Run this query to add that field:
ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
-
No I don't. I would not run the upgrade again. Just run that query and if you have more errors post themn here.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
I had this exact problem myself, (which is weird, because I followed the upgrade instructions and simply clicked next, and then poof it was done and I was moved to the admincp index, like it was done :S)
But, when I try to run this (ALTER TABLE user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0') query, I get this error:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'warunee_vbulletin.user' doesn't exist
My database is named 'warunee_vbulletin', and the prefix is 'vb3_' (without the '' of course).
Comment
-
Then you need to run
ALTER TABLE vb3_user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'
The only way the warning table would not be is if you uninstalled the warning hack AFTER the upgrade.
Comment
-
Originally posted by Zachery View PostThen you need to run
ALTER TABLE vb3_user ADD warnings INT UNSIGNED NOT NULL DEFAULT '0'
The only way the warning table would not be is if you uninstalled the warning hack AFTER the upgrade.
Does the warning table have anything to do with the new infractions system? If not, then I uninstalled this warning hack some time ago...
Comment
-
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment