VBSEO Sitemap Generator 2.6 Bug Reports

Heh, quickest bug report?

Creating a sitemap via the Admin CP gives me a database error:

Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT ap.*,p.caption
FROM albumpicture ap
LEFT JOIN picture p on p.pictureid=ap.pictureid
WHERE state = 'visible' AND albumid = '25';

MySQL Error : Table '*********_****.albumpicture' doesn't exist
Error Number : 1146
Request Date : Sunday, December 13th 2009 @ 02:58:05 PM
Error Date : Sunday, December 13th 2009 @ 02:58:06 PM
Script : http://www.**************/vbseo_site...eo_sitemap.php
Referrer : http://www.*************/vbseo_sitem...php?rlist=true
IP Address : ************
Username : Unregistered
Classname : vB_Database
MySQL Version :

Works if I turn off "Include Member Profile Album Pages" in sitemap settings.

Thanks for reporting. We will look into this. Looks like vB renamed some tables.

Same problem as I had, but turning off the "Include Member Profile Album Pages" in sitemap settings. as Neal also posted above and it's working fine

I have same problem.

want I want to know is what url do you put in your google webmasters account for where the sitemap is?

sussed it

ht*******.co.uk/forum/sitemap_1.xml.gz

that's if you leave everything as the root and don't make it read to a

another bug:


Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT ap.*,p.caption
FROM albumpicture ap
LEFT JOIN picture p on p.pictureid=ap.pictureid
WHERE state = 'visible' AND albumid = '1';

MySQL Error : Table 'xxxxxxxxxxx_forum.albumpicture' doesn't exist
Error Number : 1146
Request Date : Monday, December 14th 2009 @ 11:48:37 AM
Error Date : Monday, December 14th 2009 @ 11:48:38 AM
Script : http://www.xxxxxxxxxxxs.com/xxxxxxxx...cron&cronid=62
Referrer : http://www.xxxxxxxxxxxs.com/xxxxxxxx....php?do=modify
IP Address : xx.xxx.xxx.xxx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.85-community



Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT gp.*,p.caption
FROM socialgrouppicture gp
LEFT JOIN picture p on p.pictureid=gp.pictureid
WHERE state = 'visible' AND groupid = '1';

MySQL Error : Table 'xxxxxxxxxxx_forum.socialgrouppicture' doesn't exist
Error Number : 1146
Request Date : Monday, December 14th 2009 @ 12:06:13 PM
Error Date : Monday, December 14th 2009 @ 12:06:14 PM
Script : http://www.xxxxxxxxxxxs.com/xxxxxxxx...cron&cronid=62
Referrer : http://www.xxxxxxxxxxxs.com/xxxxxxxx....php?do=modify
IP Address : 84.xxx.xxx.xxx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.85-community
-----------










nvalid SQL:

INSERT INTO mailqueue
(dateline, toemail, fromemail, subject, message, header)
VALUES

(1260814051,
'webmaster@xxxxx.com',
'forumadmin@xxxxx.com',
'vBSEO Google/Yahoo Sitemap Updated',
'Hello!\n\nThe vBSEO Google/Yahoo Sitemap has been successfully generated for your vBulletin forums at:\nxxxxxxx (http://www.xxxxx.com/xxxx)\n\nReport...=======\nClick the following link for your vBSEO Google/Yahoo Sitemap Report:\nhttp://www.ssss.com/xxxx/vbseo_sitemap/\n\nSummary:\n============================\nForum Display: 2627\nShow Thread: 171504\nShow Post: 914987\nMember Profiles: 199493\nPoll Results: 1276\nBlog Entries: 86\nBlog Tags: 0\nAlbum URLs: \nSocial Groups URLs: 27\nTag URLs: 497\nArchive: 414\n\nTotal Indexed URLs: 10481249\nTotal Processing Time: 33,300,499.32 seconds\n\nGoogle ping: Successful.\nYahoo ping: Successful.\nAsk ping: Successful.\nMoreover ping: Successful.\nLive.com ping: Successful.\nBing.com ping: Successful.\n\n============================\nvBSEO (TM) c 2005-2009 Crawlability, Inc.\nhttp://www.crawlability.com/vbseo\nhttp://www.vbseo.com\n\n\nNote for vBSEO users: This version of the sitemap generator works with vBSEO 2.4.1 up.\nPlease download the most recent vBSEO here: http://www.vbseo.com/downloads/',
'From: =?utf-8?q?=D9=85=D9=86=D8=AA=D8=AF=D9=8A=D8=A7=D8=AA_=D8 =B3=D8=A7=D9=86=D8=AF=D8=B1=D9=88=D8=B2_=D8=A7=D9= 84=D8=AB=D9=82=D8=A7=D9=81=D9=8A=D8=A9?= <forumadmin@xxxxx.com>\nAuto-Submitted: auto-generated\nReturn-Path: forumadmin@xxxx.com\nMessage-ID: <20091214180823.27bde2ac067b@www.xxxxx.com>\nMIM E-Version: 1.0\nContent-Type: text/plain; charset=\"utf-8\"\nContent-Transfer-Encoding: 8bit\nX-Priority: 3\nX-Mailer: vBulletin Mail via PHP\nDate: Mon, 14 Dec 2009 12:08:23 -0600\n');

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, December 14th 2009 @ 12:07:31 PM
Error Date : Monday, December 14th 2009 @ 12:08:23 PM
Script : http://www.xxxx.com/xxxx/cronadmin.p...cron&cronid=62
Referrer : http://www.xxxx.com/xxxxi/cronadmin.php?do=modify
IP Address : xx.xx.75.xx
Username : xxxxxx
Classname : vB_Database
MySQL Version :

