[BirdOPrey5]

Originally Posted by James T Brock

I am getting the below error. Any ideas on how to fix this?

Database error in vBulletin 3.8.5:

Invalid SQL:

	SELECT COUNT(*) AS threads,
	(
		SELECT COUNT(*) AS newthread
		FROM thread AS thread
		WHERE forumid = 22
		AND lastpost > 1319489077
		AND open <> 10
		AND sticky = 0
		
		 AND visible IN (0,1,2)
		
		
		
		*/ WHERE forumid IN (22) AND sticky = 0   AND visible IN (0,1,2)   
	) AS newthread
	
	FROM thread AS thread
	
	/*
	WHERE forumid = 22
	AND sticky = 0
	
	 AND visible IN (0,1,2)
	
	
	
	*/ WHERE forumid IN (22) AND sticky = 0   AND visible IN (0,1,2);

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 '*/ WHERE forumid IN (22) AND sticky = 0   AND visible IN (0,1,2)   
	) AS newth' at line 14
Error Number  : 1064
Request Date  : Monday, October 24th 2011 @ 01:44:44 PM
Error Date    : Monday, October 24th 2011 @ 01:44:44 PM
Script        : http://website.com/forumdisplay.php?f=22
Referrer      : http://website.com/forumdisplay.php?f=11
IP Address    : xx.xx.xx.xx
Username      : admin
Classname     : vB_Database
MySQL Version : 5.1.52-log

One of two things is the problem...

1) You have another mod using the hook forumdisplay_query_threadscount. In plugin manager see if any other plugin is using that hook and if so let me know which mod and I'll take a look.

Or

2) Are you using a modified or different forumdisplay.php file then came with your version. Please replace your forumdisplay.php with a copy from the original 3.8.5 install. (Keep a backup in case of anything.)