Usergroup MYSQL Error

[KnoPPerS]

Hey,

i see an mysql error when i edit the Usergroup of an User

Database error in vBulletin 3.6.8:

Invalid SQL:

			SELECT COUNT(*) AS users
			FROM mst_user
			WHERE userid <> 68
			AND
			(
				usergroupid IN(6)
					OR FIND_IN_SET('6', membergroupids)
			);

MySQL Error  : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
Error Number : 1267
Date         : Monday, November 19th 2007 @ 09:50:23 PM
Script       : http:///admincp/user.php?do=update
Referrer     : http:///admincp/user.php?do=edit&u=68
IP Address   : *******
Username     : KnoPPerS
Classname    : vB_Database

can anyone help me?

 

[Daz]

as they are user group 6 that is normally admin, are they set as super admin & not editable?

 

[KnoPPerS]

I gave admin right briefly to a user and kan her him now any longer to take! I am that super admin

 

[lordsyntax]

the problem lies within different collations set for the tables that are queried.
Simplest solution would be to run phpmyadmin or any other admin tool and set all tabled to the same collation.

There are quite a few threads about the exact same problem over at vbulletin.com, such as this one: MySQL Error : Illegal mix of collations - vBulletin Community Forum - Project Tools

They all suggest to set a consistent collation throughout the db ^^

 

[KnoPPerS]

okay thank you soooo much!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

i have enable the function:

$config['Mysqli']['charset'] = 'utf8';

and then i changed the permission. After that, i will disbled the feature and it works!

Thank you!