error when changing usergroup permissions

[[email protected] vbmenu_register("postmenu_1683128", true);]

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?

[[email protected] vbmenu_register("postmenu_1686641", true);]

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.

[[email protected] vbmenu_register("postmenu_1686721", true);]

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?)