#1 21. März 2008 Hallo, ich bekomme bei meinem "vBulletin v3.6.8 Patch Level 2" bei aufrufen der Benutzerliste folgenden Fehler in der DB: 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 , 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,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 : Friday, March 21st 2008 @ 05:49:02 PM Skript : http://board.meinedomain.de/memberlist.php Referrer : http://board.meinedomain.de/index.php IP-Adresse : 82.116.119.84 Benutzername : username Klassenname : vb_database Wie kann ich den Fehler beheben? Hoffe mir kann jemand helfen... + Multi-Zitat Zitieren