Illegal mix of collations (latin1_swedish_ci,COERCIBLE)

[Ekshi]

Hello all,

im forum database error;

Database error in vBulletin 3.6.4:
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
  
  
   , 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) 
  
  
  
  
  WHERE 1=1 AND posts >= 20
   AND user.usergroupid IN (-1,9,5,2,7,6,10)
  ORDER BY user.username asc 
  LIMIT 0, 20;
MySQL Error  : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_turkish_ci,IMPLICIT) for operation 'find_in_set'
Error Number : 1267
Date         : Friday, December 29th 2006 @ 01:59:25 PM
Script       : http://.?.com/memberlist.php
Referrer     : http://.?.com/usercp.php
IP Address   : 00.000.00.00
Username     : xxx
Classname    : vb_database

Fix please

[Steve Machol]

Please see this thread:

http://www.vbulletin.com/forum/showthread.php?t=195137