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-20-2007, 02:03 PM
AyeCapn AyeCapn is offline
Member
 
Join Date: Oct 2006
Posts: 35
Geek Article and Review System License Holder Geek Gazette License Holder 
Default Eror when generating new issue

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/adminc...savenewsletter
Referrer : http://www.blackbus.org/forum/adminc...ewsletter&id=1
IP Address : 68.148.88.222
Username : Peter Gulka
Classname : vB_Database
Reply With Quote
  #2  
Old 05-21-2007, 09: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

Its a bug with selecting the hot threads only option. Turn that off and you should be fine
Reply With Quote
  #3  
Old 05-21-2007, 03:09 PM
AyeCapn AyeCapn is offline
Member
 
Join Date: Oct 2006
Posts: 35
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

That did it


<3
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
Not automatically generating new issues mrdon Geek Gazette 6 11-09-2009 03:28 PM
Ratings issue tekguru Geek Article and Review System 1 03-05-2008 04:00 PM
issue with formatting nymyth Geek Article and Review System 5 06-19-2007 01:46 PM
issue indie Geek Article and Review System 7 03-07-2007 06:44 PM


All times are GMT. The time now is 04:03 AM.


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