[wcbryant]

I recently uninstalled this add-on through the product manager, as I've been having some slow load issues, and I've been going out of my way to cut down on the number of hacks I use. After doing so, when admins try to create new user accounts through admincp, they're getting this error;

Database error in vBulletin 3.6.4:

Invalid SQL:
UPDATE user SET
	### Bitfield: 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: user.adminoptions ###
		adminoptions = IF(adminoptions & 1, adminoptions - 1, adminoptions),
		adminoptions = IF(adminoptions & 2, adminoptions - 2, adminoptions),
	usertitle = 'Newbie',
	customtitle = 0,
	username = '*',
	email = '*@yahoo.com',
	languageid = 0,
	homepage = '',
	birthday_search = '',
	birthday = '',
	showbirthday = 2,
	icq = '',
	aim = '',
	yahoo = '',
	msn = '',
	skype = '',
	parentemail = '',
	referrerid = 0,
	ipaddress = '164.62.*.*',
	posts = 6,
	vbookie_cash = 500,
	usergroupid = 2,
	membergroupids = '22',
	reputationlevelid = 2,
	reputation = -750,
	warnings = 0,
	infractions = 0,
	ipoints = 0,
	pmpopup = 1,
	autosubscribe = -1,
	threadedmode = 0,
	showvbcode = 2,
	styleid = 0,
	timezoneoffset = '-5',
	daysprune = -1,
	joindate = 1102184940,
	lastactivity = 1165522680,
	lastpost = 1165522140,
	vbp_receivespoints = 1,
	vbp_storeaccess = 1,
	vbbux = 993.911,
	vbbank = 0,
	vbp_nextbankinterest = 0,
	vbp_genericperm = 0,
	vbp_modperm = 0,
	vbp_adminperm = 0,
	vbp_nametextcolor = '',
	vbp_nameglowcolor = '',
	vbp_nameshadowcolor = '',
	vbp_namefonttype = '',
	vbp_titletextcolor = '',
	vbp_titleglowcolor = '',
	vbp_titleshadowcolor = '',
	vbp_titlefonttype = '',
	vbp_changealwaysitems = '',
	### Bitfield: user.vbp_displayflags ###
		vbp_displayflags = IF(vbp_displayflags & 1, vbp_displayflags - 1, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 2, vbp_displayflags - 2, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 4, vbp_displayflags - 4, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 8, vbp_displayflags - 8, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 16, vbp_displayflags - 16, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 32, vbp_displayflags - 32, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 64, vbp_displayflags - 64, vbp_displayflags),
		vbp_displayflags = IF(vbp_displayflags & 128, vbp_displayflags - 128, vbp_displayflags),
	### Bitfield: user.vbp_otherflags ###
		vbp_otherflags = IF(vbp_otherflags & 1, vbp_otherflags - 1, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 2, vbp_otherflags - 2, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 4, vbp_otherflags - 4, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 8, vbp_otherflags - 8, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 16, vbp_otherflags - 16, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 32, vbp_otherflags - 32, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 64, vbp_otherflags - 64, vbp_otherflags),
		vbp_otherflags = IF(vbp_otherflags & 256, vbp_otherflags - 256, vbp_otherflags),
	### Bitfield: user.vbp_immunity ###
		vbp_immunity = IF(vbp_immunity & 1, vbp_immunity - 1, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 2, vbp_immunity - 2, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 4, vbp_immunity - 4, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 8, vbp_immunity - 8, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 16, vbp_immunity - 16, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 32, vbp_immunity - 32, vbp_immunity),
		vbp_immunity = IF(vbp_immunity & 64, vbp_immunity - 64, vbp_immunity),
	displaygroupid = '2'
WHERE userid = 1719;

MySQL Error  : Unknown column 'warnings' in 'field list'
Error Number : 1054
Date         : Thursday, December 7th 2006 @ 01:18:30 PM
Script       : http://www.buckeyeplanet.com/forum/admincp/user.php?do=update
Referrer     : http://www.buckeyeplanet.com/forum/admincp/user.php?do=edit&u=1719
IP Address   : 165.166.*.*
Username     : (admin-name)
Classname    : vB_Database_MySQLi

I've read through the archive I used to download, and tried to page through these 75 pages as best I can looking for a clear cut solution, but if one exists, I've over looked it.

Is this as easy as running a couple queries to complete the uninstall, and if so, where might I find those (I have no real comfort level with mysql myself), either way, will any change I make interfere with vB's built in warning system?

Thanks in advance for any help. I probably should have just left AWS disabled instead of flat uninstalling it, but like I said, trying to slim down.