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]

Originally Posted by rogersnm

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 here the solution.