The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Database error when trying to change usergroup permissions
Database error when trying to change usergroup permissions
Can anyone help please??? This happens with every usergroup I try to change. Thanks in advance! Database error in vBulletin 3.8.4: 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_refreshrate` = '', `mgc_cb_evo_nbmsg_show` = '', `mgc_cb_evo_nbmsg_perday_show` = '', `mgc_cb_evo_nbthreads_perday_show` = '', `mgc_cb_evo_max_chats_perday` = '', `forumpermissions` = '16777215', `genericpermissions` = '2147483583', `attachlimit` = '0', `pmquota` = '50', `pmpermissions` = '7', `pmsendmax` = '5', `pmthrottlequantity` = '0', `calendarpermissions` = '63', `wolpermissions` = '31', `adminpermissions` = '3', `genericpermissions2` = '1', `genericoptions` = '55', `profilepicmaxwidth` = '100', `profilepicmaxheight` = '100', `profilepicmaxsize` = '65535', `avatarmaxwidth` = '80', `avatarmaxheight` = '80', `avatarmaxsize` = '20000', `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` = '63', `visitormessagepermissions` = '63', `socialgrouppermissions` = '65535', `maximumsocialgroups` = '5', `groupiconmaxsize` = '65535' WHERE usergroupid=6; MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list' Error Number : 1054 Request Date : Wednesday, October 20th 2010 @ 02:51:34 AM Error Date : Wednesday, October 20th 2010 @ 02:51:34 AM Script : http://myforum.com/admincp/usergroup.php?do=update Referrer : http://myforum.com/admincp/usergroup...&usergroupid=6 IP Address : XXXXXXXXXXX Username : XXXXXX Classname : vB_Database MySQL Version : 4.1.22-standard |
#2
|
||||
|
||||
It looks like you have a mod that added a field (or tried to) to the usergroup table...
Field name: mgc_cb_evo_permissions If you removed the mod and can't get this issue to go away the easiest thing would be to go to ppmyadmin and add the field manually to the usergroup table. It's not the "best" way to solve this but probably the quickest. |
#3
|
|||
|
|||
Hey thanks for your help. I just checked the XML file and removed
bitfield_mgc_cb_evo.xml & cpnav_mgc_cb_evo.xml and it is working now. Thanks!!! |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|