HTML Code:
Database error in vBulletin 3.8.6:
Invalid SQL:
SELECT user.username, post.userid, post.postid, post.threadid, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
Where thread.open = 1
AND thread.visible = 1
AND post.visible = 1
AND thread.forumid NOT IN (30,131)
AND post.dateline > 1290346866
AND thread.forumid NOT IN (6,8,10,18,21,24,25,28,30,40,46,49,53,57,61,65,67,68,73,76,82,85,86,89,90,91,99,100,109,116,130,131,157,159,162,167,168,169,)
AND post.postid = thread.firstpostid
AND post.phpkd_vblvb_lastcheck < 1289914866
LIMIT 50;
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 ')
AND post.postid = thread.firstpostid
AND post.phpkd_vblvb_lastcheck < 12' at line 10 Error Number : 1064 Request Date : Friday, November 26th 2010 @ 04:41:06 PM
Error Date : Friday, November 26th 2010 @ 04:41:06 PM
Script : http://forum.com/cron.php?rand=1290778865
Referrer : http://forum.com/showthread.php?p=6854
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :
1: I found a writing error in the XML file: TEMORARY DOWN >>>> "Temporary Down" should be wrote instead
2: I removed the ',' at the end of my "excluded forum" and seem to have fix the problem of SQL error.
but i did a "run" and it found a few post that the links are suppose to be dead and they're not? Why?
I also didn't received any PM about it. I think i'm lost lolllll