You should submit sitemap_index.xml.gz

Originally Posted by sandrose

MySQL Error : Table 'xxxxxxxxxxx_forum.albumpicture' doesn't exist
MySQL Error : Table 'xxxxxxxxxxx_forum.socialgrouppicture' doesn't exist

Thanks. these are known problems at this point. As vb moved to the new attachment/media/asset manager, pictures are no longer in their old locations.

MySQL Error : MySQL server has gone away

This is likely from your server. you may need to increase your wait_timeout setting in php.ini.

Originally Posted by Brian Cummiskey

You should submit sitemap_index.xml.gz

Brian, I worked that out as well before I came back here, but it seems to be working a treat with a few options such as albums turned off.

Getting this now in Google for some weird reason, can't find a robots.txt file:

Network unreachable: robots.txt unreachable
We were unable to crawl your Sitemap because we found a robots.txt file at the root of your site but were unable to download it. Please ensure that it is accessible or remove it completely.

That has nothing to do with the sitemap generator.
google likely can't reach your site when it tried. server or host network issue.

Thanks Brian. My site and sitemap can be seen but Google is having issues. Just ran generator and resubmitted:

We encountered an error while trying to access your Sitemap. Please ensure your Sitemap follows our guidelines and can be accessed at the location you provided and then resubmit.

Problem detected on: Dec 21, 2009

Filename Status Format Downloaded URLs submitted Indexed URLs
sitemap_1.xml.gz
Sitemap Dec 21, 2009 20,000 52
sitemap_2.xml.gz
Sitemap Dec 21, 2009 20,000 0
sitemap_3.xml.gz
Sitemap Dec 21, 2009 19,999 55
sitemap_4.xml.gz
Sitemap Dec 21, 2009 4,153 1

And checking some of the sitemap links, they show weird places that return invalid thread error:

<?xml version="1.0" encoding="UTF-8" ?>
- <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/09/sitemap.xsd">
- <url>
<loc>http://www.burnleyweb.com/</loc>
<priority>1</priority>
<lastmod>2009-12-22T05:04:58+00:00</lastmod>
<changefreq>daily</changefreq>
</url>
- <url>
<loc>http://www.burnleyweb.com/a/</loc>
<priority>0.8164</priority>
<lastmod>2009-12-21T22:18:42+00:00</lastmod>
<changefreq>daily</changefreq>
</url>
- <url>
<loc>http://www.burnleyweb.com/a/</loc>
<priority>0.8151</priority>
<lastmod>2009-12-21T21:10:22+00:00</lastmod>
<changefreq>daily</changefreq>
</url>
- <url>
<loc>http://www.burnleyweb.com/a/</loc>
<priority>0.8125</priority>
<lastmod>2009-12-20T19:02:09+00:00</lastmod>
<changefreq>daily</changefreq>
</url>
- <url>
<loc>http://www.burnleyweb.com/a/</loc>
<priority>0.9</priority>
<lastmod>2009-12-21T19:07:56+00:00</lastmod>
<changefreq>daily</changefreq>
</url>
- <url>
<loc>http://www.burnleyweb.com/a/index2.html</loc>
<priority>0.8996</priority>
<lastmod>2009-12-21T19:07:56+00:00</lastmod>
<changefreq>daily</changefreq>
...
...
...
...

I'd check with your host to see that they aren't blocking googlebot all of a sudden. It sounds dumb, but MANY hosts do this and it will kill your SEO potential.