[Mosh]

Originally Posted by rob4448585

absolutely

this is the error i get editing/saving any usergroup

thanks for any help/ideas you have

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Moderators',
	`description` = '',
	`usertitle` = 'Moderator',
	`opentag` = '<b><font color=#FF0000>',
	`closetag` = '</font></b>',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`ms_wic4_addon_permissions` = '0',
	`fcpermissions` = '4',
	`forumpermissions` = '12317183',
	`genericpermissions` = '1558716079',
	`attachlimit` = '0',
	`pmquota` = '500',
	`pmpermissions` = '5',
	`pmsendmax` = '5',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '3',
	`adminpermissions` = '0',
	`genericpermissions2` = '1',
	`genericoptions` = '62',
	`profilepicmaxwidth` = '300',
	`profilepicmaxheight` = '225',
	`profilepicmaxsize` = '250000',
	`avatarmaxwidth` = '150',
	`avatarmaxheight` = '150',
	`avatarmaxsize` = '51200',
	`signaturepermissions` = '237055',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '20000',
	`sigmaxrawchars` = '1000',
	`sigmaxchars` = '500',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '0',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albumpicmaxsize` = '10000000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '63',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '51063',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '250000',
	`itraderpermissions` = '3'
WHERE usergroupid=7;

MySQL Error   : Unknown column 'ms_wic4_addon_permissions' in 'field list'
Error Number  : 1054
Request Date  : Monday, September 14th 2009 @ 08:56:55 PM
Error Date    : Monday, September 14th 2009 @ 08:56:56 PM
Script        : http://www.site.com/forums/admincp/usergroup.php?do=update
Referrer      : http://www.site.com/forums/admincp/usergroup.php?do=edit&usergroupid=7
IP Address    : 67.188.1.96
Username      : *****
Classname     : vB_Database
MySQL Version : 5.0.81-community

For some reason you have lost the ms_wic4_addon_permissions column from the usergroup table in the database, which is why you are having issues.

From the installation instructions for this hack, do Step 3 again, allow overwrite.

If that does not work, then uninstall the product from the AdminCP and then do Step 3 again.

If that does not work, then let me know.