merhabalar yine sitemde bir database sorunu ortaya çıktı yardım edebilir misiniz ?
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT
thread.threadid, thread.title, thread.lastpost, thread.forumid,
thread.replycount, thread.lastposter, thread.dateline, thread.prefixid,
IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.visible, user.username, user.userid, user.usergroupid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
forum.title_clean as forum_title, post.pagetext AS preview, post.allowsmilie, post.postid
FROM thread AS thread
LEFT JOIN user AS user ON (user.username = thread.lastposter)
LEFT JOIN forum as forum ON (thread.forumid = forum.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE thread.visible = '1' AND post.visible = '1' AND thread.open!='10'
AND thread.postuserid IN (1)
AND thread.forumid NOT IN (0)
ORDER BY thread.dateline DESC
LIMIT 5;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, May 21st 2009 @ 08:14:33 AM
Error Date : Thursday, May 21st 2009 @ 08:14:33 AM
Script : http://***.com/site-kurallari-t2/index.html
Referrer : http://***.com/site-kullanimi-f3/index.html
IP Address : 85.110.231.244
Username : eLiKaPs
Classname : vB_Database
MySQL Version : 5.0.67-communityayrıca admin panelinde sayaçları güncellmeye çalıştığımdada alttaki hatayı alıyorum;
Parse error: syntax error, unexpected $end in /home/empi3/public_html/admincp/misc.php on line 81
