vBSEO Sitemap Generator 2.2 Released

Hello,

I am getting following error message when I run vbseo sitemap 2.2 manually.

Code:

<!--
Database error in vBulletin 3.7.2:

Invalid SQL:

                SELECT *
                FROM thread AS thread
                WHERE forumid = 684
                    AND visible = 1
                    AND pollid &gt; 0;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Monday, July 14th 2008 @ 02:34:24 AM
Error Date    : Monday, July 14th 2008 @ 02:38:06 AM
Script        : http://www.hallagulla.com/urdu/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://www.hallagulla.com/urdu/vbseo_sitemap/index.php?rlist=true&amp;page=3
IP Address    : 90.203.186.148
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 
-->

Above error appear on creating 300th file.

Code:

......
......
[create sitemap file] filename: sitemap_299.xml.gz, number of urls: 20000 [14,229.5Kb mem used] [400,175s (+31s)]
[create sitemap in text format] part #300 [14,229.5Kb mem used] [400,175s (+0s)]

Any idea how to fix this error ?

Many thanks.

You need to increase wait_timeout setting. Also this is not a support thread. Please create a thread in sitemap support forums.

I already have a sitemap on my site and submitted to Google. Should I get rid of it after installing Sitemap Generator?

What exactly should I do after installing Sitemap Generator?

Any help for upgrade and installation.

What do you need help with exactly? The upgrade is rather painless. The instructions are included in the download file.

I have VBSEO 3.2.0 Do i need this also ?

Yes, it contains a few bug fixes in it. It is best to upgrade.

Ill get right on it thanks

Done , it dont look any different other than

vBSEO Google/Yahoo Sitemap Generator v2.2 is © 2005-2008 Crawlability, Inc. All Rights Reserved.

I wish i could auto prune old bot activity

Originally Posted by Michael Biddle

What do you need help with exactly? The upgrade is rather painless. The instructions are included in the download file.

I need help with upgrade "vBSEO Google/Yahoo Sitemap Generator v2.2" I don't want to mess up my site with all the error I'm looking at posts that member's encounter. I need professional to help me upgrade it.

Thanks

Originally Posted by charlesa6

I need help with upgrade "vBSEO Google/Yahoo Sitemap Generator v2.2" I don't want to mess up my site with all the error I'm looking at posts that member's encounter. I need professional to help me upgrade it.

Thanks

You can always use our Upgrade Service : vBSEO - Upgrade Service

Thanks, Mert. Will do! When I subscribe for upgrade, I hope you do the upgrade for me.

Originally Posted by DieselMinded

I wish i could auto prune old bot activity

you can. edit the config file

define('VBSEO_SM_PRUNE', 0); // logs age in days to prune

Hi,

I am experiencing the same problem, I did not notice it until today when I decided to upgrade to 2.2

probably it begun with some updates to htaccess files in the previous vbseo updates (?)

I get 404 not found with the re-written URL http://www.mondo3.com/forum/sitemap_index.xml.gz

but it works if I manually enter the vbseo_sitemap url with correct parameters: http://www.mondo3.com/forum/vbseo_si...p_index.xml.gz

so it must be something with the rewrite

here is my full .htaccess file in the forum root:

Code:

# Comment the following line (add '#' at the beginning)
# to disable mod_rewrite functions.
# Please note: you still need to disable the hack in
# the vBSEO control panel to stop url rewrites.
RewriteEngine On

# Some servers require the Rewritebase directive to be
# enabled (remove '#' at the beginning to activate)
# Please note: when enabled, you must include the path
# to your root vB folder (i.e. RewriteBase /forums/)
#RewriteBase /

#RewriteCond %{HTTP_HOST} !^www\.yourdomain\.com
#RewriteRule (.*) http://www.yourdomain.com/forums/$1 [L,R=301]

RewriteRule ^((urllist|sitemap).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|chat|cron)
RewriteRule ^(.*\.php(/.*)?)$ vbseo.php [L,QSA]

RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !^(admincp|modcp|clientscript|cpstyles|images)/
RewriteRule ^(.+)$ vbseo.php [L,QSA]

I tried to move che sitemap part on top and on bottom, same (no) result.

Can you please help me?

Thanks in advance.

Please try this: domain.com/sitemap_index.xml.gz returns 404