Database Error when running generator

Which one Ceri, the root directory or the data directory .htaccess?

This is the one from the root directory

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/|cron)
RewriteRule ^((archive/)?(.*\.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]
RewriteEngine On
RewriteRule ^view_(.*).htm$ view.php?pg=$1
RewriteRule ^((urllist|sitemap).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]
<Files 403.shtml>
order allow,deny
allow from all
</Files>

deny from 92.100.81.210

The one in the data directory says "deny from all", what should it read.?

Originally Posted by rolfw

This is the one from the root directory

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/|cron)
RewriteRule ^((archive/)?(.*\.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]
RewriteEngine On
RewriteRule ^view_(.*).htm$ view.php?pg=$1
RewriteRule ^((urllist|sitemap).*\.(xml|txt)(\.gz)?)$ vbseo_sitemap/vbseo_getsitemap.php?sitemap=$1 [L]
<Files 403.shtml>
order allow,deny
allow from all
</Files>

deny from 92.100.81.210

The one in the data directory says "deny from all", what should it read.?

Hi,

No both of these are looking fine, if I am honest I am not sure what the problem is but when I view http://www.thamesvalleybirds.co.uk/sitemap_index.xml.gz I get a 404 error then redirected to your forum homepage, Marco has confirmed he doesn't get this problem and that it loads find. But then when checking with HTTP Header Viewers also some get 301 others get 200..

By the error that google is showing it seems they are being redirected to your forum home also which is why its complaining about the HTML content.

Could it be a folder permissions problem perhaps?

For example what permissions should the tar.gz have, they are 666 at the moment, the data folder is 777

Please make sure vbseo_sitemap folder is set to chmod 755 and vbseo_sitemap/data folder is set to chmod 777

Yep, just checked, both are as you have suggested already.

Not knowing how Google operate, do they download the tar.gz, or do they execute it and download the contents? In which case, should the tar.gz files be something other than 666?

Can you please try using the following .htaccess in 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 ^view_(.*).htm$ view.php?pg=$1 [L,R=301]

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

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron|vbseo_sitemap)
RewriteRule ^((archive/)?(.*\.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]
<Files 403.shtml>
order allow,deny
allow from all
</Files>

deny from 92.100.81.210

Thanks Mert, have uploaded your revised .htaccess and resubmitted, looks promising, as it's been 20 minutes or so and no error message yet, still showing the clock

Your sitemap files started to work correct after the .htaccess change. Hopefully this should resolve the issue.

Thanks Mert and everyone, much appreciated, hopefully this has done the trick.

Just to confirm that it's all up and working, thanks again.