Database Error

[Mysterious2207]

Got this sent to my email after one of my admins tried to edit one of the user group settings.

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE vbusergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Registered Users',
        `description` = '',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `hhroptions` = '0',
        `mgc_cb_evo_permissions` = '0',
        `mgc_cb_evo_refreshrate` = '30',
        `mgc_cb_evo_nbmsg_show` = '',
        `mgc_cb_evo_nbmsg_perday_show` = '',
        `mgc_cb_evo_max_chats_perday` = '0',
        `forumpermissions` = '12317183',
        `genericpermissions` = '1579685063',
        `attachlimit` = '0',
        `pmquota` = '50',
        `pmpermissions` = '3',
        `pmsendmax` = '5',
        `pmthrottlequantity` = '0',
        `calendarpermissions` = '63',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '62',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '65535',
        `avatarmaxwidth` = '80',
        `avatarmaxheight` = '80',
        `avatarmaxsize` = '20000',
        `signaturepermissions` = '137215',
        `sigpicmaxwidth` = '500',
        `sigpicmaxheight` = '100',
        `sigpicmaxsize` = '10000',
        `sigmaxrawchars` = '1000',
        `sigmaxchars` = '500',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '4',
        `albumpermissions` = '255',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '63',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '51063',
        `maximumsocialgroups` = '5',
        `groupiconmaxsize` = '65535'
WHERE usergroupid=2;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Saturday, February 7th 2009 @ 06:34:30 PM
Error Date    : Saturday, February 7th 2009 @ 06:34:30 PM
Script        : http://rslocated.net/admincp/usergroup.php?do=update
Referrer      : http://rslocated.net/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 76.108.228.93
Username      : Dan [Heatrepeat]
Classname     : vb_database
MySQL Version : 5.0.67-community

* That happens when i click on update.



Also, their are alot of blanks. This is how it looks:



I headed over to the forums at www.vbulletin.com and they had told me that
"There is no 'mgc_cb_evo_permissions' field in the default vB database. That query and error is from an add-on you installed. You will need to either remove that add-on or ask for help in the appropriate thread over at www.vbulletin.org. "

How do i know what ad-on it was?

[Lynne]

If you clicked install on the modification, then it should show up in your list of Installed Modification under User CP.

Or you could do a search on the term "mgc_cb_evo*" also in the mods forums and see if it comes up.

[Mysterious2207]

Originally Posted by Lynne

If you clicked install on the modification, then it should show up in your list of Installed Modification under User CP.

Or you could do a search on the term "mgc_cb_evo*" also in the mods forums and see if it comes up.

Its this mod:
https://vborg.vbsupport.ru/showthread.php?t=168992

I had already uninstalled it, so it doesnt show up in my products. What do i do next?

[Lynne]

You need to make sure that when you uninstall a mod, you also remove all files you uploaded with the mod - like ones in the includes/xml/ directory.

[Mysterious2207]

Originally Posted by Lynne

You need to make sure that when you uninstall a mod, you also remove all files you uploaded with the mod - like ones in the includes/xml/ directory.

Okay, thank you very much for the help.