DB error when i try to update a usergroup

[VBUsers]

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Unregistered / Not Logged In',
`description` = '',
`usertitle` = 'Guest',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`passivevideo_sig` = '0',
`forumpermissions` = '131077',
`genericpermissions` = '33554433',
`pmquota` = '50',
`pmpermissions` = '0',
`pmsendmax` = '0',
`pmthrottlequantity` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '0',
`genericpermissions2` = '0',
`genericoptions` = '104',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '0',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '194',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '0',
`visitormessagepermissions` = '16',
`socialgrouppermissions` = '64',
`maximumsocialgroups` = '0',
`groupiconmaxsize` = '65535',
`automediaembed_edit_permissions` = '126',
`automediaembed_view_permissions` = '126',
`adminpermissions` = '0',
`ms_imageshack_upload_permissions` = '0',
`passivevideo_stack0` = '7',
`passivevideo_stack1` = '0'
WHERE usergroupid=1;

MySQL Error : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number : 1054
Request Date : Sunday, May 17th 2009 @ 06:22:26 PM
Error Date : Sunday, May 17th 2009 @ 06:22:26 PM
Script : http://www.hydrocanna.com/admincp/usergroup.php?do=update
Referrer : http://www.hydrocanna.com/admincp/usergroup.php?do=edit&usergroupid=1
IP Address : 000000000000
Username : admin
Classname : vB_Database
MySQL Version : 5.0.67-community

[Lynne]

ms_imageshack_upload_permissions is not a standard vbulleltin field, so this error is from a modification. You need to find the modification and disable it.

[VBUsers]

i have uninstalled it. ill look in the plug in system

edit: i removed the product and any plug ins related to this. should i manually remove the query from the database? or whats the next step?

[Lynne]

When you uninstall a product, you need to also make sure you remove any files you had to upload for the product. So make sure you did that also.

[VBUsers]

When you uninstall a product, you need to also make sure you remove any files you had to upload for the product. So make sure you did that also.

yea i think that what the issue was. i didnt remove the xml file in the includes/xml folder so i kept deleting the table , but i kept loading it with tools.php when i rebuild the bitfield. im dumb lol