db error and sitemap don't generated

hi
i recently install vbseo and sitemap in a vb 4.1.5 install and I saw sitemap don't works and when i visit vbseo admin [sitemap reports], and try generate a sitemap I receive this error

Database error in vBulletin 4.1.5:

Invalid SQL:

SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM vbbeta_thread AS thread
INNER JOIN vbbeta_tagcontent AS tagcontent ON
(tagcontent.tagid = 1 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 : Thursday, August 11th 2011 @ 07:56:13 PM
Error Date : Thursday, August 11th 2011 @ 07:56:13 PM
Script : http://beta.riofotografico.com.br/vb...eo_sitemap.php

Referrer : http://beta.riofotografico.com.br/vb...eo_sitemap.php
- Show quoted text -

the
http://beta.riofotografico.com.br/sitemap_index.xml
don't exist!

probably I'm making something wrong
really I need help
thank you in advance

PLease try re-importing the sitemap product file with over write
then disable tags
re-genreate
then re-enable tages
and re-generate

it should complete at this point.

hi brian

i do all steps
- when I do first time [without tag pages ] works
- when I enable tags page error again

Database error in vBulletin 4.1.5:


Invalid SQL:


SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM vbbeta_thread AS thread
INNER JOIN vbbeta_tagcontent AS tagcontent ON
(tagcontent.tagid = 1 AND tagcontent.contentid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open &lt;&gt; 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 : Thursday, August 11th 2011 @ 09:02:35 PM
Error Date : Thursday, August 11th 2011 @ 09:02:35 PM
Script : http://beta.riofotografico.com.br/vb...eo_sitemap.php
Referrer : vBSEO Search Engine XML Sitemap for vBulletin
IP Address : 177.40.167.53
Username : Não Registrado(s)
Classname : vB_Database
MySQL Version :

do you have a tags file in the /data/ folder? it may be one particular invald tag that is causing the issue.

hi brian
no - I don't have sitemap_tag_xml.gz
i need create one? if yes ... you can told me how?
thanks

Do you have publicly available forums? It looks like its trying to find forumIds, but returning nothing.

no
but I can create a admin login to you
I previously use impex to import data from phpbb - this can afect tags?

I don't beleive tags are imported from impex, but i could be wrong. Do you HAVE tags?

Yes Brian,
I have tags

Please open a ticket with login details for further troubleshooting.

Hi,

Any update on resolution for this issue? I have the same problem.

<!-- Database error in vBulletin 3.8.7: 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 &lt;&gt; 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 : Tuesday, November 29th 2011 @ 01:42:28 PM Error Date : Tuesday, November 29th 2011 @ 01:42:28 PM Script : http://xxxxxxxxxxxxx/vbseo_sitemap/vbseo_sitemap.php Referrer : IP Address : xxxxxxxxxxxxx Username : Unregistered Classname : vB_Database_MySQLi MySQL Version : -->

RE- import the product file. The sitemap generator, although not version specific, needs to be updated with the product re-import after moving to vb4 as well, as the db table names have changed.

clear out the xml.gz files, and progress.dat, and it should then regenerate.