error when changing usergroup permissions

I am getting this error when trying to change usergroup permissions for registered users. The only change I am trying to make is to allow registered users to have pictures in their signatures.

Database error in vBulletin 3.7.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Registered Users',
	`description` = '',
	`usertitle` = '',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`vbstopforumspamviewpermissions` = '0',
	`vbstopforumspamsubmitpermissions` = '0',
	`vbblog_general_permissions` = '126',
	`vbblog_entry_permissions` = '7804',
	`vbblog_comment_permissions` = '974',
	`forumpermissions` = '3928575',
	`genericpermissions` = '1579685575',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '3',
	`pmsendmax` = '5',
	`calendarpermissions` = '63',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions2` = '1',
	`genericoptions` = '62',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '80',
	`avatarmaxheight` = '80',
	`avatarmaxsize` = '20000',
	`signaturepermissions` = '169983',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '10000',
	`sigmaxrawchars` = '1000',
	`sigmaxchars` = '500',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '4',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albumpicmaxsize` = '100000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '31',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '375',
	`uscpermissions` = '0'
WHERE usergroupid=2;

MySQL Error   : Unknown column 'uscpermissions' in 'field list'
Error Number  : 1054
Request Date  : Thursday, December 11th 2008 @ 10:15:16 AM
Error Date    : Thursday, December 11th 2008 @ 10:15:17 AM
Script        : http://www.tabletpcbuzz.com/admincp/usergroup.php?do=update
Referrer      : http://www.tabletpcbuzz.com/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 68.165.25.19
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.45-log

Thanks for your help.

John
www.tabletpcbuzz.com

[dyna88]

Did you happen to recently uninstall a modification and forget to remove the XML file?

I did have the Wordpress mod installed and was going to use that but then changed my mind. I had a hired programmer make the changes. What should I tell him needs to be done to fix this?

John
www.tabletpcbuzz.com

[Lynne]

I think dyna88 is correct. When uninstalling a modification, you also need to remove any files you uploaded for the modification also - especially ones in the includes/xml folder.

Here is the list of files in that directory:

hooks_vbacmps.xml
cpnav_vbacmps.xml
cpnav_vseo_sitemap.xml
spiders_vbulletin.xml
podcast_vbulletin.xml
js_safe_phrases.xml
index.html
hooks_vbulletin.xml
cpnav_vbulletin.xml
bitfield_vbulletin.xml
product-vbblog.xml
hooks_vbblog.xml
bitfield_vbblog.xml
bitfield_usc.xml
cpnav_vbstopforumspam.xml
bitfield_vbstopforumspam.xml
#cpnva_impex.xml

I don't see anything this is extra based on mods I am using but hopefully your trained eyes can point one out.

John
www.tabletpcbuzz.com

[Lynne]

Then you should look through your plugins - I'd start with ones that have "query" in the hook location - for the field "uscpermissions"

(How about "bitfield_usc.xml"? Notice the usc in there?)