PDA

View Full Version : Errors while editing anything via AdminCP


tnsgaming
05-02-2012, 08:47 PM
Whenever I, for example, edit/create a Usergroup, I get this error.

Database error in vBulletin 4.1.12:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Head Community Manager',
`description` = '',
`usertitle` = 'Head Community Manager',
`opentag` = '<span style=\"font-style: italic;color:#2F5ED1;font-size:12pt;font-weight ;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`dbtech_vbshoutpermissions` = '0',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_nbthreads_perday_show` = '',
`mgc_cb_evo_max_chats_perday` = '',
`vbblog_general_permissions` = '524286',
`vbblog_customblocks` = '10',
`vbblog_custompages` = '10',
`vbblog_entry_permissions` = '57343',
`vbblog_comment_permissions` = '3038',
`forumpermissions` = '16777215',
`genericpermissions` = '1943011323',
`attachlimit` = '1000000',
`pmquota` = '500',
`pmpermissions` = '7',
`pmsendmax` = '10',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '50000',
`signaturepermissions` = '498807',
`sigpicmaxwidth` = '600',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '1000000',
`sigmaxrawchars` = '500',
`sigmaxchars` = '500',
`sigmaxlines` = '5',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '3',
`sigmaxvideos` = '1',
`albumpermissions` = '255',
`albumpicmaxwidth` = '500',
`albumpicmaxheight` = '500',
`albummaxpics` = '10',
`albummaxsize` = '2500000',
`usercsspermissions` = '0',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '262143',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '250000'
WHERE usergroupid=90;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, May 2nd 2012 @ 02:44:26 PM
Error Date : Wednesday, May 2nd 2012 @ 02:44:26 PM
Script : http://tns-gaming.com/admincp/usergroup.php?do=update
Referrer : http://tns-gaming.com/admincp/usergroup.php?do=edit&usergroupid=90
IP Address : 99.224.24.179
Username : Mostly Harmless
Classname : vB_Database
MySQL Version : 5.5.22

Does anyone know how to fix this?

kh99
05-02-2012, 08:49 PM
You have a mod installed that's looking for a database column that for some reason is missing. Searching for that column name I'd guess it's something to do with MGC Evo chat. So it seems you should either uninstall or reinstall that mod.