I'm getting this error when I was trying to generate site map with vbSEO, it worked before then when I check it today it gave me that error.Code:Database error in vBulletin 4.0.8: Invalid SQL: SELECT COUNT(*) as cnt,max(lastpost) as lastupdate FROM thread AS thread INNER JOIN tagcontent AS tagcontent ON (tagcontent.tagid = 13 AND tagcontent.contentid = thread.threadid) WHERE thread.forumid IN() AND thread.visible = 1 AND thread.sticky IN (0, 1) AND thread.open <> 10 GROUP BY tagcontent.tagid; 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 thread.visible = 1 AND thread.sticky IN (0, 1)' at line 5 Error Number : 1064 Request Date : Tuesday, January 18th 2011 @ 11:52:53 AM Error Date : Tuesday, January 18th 2011 @ 11:52:53 AM Script : http://forum.theproject-x.net/admincp/cronadmin.php?do=runcron&cronid=33 Referrer : http://forum.theproject-x.net/admincp/cronadmin.php?do=modify IP Address : private Username : Coded Classname : vB_Database MySQL Version : 5.0.91-community


LinkBack URL
About LinkBacks





Reply With Quote