Results 1 to 3 of 3

Sitemap Generator Error - albumpicture missing?

This is a discussion on Sitemap Generator Error - albumpicture missing? within the Troubleshooting forums, part of the vBSEO SEO Plugin category; I made an attempt to run the Sitemap Generator. I have the 2.5 version since the beta version completely destroyed ...

  1. #1
    Junior Member
    Real Name
    Necie
    Join Date
    Aug 2010
    Location
    Atlanta, GA Metro Area
    Posts
    3
    Liked
    0 times

    Question Sitemap Generator Error - albumpicture missing?

    I made an attempt to run the Sitemap Generator. I have the 2.5 version since the beta version completely destroyed my links within the forum. Well, the sitemap generation was interrupted. Please see below.

    [homepage] [9,752.9Kb mem used] [0s (+0s)]
    [SECTION START] forumdisplay [9,755.2Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 4, total threads: 74, pages: 3 [9,757.0Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 31, total threads: 0, pages: 1 [9,760.9Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 28, total threads: 7, pages: 1 [9,762.3Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 27, total threads: 54, pages: 2 [9,763.7Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 12, total threads: 18, pages: 1 [9,766.0Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 8, total threads: 47, pages: 2 [9,767.4Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 10, total threads: 14, pages: 1 [9,769.7Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 11, total threads: 23, pages: 1 [9,771.1Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 13, total threads: 10, pages: 1 [9,772.5Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 9, total threads: 1, pages: 1 [9,773.9Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 26, total threads: 29, pages: 1 [9,775.3Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 14, total threads: 14, pages: 1 [9,776.7Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 17, total threads: 1, pages: 1 [9,778.2Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 15, total threads: 13, pages: 1 [9,779.6Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 16, total threads: 7, pages: 1 [9,780.9Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 18, total threads: 4, pages: 1 [9,782.3Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 19, total threads: 68, pages: 3 [9,783.7Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 33, total threads: 0, pages: 1 [9,787.0Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 21, total threads: 22, pages: 1 [9,788.4Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 30, total threads: 6, pages: 1 [9,789.8Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 22, total threads: 53, pages: 2 [9,791.2Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 20, total threads: 39, pages: 2 [9,793.5Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 23, total threads: 16, pages: 1 [9,795.8Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 24, total threads: 16, pages: 1 [9,797.2Kb mem used] [0s (+0s)]
    [forumdisplay] forum_id: 32, total threads: 2, pages: 1 [9,798.8Kb mem used] [0s (+0s)]
    [SECTION START] showthread [9,798.1Kb mem used] [0s (+0s)]
    [archive homepage] [9,794.9Kb mem used] [1s (+1s)]
    [SECTION START] forumdisplay archived [9,796.6Kb mem used] [1s (+0s)]
    [SECTION START] member [9,822.9Kb mem used] [1s (+0s)]
    [SECTION START] polls [10,149.9Kb mem used] [1s (+0s)]
    [SECTION START] blogs [10,164.9Kb mem used] [1s (+0s)]
    [SECTION START] groups [10,169.4Kb mem used] [1s (+0s)]
    [SECTION START] tags [10,172.9Kb mem used] [1s (+0s)]
    Database error
    The Milk and Mocha Interracial Community Forum database has encountered a problem.
    Here is the error message sent to my inbox via my database:

    Database error in vBulletin 4.0.5:

    Invalid SQL:

    SELECT ap.*,p.caption
    FROM xxxxxxxx_XXXxxalbumpicture ap
    LEFT JOIN xxxxxxxx_XXXxxpicture p on p.pictureid=ap.pictureid
    WHERE state = 'visible' AND albumid = '30';

    MySQL Error : Table 'xxxxxxxx_XXXxx.xxxxxxx_XXXxxalbumpicture' doesn't exist
    Error Number : 1146
    Request Date : Wednesday, August 18th 2010 @ 08:32:00 AM
    Error Date : Wednesday, August 18th 2010 @ 08:32:01 AM
    Script : http://www.milkandmocha.com/vbseo_si...eo_sitemap.php
    Referrer : vBSEO Google / Yahoo Sitemap for vBulletin
    IP Address : xx.xxx.xx.xx
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    Any clue as to how to fix this issue??? Should I add an "albumpicture" table to my database?

    Thanks!

  2. #2
    Junior Member
    Real Name
    Necie
    Join Date
    Aug 2010
    Location
    Atlanta, GA Metro Area
    Posts
    3
    Liked
    0 times
    I've found the problem and fixed it. I first had to select "NO" for the "Include Member Profile Album Pages" option of the vbSEO Sitemap Generator (under the settings tab) and then I had to select "NO" for the "Include Tag Pages" option.

  3. #3
    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
    Sitemap 2.5 is not compatible with vb4. You need to use the beta2 of version 2.6. While the sitemap may have run under 2.5, I assure you the links inside are not correct.

    What exactly did 2.6 give you for errors, as "completely destroyed my links within the forum" is non-descriptive and something that the sitemap doesn't even have access to.

Similar Threads

  1. Replies: 1
    Last Post: 07-21-2010, 04:48 AM
  2. vBulletin 4.x Run Sitemap Generator - Error
    By ctodd72 in forum Troubleshooting
    Replies: 12
    Last Post: 03-07-2010, 11:40 AM
  3. vBulletin 4.x sitemap generator error
    By ayah in forum Troubleshooting
    Replies: 9
    Last Post: 01-05-2010, 12:20 AM
  4. sql error sitemap generator
    By jorgejgm in forum Troubleshooting
    Replies: 1
    Last Post: 05-01-2009, 03:48 AM
  5. Run Sitemap Generator error
    By Cos in forum Troubleshooting
    Replies: 2
    Last Post: 07-22-2007, 03:17 PM

Tags for this Thread

Posting Permissions

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