vba problem

[ukdalai]

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:

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

[Speysider]

Did you remove the phrase that contains that text?

[Brandon Sheley]

the title says it's a vbadvanced issue, but you say it's from a gallery mod?
which gallery mod is it

[Lynne]

This should be posted and dealt with over on the vbadvanced site since it is a vbadvanced issue.

[ukdalai]

guys, the reason i say its a vba issue is that the error is ms_wic4_addon_vba_permissions

but i cannot see why its there, i searched the vba forums for "ms_wic4_addon_vba_permissions" but found nothing, i was hopeing someone here would know what ms_wic4_addon_vba_permissions was from or how to remove it from the edit page.

Craig

[James Birkett]

I think the error is basically showing that the column doesn't exist in the table:
MySQL Error : Unknown column 'ms_wic4_addon_vba_permissions' in 'field list'

[ukdalai]

yes... that much i know, i was hoping someone more experienced with vb would be able to tell me how to remove the requirement.

i have removed it by removing to xml files
bitfield_ms_wic4_addon.xml
and
bitfield_ms_wic4_vba_addon.xml

but can anyone tell me what addon they are for

Craig

[Lynne]

Perhaps you installed a mod and then uninstalled it but didn't also delete any files you uploaded for it. You should always delete files uploaded for a mod after you uninstall it.

[ukdalai]

thanks lynne, the weird thing is ive installed UMG gallery, the author is doing some mods for me, but in truth, i decided to uninstall all the UMG stuff to do a reinstall, but then noticed that i had the prob.

i cant see why it has affected the vba xml files.
however removeing the to vba addon xml's has fixed it, i hope there is not a knock on effect.

Craig