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