Database Error - Invalid SQL - Update Usergroup Set
 

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/admi....php?do=update
Referrer : http://www.4datetalk.com/forums/admi...&usergroupid=7
IP Address : 71.134.158.124
Username : admin
Classname : vB_Database
MySQL Version : 4.1.22-standard-log
Reply
Forward
-------------

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.

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).

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.

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.

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.

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.

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

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.