Upgrading, Can't Edit Users

[TruthElixirX]

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:

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

I get this when I try to edit a user's usergroup. All hooks are disabled, all templates reverted, no hacks installed, so I'm not sure whats wrong.

[Steve Machol]

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'

[TruthElixirX]

Thanks, any idea what part of the upgrade I could have missed for this to have happened? Or should I re-run the whole upgrade script?

[Steve Machol]

No I don't. I would not run the upgrade again. Just run that query and if you have more errors post themn here.

[Julieh]

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

[Zachery]

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.

[Julieh]

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.

Duuh on the vb3_user part, silly me! Sorry! Been staring at the problem for a while, made me blind :P

Does the warning table have anything to do with the new infractions system? If not, then I uninstalled this warning hack some time ago...

[Zachery]

Yes it does.