VBUsers
01-02-2010, 04:27 AM
when i click run report , it gives me this error
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.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 : Saturday, January 2nd 2010 @ 06:24:39 AM
Error Date : Saturday, January 2nd 2010 @ 06:24:40 AM
Script : http://www.hydrocanna.com/vbseo_sitemap/vbseo_sitemap.php
Referrer : http://www.hydrocanna.com/vbseo_sitemap/index.php?rlist=true
IP Address : 000000000
Username : Unregistered
Classname : vB_Database
MySQL Version :
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM thread AS thread
INNER JOIN tagthread AS tagthread ON
(tagthread.tagid = 1 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.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 : Saturday, January 2nd 2010 @ 06:24:39 AM
Error Date : Saturday, January 2nd 2010 @ 06:24:40 AM
Script : http://www.hydrocanna.com/vbseo_sitemap/vbseo_sitemap.php
Referrer : http://www.hydrocanna.com/vbseo_sitemap/index.php?rlist=true
IP Address : 000000000
Username : Unregistered
Classname : vB_Database
MySQL Version :