Hello, I'm getting this error. I originally tried the file edits then came to the end page and saw that file edits. Both ways gave me the same DB error. Any idea what may be causing it?
I'm using my open forum ID 855 like this
855|*
I'd like all the forums to display.
Code:
Database error in vBulletin 4.1.11:
Invalid SQL:
SELECT COUNT(*) AS threads,
(
SELECT COUNT(*) AS newthread
FROM thread AS thread
WHERE forumid = 855
AND lastpost > 1339934749
AND open <> 10
AND sticky = 0
AND visible IN (0,1,2)
*/ WHERE forumid > 0 AND (sticky = 0 OR sticky = 1) AND visible IN (0,1,2)
) AS newthread
FROM thread AS thread
/*
WHERE forumid = 855
AND sticky = 0
AND visible IN (0,1,2)
*/ WHERE forumid > 0 AND (sticky = 0 OR sticky = 1) 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 > 0 AND (sticky = 0 OR sticky = 1) AND visible IN (0,1,2) ' at line 14
Error Number : 1064
Request Date : Sunday, June 17th 2012 @ 08:09:49 AM
Error Date : Sunday, June 17th 2012 @ 08:09:50 AM
Script : http://www.**********.com/forums/forumdisplay.php?f=855
Referrer : http://www.************.com/forums/forum.php
Classname : vB_Database
MySQL Version : 5.1.61