Results 1 to 3 of 3

Issue with sitemap generator..

This is a discussion on Issue with sitemap generator.. within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; I have had nothing but database errors when running the sitemap generator since upgrading to VB 4 so I thought ...

  1. #1
    Junior Member
    Real Name
    Chris Miller
    Join Date
    Mar 2009
    Posts
    7
    Liked
    0 times

    Issue with sitemap generator..

    I have had nothing but database errors when running the sitemap generator since upgrading to VB 4 so I thought I would try the new beta. It too throws an SQL error. Can you help? Here is the error:

    Code:
    Database error in vBulletin 4.0.5:
    
    Invalid SQL:
    
                     SELECT ap.*,p.caption
                     FROM albumpicture ap
                     LEFT JOIN picture p on p.pictureid=ap.pictureid
                     WHERE state = 'visible' AND albumid = '9';
    
    MySQL Error   : Table '512032_spcontent.albumpicture' doesn't exist
    Error Number  : 1146
    Request Date  : Wednesday, September 8th 2010 @ 12:53:08 PM
    Error Date    : Wednesday, September 8th 2010 @ 12:53:09 PM
    Script        : http://www.MYSITE.com/admincp/cronadmin.php?do=runcron&cronid=60
    Referrer      : http://www.MYSITE.com/admincp/cronadmin.php?do=modify
    IP Address    : 70.113.63.50
    Username      : Admin
    Classname     : vB_Database
    MySQL Version : 5.0.77-log

  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
    Hello,

    For now, you can disable albums from being included in your sitemap by disabling that option in the options panel.

  3. #3
    Junior Member
    Real Name
    Chris Miller
    Join Date
    Mar 2009
    Posts
    7
    Liked
    0 times
    Well I disabled that, and then got this one:

    Database error in vBulletin 4.0.5:

    Invalid SQL:

    SELECT
    count(*) as maxre
    FROM tagthread
    GROUP BY tagid
    ORDER BY maxre DESC
    LIMIT 0,1;

    MySQL Error : Table '512032_spcontent.tagthread' doesn't exist
    Error Number : 1146
    Request Date : Wednesday, September 8th 2010 @ 04:03:00 PM
    Error Date : Wednesday, September 8th 2010 @ 04:03:00 PM
    Script : http://www.mysite.com/admincp/cronad...cron&cronid=60
    Referrer : http://www.mysite.com/admincp/cronadmin.php?do=modify
    IP Address : 70.113.63.50
    Username : Admin
    Classname : vB_Database
    MySQL Version : 5.0.77-log
    So i disabled tags for blogs and general tags too, and i *think* it ran correctly this time.

    Thanks for the help!

Similar Threads

  1. Replies: 4
    Last Post: 05-22-2010, 02:25 PM
  2. Issue When Running The Sitemap Generator
    By fattony69 in forum Troubleshooting
    Replies: 6
    Last Post: 08-11-2009, 12:05 AM
  3. SiteMap Generator issue
    By hawaa in forum Troubleshooting
    Replies: 6
    Last Post: 04-13-2009, 12:30 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
  •