Database error when trying to change usergroup permissions

[kellyandmark04]

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.php?do=edit&usergroupid=6
IP Address : XXXXXXXXXXX
Username : XXXXXX
Classname : vB_Database
MySQL Version : 4.1.22-standard

[BirdOPrey5]

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.

[kellyandmark04]

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