Thread: RC1 Feedback
View Single Post
  #2  
Old 04-28-2007, 12:33 PM
Milad Milad is offline
Member
 
Join Date: Nov 2005
Posts: 58
Geek Article and Review System License Holder Geek Gazette License Holder 
Default

I tried to generate an issue, I had a MySQL error:

Code:
Invalid SQL:

		SELECT 
			thread.threadid, thread.title, postusername, postuserid, thread.dateline AS postdateline, 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 >= 15
			AND thread.forumid in (2) 
		ORDER BY thread.dateline 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 >= 15
			AND thread.forumid in (2) 
		ORDER BY thread.dateline' at line 13
Reply With Quote