Database Error - Invalid SQL - Update Usergroup Set

[MonCher]

vB Version 3.8.2

I received a few error codes in the last couple of days. Does anyone know what I should do with the following error code...

P.S. I did have another Invalid SQL and I ran a repair on the SQL database .... it's really difficult to even get a repair ticket to SiteGround... you just get a series of questions and answers. I'm not sure that running the repair will solve the issue listed below.

It looks like it's asking me to update the moderators - userdroup #7. But I don't understand
Unknown column 'mgc_cb_evo_permissions' in 'field list'. Do you know what am I missing?

Thanks

---------------------
Database error in vBulletin 3.8.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Moderators',
`description` = '',
`usertitle` = 'Your Friendly Moderator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12320767',
`genericpermissions` = '1592727247',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '50',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`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` = '51199',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '50',
`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',
`vbblog_general_permissions` = '521214',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '8191',
`vbblog_comment_permissions` = '974'
WHERE usergroupid=7;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, June 20th 2009 @ 06:14:23 PM
Error Date : Saturday, June 20th 2009 @ 06:14:23 PM
Script : http://www.4datetalk.com/forums/admincp/usergroup.php?do=update
Referrer : http://www.4datetalk.com/forums/admincp/usergroup.php?do=edit&usergroupid=7
IP Address : 71.134.158.124
Username : admin
Classname : vB_Database
MySQL Version : 4.1.22-standard-log
Reply
Forward
-------------

[snakes1100]

1. Remove the hack completely thats related to your error.

2. This is not a server issue, its an installed modification error, please post in the correct forum.

[Lynne]

As Anthony stated, this is an error related to a modification. The column 'mgc_cb_evo_permissions' is not a default vbulletin one. You've either installed a modification incorrectly, or not uninstalled it correctly (you need to remove all files related to a modification when you uninstall it, not just disable the plugins).

[MonCher]

Thank you Lynne and Snakes. I was confused, I thought the server was causing the problem. Now, I can see exactly what you're referring to. It was probably the upgrade to 3.8.2... I didn't realize the hack wasn't upgraded at the same time -- my fault.

[snakes1100]

It has nothing to do with a upgrade, please read the error msg again.

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'

Remove the hack completely from your site, if you do not know what all the hack did when you installed it, re-download it, view its contents and then verify that you removed everything to do with the said hack.

Hacks/Modifications are NOT default functions of the vbulletin system, therefore no hacks/addons that you dl from here or any other site will get upgraded by the default vbulletin system. The vbulletin blog is not even updated with the default vbulletin, its a totally separate program.

[Dismounted]

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'

Remove the hack completely from your site, if you do not know what all the hack did when you installed it, re-download it, view its contents and then verify that you removed everything to do with the said hack.
More specifically, you have not removed a bitfield_*.xml file from the /includes/xml directory.

[snakes1100]

More specifically, you have not removed a bitfield_*.xml file from the /includes/xml directory.

More specifically, that is the reason i didnt give the answer, hoping that the user might learn something on their own.

[MonCher]

OMG!!! I removed the chatbox yesterday thinking that was the problem. I just
received a message from Cybernetec saying it had nothing to do with the problem.
I emailed a guy that does some work on the site and he said he doesn't understand
how to fix database errors like these.

I'm lost!!!
Going back to read about bitfield_*.xml files and the includes/xml directory again to
see how I've missed which hack this is.

[Lynne]

MonCher, did you read the above messages? The fix to your problem is posted.

[MonCher]

More specifically, you have not removed a bitfield_*.xml file from the /includes/xml directory.

Thanks so much Lynne and Dismounted...
I needed to sit back and break for a second...:)
I'm really trying!

I pretty sure Dismounted gave me the answer here. I read everything again in the manual about removing a product. I know how to do that part after removing the chatbox yesterday. What I'm concerned about is removing the wrong bitfield_*.xml file... just like I removed the wrong hack yesterday. I can't locate the hack that it is associated with. I've had a few hacks put in by paid sources within the past 2 weeks like:

PhotoPost Pro
vBa Links Directory
VBa Dynamics
VBSEO

I don't have the files associated with those hacks because I paid for their installation. So, I think that removing a file bitfield_*.xml without knowing the hack and removing it will create more problems . I think I should send the error to the vendors who installed the hacks.

[snakes1100]

As i stated before, you could of downloaded the hack from the author, unzipped the file and viewed the contents.

remove these files from the includes/xml dir:
bitfield_mgc_cb_evo.xml
hooks_mgc_cb_evo.xml

[MonCher]

Anthony,

Thank you... I really appreciate your help. Hopefully I can fix it now!

((((((((((((( Hugs ))))))))))))) everyone