| wcbryant |
12-07-2006 07:27 PM |
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;
Code:
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. |
More Information