I am getting the below error. Any ideas on how to fix this?
Code:
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