hi all, i have a bit of a problem on our forum, all seems ok but on the usergroup edit page i have a box with no title and just yes and no radio buttons, i have not idea what its for.
but it causes a db error when i submit the page.
this only happend after installing a gallery mod, i uninstalled it to see if it would make a difference but it did not.
i can see that its to do with vba but i cant see what the hell the new option on the edit page is.
any help would be greatly appreciated, attached is an image of the offending option in edit usergroup.
does anyone now how i can remove it from the page and the field list
Craig
the error is:
Code:
Invalid SQL:
UPDATE VB_usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<strong style=\"color:black;\">',
`closetag` = '</strong>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ms_wic4_addon_vba_permissions` = '0',
`forumpermissions` = '16777215',
`genericpermissions` = '2113929151',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '7',
`pmsendmax` = '25',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '63',
`profilepicmaxwidth` = '180',
`profilepicmaxheight` = '180',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '180',
`avatarmaxheight` = '180',
`avatarmaxsize` = '262144',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '100000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '65535',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '100000',
`ms_wic4_addon_permissions` = '0',
`fcpermissions` = '8'
WHERE usergroupid=6;
MySQL Error : Unknown column 'ms_wic4_addon_vba_permissions' in 'field list'
Error Number : 1054
Request Date : Thursday, October 8th 2009 @ 09:02:14 PM
Error Date : Thursday, October 8th 2009 @ 09:02:14 PM
Classname : vB_Database
MySQL Version : 5.0.45-log