Usergroup Manager

[Phillip]

So I have tried to change settings for usergroups and they end up being errors for SQL and such...

Database error in vBulletin 3.8.8:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Administrators',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '<b><i><span style=\"color: darkblue;\">',
	`closetag` = '</span></b></i>',
	`passwordexpires` = '180',
	`passwordhistory` = '360',
	`akvbghsfs_akismet_permissions` = '0',
	`forumpermissions` = '16777215',
	`genericpermissions` = '1581252543',
	`attachlimit` = '0',
	`pmquota` = '50',
	`pmpermissions` = '7',
	`pmsendmax` = '5',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions2` = '1',
	`genericoptions` = '55',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '80',
	`avatarmaxheight` = '80',
	`avatarmaxsize` = '20000',
	`signaturepermissions` = '237567',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '10000',
	`sigmaxrawchars` = '0',
	`sigmaxchars` = '0',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '0',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albumpicmaxsize` = '100000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '63',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '65535',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '65535'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'akvbghsfs_akismet_permissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, November 26th 2014 @ 07:54:43 PM
Error Date    : Wednesday, November 26th 2014 @ 07:54:43 PM
Script        : http://sitedomain/admincp/usergroup.php?do=update
Referrer      : http://sitedomain/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : -------------
Username      : Phillip
Classname     : vB_Database
MySQL Version : 5.5.40-cll

Is there anyway of fixing this?

[HM666]

Do you have this setting in your admin usergroup as the color & style of the word Administrators?

<b><i><span style=\"color: darkblue;\">

If so you cannot include the back slashes. You can use CSS in that area but it has to be done like this:

<span style="color: darkblue;font-weight:bold;font-style:italic;">

Then your closing tag in the second box would be

</span>

Not

</span></b></i>

[Phillip]

Originally Posted by HM666

Do you have this setting in your admin usergroup as the color & style of the word Administrators?

<b><i><span style=\"color: darkblue;\">

If so you cannot include the back slashes. You can use CSS in that area but it has to be done like this:

<span style="color: darkblue;font-weight:bold;font-style:italic;">

Then your closing tag in the second box would be

</span>

Not

</span></b></i>

I do have this set in my use admincp...

<span style="color: darkblue;font-weight:bold;font-style:italic;">

And I still get the same error after hitting update.

[kh99]

It looks like that's caused by a problem with your glowhost spam-o-matic installation. If you have it installed, then for some reason you have a column missing from the usergroup table. You can either try to add it back, or uninstall the product and reinstall it if you still want it.

If you have uninstalled it, then for some reason it seems that you still have a plugin from it. Maybe check the plugin manager and if you see it there you could try disabling or deleting it.

[Phillip]

Originally Posted by kh99

It looks like that's caused by a problem with your glowhost spam-o-matic installation. If you have it installed, then for some reason a column is missing form the usergroup table. You can either try to add it back, or uninstall the product and reinstall it if you still want it.

If you have uninstalled it, then for some reason it seems that you still have a plugin from it. Maybe check the plugin manager and if you see it there you could try disabling or deleting it.

I'll see what I can do with that. I'll try and see if I can get it work if not I will show what it comes up as after.

--------------- Added [DATE]1417037759[/DATE] at [TIME]1417037759[/TIME] ---------------

Still getting the same errors, is there a way like steps of removing Glowhost imported to phpmyadmin?

[ozzy47]

When you say," Glowhost imported to phpmyadmin " what is it you mean?

[Phillip]

Originally Posted by ozzy47

When you say," Glowhost imported to phpmyadmin " what is it you mean?

The table that was put into phpmyadmin...I'm really not sure how to explain it.

[ozzy47]

So your install of phpmyadmin randomly added this table to your database?

[Phillip]

Originally Posted by ozzy47

So your install of phpmyadmin randomly added this table to your database?

When I went in to install it...the table added itself after...but I can figure out how to remove that table cause it's not on the actually table set.

[ozzy47]

Ok lets do this, disable plugins via the includes/config.php file.

To do that open your includes/config.php file and below <?php add the following.

PHP Code:

define('DISABLE_HOOKS', true); 


So it looks like this:

PHP Code:

<?php
define('DISABLE_HOOKS', true);
/*=================================================  =====================*\
|| ##################################################  ################## ||
|| # vBulletin 4.2.2

Use a editor like notepad++ to edit any files, don't use Notepad or Wordpad.

Then navigate to the ACP, and un install the mod. Once that is done, remove or comment out that line in the config file, and see if you still have the same issue.