Unable to edit Usergroups & Unable to Remove Plugin

[iNate19]

When I try to edit a Usergroup's Permissions, I receive the following Database Error
Database error in vBulletin 4.2.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`pbusernamelimit` = '',
`ms_imageshack_upload_permissions` = '0',
`ms_megaupload_upload_permissions` = '0',
`ms_photobucket_upload_permissions` = '0',
`forumpermissions` = '10211583',
`genericpermissions` = '1275076227',
`attachlimit` = '1',
`pmquota` = '5',
`pmpermissions` = '0',
`pmsendmax` = '1',
`pmthrottlequantity` = '0',
`calendarpermissions` = '0',
`wolpermissions` = '0',
`adminpermissions` = '0',
`genericpermissions2` = '5',
`genericoptions` = '58',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '100000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '20000',
`signaturepermissions` = '400511',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '20000',
`sigmaxrawchars` = '200',
`sigmaxchars` = '300',
`sigmaxlines` = '8',
`sigmaxsizebbcode` = '4',
`sigmaximages` = '1',
`sigmaxvideos` = '1',
`albumpermissions` = '239',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '20',
`albummaxsize` = '0',
`usercsspermissions` = '160',
`visitormessagepermissions` = '55',
`socialgrouppermissions` = '247671',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '100000',
`dbtech_usertagpermissions` = '0',
`vbblog_general_permissions` = '519166',
`vbblog_customblocks` = '5',
`vbblog_custompages` = '5',
`vbblog_entry_permissions` = '40959',
`vbblog_comment_permissions` = '3022',
`dbtech_vbactivitypermissions` = '2',
`dbtech_vbactivitymodpermissions` = '0',
`creditspermissions` = '0',
`dbtech_vbshoppermissions` = '32',
`vfc_hide_hack_perm` = '1'
WHERE usergroupid=2;

MySQL Error : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number : 1054
Request Date : Friday, August 1st 2014 @ 07:16:01 PM
Error Date : Friday, August 1st 2014 @ 07:16:01 PM
Script : http://rapbattles.com/forum/admincp/usergroup.php?do=update
Referrer : http://rapbattles.com/forum/admincp/usergroup.php?do=edit&usergroupid=2
IP Address : xxx.x.xx.xx
Username : ILLunatic
Classname : vB_Database
MySQL Version : 5.6.19-log

When I try to delete the "PB All Pictures" Plugin, I receive the following Database Error
Database error in vBulletin 4.2.2:

Invalid SQL:
ALTER TABLE picture DROP pblastcomment;

MySQL Error : Table 'rapbattles.picture' doesn't exist
Error Number : 1146
Request Date : Friday, August 1st 2014 @ 07:15:05 PM
Error Date : Friday, August 1st 2014 @ 07:15:06 PM
Script : http://rapbattles.com/forum/admincp/plugin.php?do=productkill
Referrer : http://rapbattles.com/forum/admincp/plugin.php?do=productdelete&productid=pb_allpictures&s=
IP Address : xxx.x.xx.xx
Username : ILLunatic
Classname : vB_Database
MySQL Version : 5.6.19-log


Any ideas?

[kh99]

It looks like you have mods installed that are supposed to have database changes, but the changes aren't there. Did you restore an old database or something?

You should probably ask for help where you got the mod. But if you know how to put you site into debug mode then you could edit th product and remove the uninstall code.

[iNate19]

This website has been around for nearly 15 years, many people have had access over the years.

The specific mod that I'm trying to uninstall has been there for who knows how long, hence why I'm trying to get rid of it.

[ForceHSS]

When removing a mod first, remove xml then all files in the FTP doing it any other way can cause database errors same as leaving files in the FTP after removing the xml. The above error can also be caused by a badly made xml that won't install some fields in your database. The best thing you can do is talk to the coder for support of the mod in question

[iNate19]

I don't know what other files are in the FTP from that mod as I'm not the one who installed it. I removed the xml files but now I'm stuck...

[Lynne]

I suggest you go post in the modification thread and ask what other files had needed to be uploaded so that you know what files to remove.

[iNate19]

I could't find the Modification Thread for that specific Modification

[Lynne]

What is the name of the modification? Perhaps you got it from another site?