Issue with usergroups Vb 4.2

[RuneCentre]

Hey guys,

I just purchased my vbulletin not too long ago, and my site shut down, and then i just paid for hosting again.

Now when i edit the user groups, and try to save, i'm receiving this error.

Can anyone help me out with it?

Much thanks in advance!

Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Administrators',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '<img border=\'0\' src=\'images/ranks/admin.png\'\'/><span style=\"color:#336699; font-weight: bold;\">',
	`closetag` = '<img></span>',
	`passwordexpires` = '180',
	`passwordhistory` = '360',
	`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',
	`forumpermissions` = '134217727',
	`genericpermissions` = '2147483583',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '7',
	`pmsendmax` = '5',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions2` = '7',
	`genericoptions` = '55',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '80',
	`avatarmaxheight` = '80',
	`avatarmaxsize` = '20000',
	`signaturepermissions` = '499711',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '10000',
	`sigmaxrawchars` = '0',
	`sigmaxchars` = '0',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '0',
	`sigmaxvideos` = '0',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '191',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '262143',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Saturday, July 28th 2012 @ 01:31:51 PM
Error Date    : Saturday, July 28th 2012 @ 01:31:51 PM
Script        : http://runecentre.com/admincp/usergroup.php?do=update
Referrer      : http://runecentre.com/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : 96.255.172.61
Username      : Zynna
Classname     : vB_Database
MySQL Version : 5.5.23-55

[Lynne]

That error is from a modification that you did not properly uninstall. Uninstalling means going through the install instructions backwards and undoing everything you did to install the modification.

[Seven Skins]

That is because there is a column missing in your database and this column belong to MGC Chatbox Evo hack. Reinstall/remove this hack and and it should work after that.