[Racecar]

I get a database error anytime I try to change anything that I do in the usergroup.
This just started happening so I reloaded the site thinking that it would stop that and nothing.
I have posted the error that I get.

Database error in vBulletin 3.8.6:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Flirtilicious',
`description` = 'VIP Members',
`usertitle` = 'Flirtilicious',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`fcpermissions` = '0',
`ms_wic_addon_permissions` = '0',
`eggavatarpermissions` = '31',
`forumpermissions` = '16511487',
`genericpermissions` = '1546354635',
`attachlimit` = '0',
`pmquota` = '100',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '250',
`profilepicmaxheight` = '250',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '200000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '51071',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`photoplogpermissions` = '28871',
`photoplogmaxfilesize` = '512000',
`photoplogmaxfilelimit` = '100'
WHERE usergroupid=7;

MySQL Error : Unknown column 'ms_wic_addon_permissions' in 'field list'
Error Number : 1054
Request Date : Wednesday, January 5th 2011 @ 10:22:57 AM
Error Date : Wednesday, January 5th 2011 @ 10:23:00 AM
Script : http://???.com/admincp/usergroup.php?do=update
Referrer : http://???.com/admincp/usergroup.php...sergroupid=7IP Address : 00000000
Username : racecar
Classname : vB_Database
MySQL Version : 5.1.47-community-log

[kh99]

It looks like it has to do with this mod: http://www.vbulletin.org/forum/showthread.php?t=194602

I'm guessing the plugins are installed for it, but for some reason your database doesn't have the added columns that they require.

[Racecar]

ok, thanks. Will have to find and remove the files that go with that.

--------------- Added 05 Jan 2011 at 18:50 ---------------

I must be missing something, I have removed that from both the site and the server and still get the error.
Any suggestions?

[BirdOPrey5]

Something is still there even after the files were removed- did you uninstall the mod? It's possible even if you did the mod was poorly coded and didn't remove all traces of itself despite being uninstalled.

You can go to phymyadmin, the user table, and add a new field called: ms_wic_addon_permissions make it type int or tinyint that would probably get rid of the error but doesn't really fix the underlying problem.

[kh99]

Originally Posted by Racecar

I must be missing something, I have removed that from both the site and the server and still get the error.
Any suggestions?

What BOP5 said should work. But did you go to "Manage Products" and see if it's listed, and uninstall if it is? If that doesn't work you could also go to the "Plugin Manager" and see if any of the plugins have titles like "Flashchat:..." and disable or delete those. ...or you could even try installing it again, then uninstall it. (BTW, I would have replied yesterday but I missed your second post because of that annoying "post merging" thing ).

[Racecar]

I went to manage products and did the unistall and that did not fix the problem. I reinstalled and did unistall again to no such luck.
I'll try what BOP5 suggested for now to see if that works then hopefully I can figure out the bigger problem later.
Thanks.

[Racecar]

ok, no luck on getting this fixed. Is there a way to search which files were not removed? I have tried the install and uninstall and it's still not working. I have tried to find all the files on the server and can't find one that I missed but I must have.

--------------- Added 12 Jan 2011 at 19:21 ---------------

I have finally found the problem.
I do thank you for the help. I just kept missing one file thinking it was something else.