User permissions update problem

[squishi]

Hi,

I have a slight problem with a modification I uninstalled.
It seems to have some leftovers in the user permission formular.

When I go to the usergroup manager and edit the permissions for a usergroup, there now is a row with no description which allows the options "yes" and "no".
When I try to save the permissions I get this:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '180',
`passwordhistory` = '360',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '900',
`profilepicmaxheight` = '900',
`profilepicmaxsize` = '265535',
`avatarmaxwidth` = '150',
`avatarmaxheight` = '150',
`avatarmaxsize` = '50000',
`usmilie_permissions` = '0',
`allowhtmlpermissions` = '0'
WHERE usergroupid=6;

MySQL Error : Unknown column 'usmilie_permissions' in 'field list'
Error Number : 1054
Date : Tuesday, May 30th 2006 @ 04:27:13 AM
Script : http://mydomain.com/forum/admincp/usergroup.php
Referrer : http://mydomain.com/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address :
Username :
Classname : vB_Database

I think it's from that smiliemaker I tried to install, but I already uninstalled the product and deleted all files. :surprised:

[rogersnm]

which mod would it happen to be? becuase rpg inferno did this for me...

Also make sure you havn;t got any uknown plugins with the location "admin_usergroup_edit" or "admin_usergroup_save"

[squishi]

I don't know the name of the mod, it seems I have deleted it.
A search came up with no results. I think it was something like usmiliemaker, or something like that.

How do I get rid of the extra option? :surprised:

[Paul M]

This maybe ?

https://vborg.vbsupport.ru/showthread.php?t=100043

[Ramsesx]

I have the same error after uninstalling the e-steki Smilie Maker
"MySQL Error : Unknown column 'usmilie_permissions' in 'field list"
Do I only need to delete the table usmilie_permissions in the database?

[rogersnm]

that may mess it up even more.... does it tell you what the missing column is?

[Ramsesx]

that may mess it up even more.... does it tell you what the missing column is?
Thanks, now I know it was the user smilie hack and found (https://vborg.vbsupport.ru/showpost.php?p=995206&postcount=54) here the solution.