Error In Group Permission Settings
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.
Quote:
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
|
|