Run Generator Makes Database Error

[CapoSicario]

Everytime i run generator for the sitemap i got this error.



Please help me what can i do.

I have vbulletin 3.8.6 and vbseo 3.5.2

im not sure what version the sitemap is if it has one.

CapoSicario Reviewed by CapoSicario on 16th Jan 2011. Run Generator Makes Database Error Everytime i run generator for the sitemap i got this error. http://s3.amazonaws.com/ember/seh6tGdIcgq1hdNL6XFZbG8aHCeYRMdv_m.png Please help me what can i do. I have vbulletin 3.8.6 and vbseo 3.5.2 im not sure what version the sitemap is if it has one. Rating: 5

[bxflow]

are you using the generator called vbseo sitemap? make sure to edit the settings accordingly

[CapoSicario]

yup im using sitemap

[Dj Mad]

what is the error?

[CapoSicario]

Database error in vBulletin 3.8.6:

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


Classname    : vB_Database
MySQL Version :

[Dj Mad]

the one above...the databse error its in the image

Hmm ok what error is it giving off?

[CapoSicario]

what is the error?

hey sorry yea i edited the post

[Dj Mad]

Do not includes Tags to ur sitemaps and run again.

[Shadow008]

did u rename the admincp ?

[CapoSicario]

Do not includes Tags to ur sitemaps and run again.

oo great this worked!

thanks!

sitemap successful created..

one more thing will it do it automatically now or do i have to do it?