PDA

View Full Version : Eror when generating new issue


AyeCapn
05-20-2007, 02:03 PM
Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, IF(views <= thread.replycount, thread.replycount+1, views) AS views, thread.lastposter, thread.lastpost, pollid
, avatarpath, NOT ISNULL(filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision
, thread.iconid AS threadiconid, iconpath AS threadiconpath,thread.forumid, forum.title AS forumtitle, post.pagetext AS preview
FROM reuthread as thread
LEFT JOIN reuicon USING (iconid)
LEFT JOIN reuforum AS forum ON (thread.forumid = forum.forumid)
LEFT JOIN reupost AS post ON (post.postid = thread.firstpostid)
LEFT JOIN reuuser AS user ON (user.userid = post.userid)
LEFT JOIN reuavatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN reucustomavatar as customavatar ON (customavatar.userid = user.userid)
WHERE open != 10
AND thread.visible = 1

AND thread.views >= 150AND thread.replycount >= 15
AND thread.forumid in (2,27,3,67,9,10,23,8,64,12,4,16,11,41,40,43,44,45, 46,47,48)
ORDER BY thread.dateline DESC
LIMIT 1;

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 'thread.replycount >= 15
AND thread.forumid in (2,27,3,67,9,10,23,8,64,12,4,16' at line 15
Error Number : 1064
Date : Sunday, May 20th 2007 @ 09:01:42 AM
Script : http://www.blackbus.org/forum/admincp/gaz_admin.php?do=savenewsletter
Referrer : http://www.blackbus.org/forum/admincp/gaz_admin.php?do=editnewsletter&id=1
IP Address : 68.148.88.222
Username : Peter Gulka
Classname : vB_Database

The Geek
05-21-2007, 09:24 AM
Its a bug with selecting the hot threads only option. Turn that off and you should be fine :)

AyeCapn
05-21-2007, 03:09 PM
That did it


<3