Merhaba Suan biz yahoo'dan small business web hosting aldık 1 haftadırda kullanıyoruz.Ama daha once hostgator fırmasında full cpanel backup almıstım.Yedek lokalde sorunsuz calısırken yahoo ya kurdugumda memberlist.php de database hatası verıyor.Dıger hersey normal ama memberlist.php ye bakıldıgında su hata cıkıyor;
Database error 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,15) OR FIND_IN_SET('6', membergroupids) OR FIND_IN_SET('15', 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
, IF(YEAR(user.birthday_search) > 0 AND user.showbirthday IN (1,2) AND user.birthday_search < CURDATE(), user.birthday_search, '0000-00-00') AS agesort
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,10,7,11,9,6,2,15,5))
ORDER BY user.username asc
LIMIT 0, 30;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'
Error Number : 1267
Date : Sunday, February 17th 2008 @ 07:09:37 PM
Script : http://**********
Referrer : http://********
IP Address : ******
Username : KıLıCaRsLaN
Classname : vb_databaseYahoo nu emaıl destegı olmadıgından konuyu arz edemıyorum.Acıkcası son yedegım sorunsuz ama yahoo ya kurdugumda dedıgım hata cıkıyor.Sonra Yahoodan yedek aldıgımda yıne lokalde denedım 2 dk lık yedek lokalde tekrar.Memberlist.php de db hatası verdi sizce ne yapailirim ?