MYSql Failure

K

KnoPPerS

New Member
Hey,

since yesterday i become a failure:

Code: 
Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

		SELECT user.*,usertextfield.*,userfield.*, user.userid, options,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
		,IF((NOT(options & 1024) AND (user.usergroupid IN (-1,6) OR FIND_IN_SET('6', membergroupids))), 0, reputation) AS reputationscore
		,avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
		
		 , IF((options & 512 AND user.userid <> 68), 1, lastactivity) AS lastvisittime 
		
		
		
		FROM user AS user
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=user.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid=user.userid)
		LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid=reputationlevel.reputationlevelid) 
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		
		
		
		WHERE 1=1
			AND (user.usergroupid IN (-1,6,7,2,20,5))
			
		ORDER BY user.username asc 
		LIMIT 0, 30;

MySQL-Fehler : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
Fehler-Nr.   : 1267
Datum        : Sunday, February 3rd 2008 @ 03:29:06 PM

Can anyone help me? I don't know what i edit!

Regards
 
I found this in a search and may help. It seems to apply to the 3rd line from the bottom of the code you posted.
Cut and paste:

You will need to fix your database so that all the tables and columns are of a single collation. The default in MySQL and what vBulletin uses is latin1_swedish_ci. You have some columns set to utf8_general_ci. You need to pick one and set your database, tables and columns to that collation.
 
KnoPPerS said:
Hey,
all colums are already set to utf8_general_ci

but thanks very much!!!!
Click to expand...

It doesn't look like it from the error you are getting, but first off disable all your mods and see what happens.
 
You must log in or register to reply here.
Back
Top