The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Gazette

Geek Gazette GAZ is a community newsletter management system.

Advertisement
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2007, 01:54 AM
strike3forumsmh strike3forumsmh is offline
Junior Member
 
Join Date: Jun 2006
Posts: 14
Geek Article and Review System License Holder Geek Gazette License Holder 
Default Help with an error

Undoubtedly this is my error, but can you make any sense of this Geek?

Thanks

Quote:
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
Reply With Quote
  #2  
Old 05-18-2007, 03:50 AM
Michael-MI Michael-MI is offline
Member
 
Join Date: Oct 2005
Posts: 44
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

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.
Reply With Quote
  #3  
Old 05-18-2007, 04:11 AM
strike3forumsmh strike3forumsmh is offline
Junior Member
 
Join Date: Jun 2006
Posts: 14
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

Yep, no error this time.
Reply With Quote
  #4  
Old 05-18-2007, 04:46 AM
strike3forumsmh strike3forumsmh is offline
Junior Member
 
Join Date: Jun 2006
Posts: 14
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

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.

Last edited by strike3forumsmh; 05-18-2007 at 08:13 AM..
Reply With Quote
  #5  
Old 05-18-2007, 08:24 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Strike - can you pm me admincp details?
Reply With Quote
  #6  
Old 05-20-2007, 02:55 AM
strike3forumsmh strike3forumsmh is offline
Junior Member
 
Join Date: Jun 2006
Posts: 14
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

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.
Reply With Quote
  #7  
Old 05-20-2007, 08:25 AM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Im really sorry I havent gotten there yet. Hag tight and Ill see if I can do it tonight after the show.
Reply With Quote
  #8  
Old 05-20-2007, 08:30 AM
strike3forumsmh strike3forumsmh is offline
Junior Member
 
Join Date: Jun 2006
Posts: 14
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: Parse error: syntax error unexpected T_ENCAPSED_AND_WHITESPACE BeautUtes.com Geek Article and Review System 1 05-16-2007 09:12 AM


All times are GMT. The time now is 12:08 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.