strike3forumsmh
05-18-2007, 12:54 AM
Undoubtedly this is my error, but can you make any sense of this Geek?
Thanks
Database error in vBulletin 3.6.4:
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
,thread.forumid, forum.title AS forumtitle
FROM thread as thread
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
WHERE open != 10
AND thread.visible = 1
AND thread.views >= 150AND thread.replycount >= 20
AND thread.forumid in (2,73,125,52,53,50,3,4,5,6,8,7,9,10,11,12,13,14,15 ,16,17,101,18,19,20,21,22,23,24,25,26,27,28,29,30, 31,32,33,34,35,36,37,38,48,40)
ORDER BY thread.replycount DESC
LIMIT 10;
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 >= 20
AND thread.forumid in (2,73,125,52,53,50,3,4,5,6,8,7,' at line 13
Error Number : 1064
Date : Thursday, May 17th 2007 @ 06:45:21 PM
Script : ...admincp/gaz_admin.php?do=saveissue
Referrer : .../admincp/gaz_admin.php?do=editissue&id=1
IP Address :
Username :
Classname : vb_database
Thanks
Database error in vBulletin 3.6.4:
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
,thread.forumid, forum.title AS forumtitle
FROM thread as thread
LEFT JOIN forum AS forum ON (thread.forumid = forum.forumid)
WHERE open != 10
AND thread.visible = 1
AND thread.views >= 150AND thread.replycount >= 20
AND thread.forumid in (2,73,125,52,53,50,3,4,5,6,8,7,9,10,11,12,13,14,15 ,16,17,101,18,19,20,21,22,23,24,25,26,27,28,29,30, 31,32,33,34,35,36,37,38,48,40)
ORDER BY thread.replycount DESC
LIMIT 10;
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 >= 20
AND thread.forumid in (2,73,125,52,53,50,3,4,5,6,8,7,' at line 13
Error Number : 1064
Date : Thursday, May 17th 2007 @ 06:45:21 PM
Script : ...admincp/gaz_admin.php?do=saveissue
Referrer : .../admincp/gaz_admin.php?do=editissue&id=1
IP Address :
Username :
Classname : vb_database