[Forum] Database Error

[Maxxamillion]

I keep getting this database error when i edit a usergroup via admin any suggestions i am new to this so i havnt a clue please help


Database error in vBulletin 4.1.9: Invalid SQL: UPDATE usergroup SET ### UPDATE QUERY GENERATED BY fetch_query_sql() ### `title` = 'Clan Leaders', `description` = '', `usertitle` = 'Clan Leader', `opentag` = '<span style=\"font-weight: bold; color: yellow;\">', `closetag` = '</span>', `passwordexpires` = '180', `passwordhistory` = '360', `market_permissions` = '1', `market_discount` = '0.0000', `market_maxdonate` = '0.00000', `market_undo_time` = '24', `market_undo_penalty` = '0.5000', `market_gift_minimum` = '100.85', `market_gift_maximum` = '3500.45', `market_steal_percent` = '100', `market_convert_permissions` = '1', `market_history_permissions` = '1', `market_bank_permissions` = '1', `market_interest_rate` = '0.0215', `market_min_deposit` = '10.95', `market_deposit_fee` = '0.0299', `market_min_withdrawel` = '5.95', `market_withdrawel_fee` = '0.0149', `awardpermissions` = '3', `tournamentpermissions` = '1023', `maxteams` = '5', `ladderpermissions` = '255', `forumpermissions` = '16777215', `genericpermissions` = '2147483583', `attachlimit` = '0', `pmquota` = '150', `pmpermissions` = '7', `pmsendmax` = '5', `pmthrottlequantity` = '0', `calendarpermissions` = '63', `wolpermissions` = '31', `adminpermissions` = '3', `genericpermissions2` = '1', `genericoptions` = '55', `profilepicmaxwidth` = '100', `profilepicmaxheight` = '100', `profilepicmaxsize` = '65535', `avatarmaxwidth` = '80', `avatarmaxheight` = '80', `avatarmaxsize` = '20000', `signaturepermissions` = '237567', `sigpicmaxwidth` = '500', `sigpicmaxheight` = '100', `sigpicmaxsize` = '10000', `sigmaxrawchars` = '0', `sigmaxchars` = '0', `sigmaxlines` = '0', `sigmaxsizebbcode` = '7', `sigmaximages` = '0', `albumpermissions` = '255', `albumpicmaxwidth` = '600', `albumpicmaxheight` = '600', `albummaxpics` = '100', `albummaxsize` = '0', `usercsspermissions` = '0', `visitormessagepermissions` = '63', `socialgrouppermissions` = '262143', `maximumsocialgroups` = '5', `groupiconmaxsize` = '65535', `mgc_cb_evo_permissions` = '0', `mgc_cb_evo_refreshrate` = '30', `mgc_cb_evo_nbmsg_show` = '', `mgc_cb_evo_nbmsg_perday_show` = '', `mgc_cb_evo_nbthreads_perday_show` = '0', `mgc_cb_evo_max_chats_perday` = '0' WHERE usergroupid=6; MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list' Error Number : 1054 Request Date : Tuesday, January 17th 2012 @ 12:48:32 PM Error Date : Tuesday, January 17th 2012 @ 12:48:33 PM Script : http://www.rateoffire.co.uk/admincp/....php?do=update Referrer : http://www.rateoffire.co.uk/admincp/...&usergroupid=6 IP Address : 2.101.29.10 Username : Maxxamillion Classname : vB_Database MySQL Version : 5.1.56-log

[TheNewOne]

this is because of your custom chat program is missing a field try installing it again

[Maxxamillion]

i have uninstalled this chat as i found a better one but it still persists i cant seem to find what file i need to remove in my ftp

[TheNewOne]

if you are not sure what files to remove in the ftp download the chat program again and look also it might help to install then uninstall as some parts did not remove right

remember when removing any plugin you must also delete all files in the ftp for that program or as you see it will cause problems