PDA

View Full Version : mysql errorwhen i run vbseo sitemap generator


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 :

kall
01-02-2010, 04:59 AM
You should be asking this question in the modification's thread.

Much more likely to get a response there. :)

Lynne
01-02-2010, 03:41 PM
Questions/Problems regarding modifications need to be asked in the modification thread. That is where the support for modifications is - not out here in the main forums. Please note that if a modification is unsupported (or even if it says it is supported), you may be on your own if you chose to install it.

kall
01-02-2010, 04:17 PM
Aww.

Lynne's got me on ignore. :(

Knew I shouldn't have asked that last question about $threadids. :(

Lynne
01-02-2010, 05:01 PM
Hehe. No I don't.

I mean.... did somebody say something in here?!?

kall
01-02-2010, 05:50 PM
Excellent.

*rubs hands together and takes opportunity to launch into stirring rendition of Reuben Stoddard's winning Idol number*

:P

VBUsers
01-03-2010, 10:36 PM
was hoping someone had the same issue as me. sorry and no response from the mod thread.