vbulletin bi forumda ziyaretçilere konu açtırmak istiyorum. konuyu açıyorlar denetliyorum admin olarak ve aktifleştiriyorum.
kategoride o aktifleştirdiğim konu açılıyor fakat sayfa aşağıdaki hatayı veriyor.
sebebi ne olabilir.
atabase 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 ()
AND thread.forumid NOT IN (0)
ORDER BY thread.dateline DESC
LIMIT 5;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND thread.forumid NOT IN (0)
ORDER BY thread.dateline DESC
L' at line 13
Error Number : 1064
Request Date : Monday, February 15th 2010 @ 11:11:35 AM
Error Date : Monday, February 15th 2010 @ 11:11:35 AM
Script : http://www.*****.com/showthread.php?t=12425
Referrer : http://www.*****.com/
IP Address : 88.241.110.125
Username : Gksl
Classname : vB_Database
MySQL Version : 5.0.67-community 