Results 1 to 6 of 6

vBSEO Scheduled Task Manager error?

This is a discussion on vBSEO Scheduled Task Manager error? within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; Code: Database error in vBulletin 4.0.8: Invalid SQL: SELECT COUNT(*) as cnt,max(lastpost) as lastupdate FROM thread AS thread INNER JOIN ...

  1. #1
    Junior Member
    Real Name
    Xianyi Ye
    Join Date
    Jan 2011
    Posts
    4
    Liked
    0 times

    vBSEO Scheduled Task Manager 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
    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.

  2. #2
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,789
    Liked
    657 times
    Blog Entries
    2
    Please make sure you are using sitemap 3.0 from .org.

  3. #3
    Junior Member
    Real Name
    Xianyi Ye
    Join Date
    Jan 2011
    Posts
    4
    Liked
    0 times
    I got vBSEO sitemap plug-in from vBulletin.org. Isn't that the same?

  4. #4
    Junior Member
    Real Name
    Xianyi Ye
    Join Date
    Jan 2011
    Posts
    4
    Liked
    0 times
    sorry for double post but here is the link to it: vBSEO Search Engine XML Sitemap - vBulletin.org Forum

  5. #5
    vBSEO Staff Brian Cummiskey's Avatar
    Real Name
    Brian Cummiskey
    Join Date
    Jul 2009
    Location
    btwn NYC and Boston
    Posts
    12,789
    Liked
    657 times
    Blog Entries
    2
    Yes, that is the same one.

    You can try turning off tags in the options if they do not work.

  6. #6
    Junior Member
    Real Name
    Xianyi Ye
    Join Date
    Jan 2011
    Posts
    4
    Liked
    0 times
    Thank you that helped me!

Similar Threads

  1. scheduled task= vBSEO Update Service?
    By frank678 in forum General Discussion
    Replies: 1
    Last Post: 10-29-2010, 10:36 PM
  2. vBulletin 4.x scheduled task error
    By Flep in forum Troubleshooting
    Replies: 2
    Last Post: 01-27-2010, 09:54 AM
  3. Scheduled Task Does Not Run
    By URLJet in forum Troubleshooting
    Replies: 8
    Last Post: 09-09-2009, 05:11 AM
  4. Scheduled Task Manager two tasks question
    By sovaward in forum General Discussion
    Replies: 5
    Last Post: 12-22-2006, 01:18 PM
  5. VBSEO Sitemap 1.7 scheduled task
    By CreationNation in forum General Discussion
    Replies: 1
    Last Post: 11-28-2006, 07:24 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •