i think i found a bug related, i removed this and deleted bitfield_user_smiley.xml from the xml folder, now i can save usergroups without the following error.
is this related to your product ?
Code:
Database error in vBulletin 3.6.0:
Invalid SQL:
UPDATE vb3_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = '(COPPA) Users Awaiting Moderation',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '131072',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`calendarpermissions` = '32',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions` = '0',
`genericoptions` = '48',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '139263',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '4000',
`sigmaxchars` = '2000',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '30',
`usmilie_permissions` = '0'
WHERE usergroupid=4;
MySQL Error : Unknown column 'usmilie_permissions' in 'field list'
Error Number : 1054
Date : Tuesday, August 8th 2006 @ 09:08:37 AM
Script : http://www.clandesertrats.co.uk/foru....php?do=update
Referrer : http://www.clandesertrats.co.uk/foru...&usergroupid=4
IP Address : 62.253.128.14
Username : GoNz0
Classname : vb_database
i tried your updated version as well to no joy