help: Unknown column? How do I fix?

[doctor death]

I received this error message. Wonder if you can help figure out how to fix it? I cannot change any group attributes because of the errors this is generating. I belive it is caused by a mod that didnt fully uninstall.

The other interesting thing about this is there are blank options in my usergroup options page.

Please help if you can.

Database error in vBulletin 3.7.4:

Invalid SQL:
UPDATE vyxxxxxxxbh_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = '-=SOG=- Members',
`description` = 'Fully vetted -=SOG=- Team members who pay monthly dues. These people have all been voted onto the team and have stated they will abide by team policies',
`usertitle` = '',
`opentag` = '<font color=\"green\">',
`closetag` = '</font>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`radiotvpermissions` = '451',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`phpkd_pmpruneperiod` = '21',
`creditpermissions` = '68',
`credit_induction` = '30000',
`credit_referral` = '1000',
`credit_refbonus` = '1000',
`credit_paycheck` = '3000',
`credit_active` = '1000',
`credit_birthday` = '20000',
`credit_repgive` = '1000',
`credit_reputation` = '1000',
`credit_infraction` = '-1000',
`credit_thread` = '2000',
`credit_threadrate` = '2000',
`credit_post` = '2000',
`credit_ownthreadpost` = '2000',
`credit_postsize` = '1000',
`credit_ownthreadview` = '1000',
`credit_ownthreadrate` = '1000',
`credit_ownthreadreply` = '1000',
`credit_ownprofileview` = '1000',
`credit_pollmake` = '2000',
`credit_pollvote` = '2000',
`credit_attachment` = '2000',
`credit_sendpm` = '2000',
`credit_addevent` = '2000',
`credit_addprofpic` = '2000',
`credit_profile` = '2000',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '-1',
`credit_pastotuser` = '-1',
`credit_pasawuser` = '0',
`credit_pasawthread` = '0',
`credit_saveint` = '0',
`credit_maxsave` = '0',
`credit_loanint` = '0',
`credit_maxloan` = '0',
`credit_totloan` = '0',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '0',
`credit_lotdiscount` = '0',
`automediaembed_edit_permissions` = '126',
`automediaembed_view_permissions` = '126',
`forumpermissions` = '3797247',
`genericpermissions` = '2129641435',
`attachlimit` = '1000000',
`pmquota` = '100',
`pmpermissions` = '5',
`pmsendmax` = '15',
`calendarpermissions` = '55',
`wolpermissions` = '15',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '47',
`profilepicmaxwidth` = '300',
`profilepicmaxheight` = '300',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '200',
`avatarmaxheight` = '200',
`avatarmaxsize` = '20000',
`signaturepermissions` = '241663',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '500',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '239',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '55',
`socialgrouppermissions` = '375',
`vbgmepermissions` = '23',
`trmperms` = '1'
WHERE usergroupid=9;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Saturday, November 22nd 2008 @ 08:47:02 PM
Error Date : Saturday, November 22nd 2008 @ 08:47:02 PM
Script : http://www.xxxxxcom/forums/admincp/u....php?do=update
Referrer : http://www.xxxxx.com/forums/admincp/...&usergroupid=9
IP Address : 70.xxx.40.132
Username : xxxxxxxxx
Classname : vb_database
MySQL Version : 4.1.22-standard

[Nick]

Which Beta are you using?

If you aren't using Beta 3, I highly recommend upgrading to it now, because many bugs are fixed between each Beta.

[doctor death]

I am not using a beta version, I am using 3.7 latest revision.

[Lynne]

This is due to a modification you have installed, or that you have uninstalled incorrectly. Check to see if you have an extra file in includes/xml that is related to the modification.

[Nick]

I am not using a beta version, I am using 3.7 latest revision.

Then don't post in the 3.8 forum; post in the support forum appropriate to your version.

[doctor death]

My bad, sorry for that. I will put it over in other one. Thanks for your help Nick!

[doctor death]

This is due to a modification you have installed, or that you have uninstalled incorrectly. Check to see if you have an extra file in includes/xml that is related to the modification.

Lynne;

You are a hero! Thank you so much for your answer here.