The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
SQL Error after removing an addon
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
Code:
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 Does anyone have any idea how I can get it to stop chucking through these requests and causing the errors? Any help much appreciated. |
#2
|
|||
|
|||
check your includes/xml files on your FTP and remove any traces of the modification that you uploaded origionally.
|
#3
|
||||
|
||||
Specifically, a bitfield_*.xml file.
|
#4
|
|||
|
|||
Thanks guys. That got it.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|