PDA

View Full Version : SQL Error after removing an addon


gwon
06-20-2008, 06:14 AM
I installed an addin using the plugin system on vb. Didn't like it and removed it. Ever since, whenever I try to make most changes in the admin panel (noticed it first when trying to edit usergroups) I get the following sql error

Database error in vBulletin 3.7.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`vbimghost` = '3',
`vbimghost_upslots` = '3',
`vbimghost_files` = '100',
`icashpermissions` = '7',
`forumpermissions` = '8388607',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '500000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511'
WHERE usergroupid=6;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Friday, June 20th 2008 @ 03:12:19 AM
Error Date : Friday, June 20th 2008 @ 03:12:19 AM
Script : http://www.brainstewed.org/forums/admincp/usergroup.php?do=update
Referrer : http://www.brainstewed.org/forums/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 212.21.97.189
Username : Craig
Classname : vB_Database
MySQL Version : 5.0.51a-community

This bit: mgc_cb_evo_permissions, leads me to the plugin, I seem to remember the name was something like that. So I'm assuming that it's calling parts of the database that aren't there...or something along those lines.

Does anyone have any idea how I can get it to stop chucking through these requests and causing the errors?

Any help much appreciated.

Michael Biddle
06-20-2008, 06:27 AM
check your includes/xml files on your FTP and remove any traces of the modification that you uploaded origionally.

Dismounted
06-20-2008, 10:05 AM
Specifically, a bitfield_*.xml file.

gwon
06-21-2008, 11:08 AM
Thanks guys. That got it.