View Full Version : Help with an error

05-18-2007, 12:54 AM
Undoubtedly this is my error, but can you make any sense of this Geek?


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

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

05-18-2007, 02:50 AM
Turn off Only select from 'hot' threads" in your modules. If that fixes it you have the same error as me. I haven't reported it yet.

05-18-2007, 03:11 AM
Yep, no error this time.

05-18-2007, 03:46 AM
FYI, I was doing some test generated newsletters and the previews show nothing (0%) with either the html or the text preview. I sent out an email to only the admins to see if anything would go out so I guess I should know soon enough.

Edit: Nothing so far. Also, when I generate a newsletter, it looks like it is listing styles, but it hangs or so after five and goes nowhere. I don't know if that's a timeout issue or exhausting too much memory than what is allowed or what.

The Geek
05-18-2007, 07:24 AM
Strike - can you pm me admincp details?

05-20-2007, 01:55 AM
I don't know if you saw them or not (I can understand if you're busy, as evident by your sig) but I sent them on a few days ago.

The Geek
05-20-2007, 07:25 AM
Im really sorry I havent gotten there yet. Hag tight and Ill see if I can do it tonight after the show.

05-20-2007, 07:30 AM
I am in no particular rush Geek, I just wanted to make sure my message didn't slip through the cracks as I know when you get bombarded with PM's (as I am sure you have with such a successful 24 hour sale) that can certainly happen.

Thanks for the quick response.