Verifying your vBSEO Google/Yahoo Sitemap Generator is Installed Correctly

**Oleg Ignatiuk** · 02-03-2009 07:09 PM

Try to change this line:

RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron)

to:
RewriteCond %{REQUEST_URI} !(admincp/|modcp/|cron|vbseo_sitemap/)

**samuelss** · 02-03-2009 07:24 PM

Thanks for this. I have made the changes and still not able to access the sitemap here - http://www.alpharadiotv.com/forum/sitemap_index.xml.gz

.htaccess now looks like this:
RewriteEngine on
RewriteCond %{HTTP_HOST} .*alpharadiotv.com 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]

AS mentioned earlier I have disabled the archive and just checking if that will make any difference in the bolded line.

Thanks.

**Oleg Ignatiuk** · 02-03-2009 09:28 PM

Please open a ticket with ftp access for troubleshooting.

Btw, do you have line-breaks there? i.e.:

Code:

RewriteEngine on
RewriteCond %{HTTP_HOST} .*alpharadiotv.com 
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]

**khurtsiya** · 02-15-2009 12:50 PM

Hello everybody!

Downloaded and installed Sitemap Generator and manually started it by clicking "Run Sitemap Generator". Sitemap generated cuz I see report, but the link it shows in CP (Your Google Sitemap Index URL: kiev.com.ua/forum/sitemap_index.xml.gz) is not working...

Any ideas why?

**nadeemjp** · 02-20-2009 08:12 PM

when i "run sitemap generator" the following error occurs:

Code:

[SECTION START] showthread [7,843.3Kb mem used] [3,598,814s (+3,598,814s)]
[archive homepage] [8,292.8Kb mem used] [3,598,822s (+8s)]
[SECTION START] forumdisplay archived [8,294.4Kb mem used] [3,598,822s (+0s)]
[SECTION START] member [8,396.2Kb mem used] [3,598,822s (+0s)]
[SECTION START] polls [8,338.7Kb mem used] [3,598,822s (+0s)]
[SECTION START] blogs [8,360.7Kb mem used] [3,598,822s (+0s)]
[SECTION START] albums [8,380.4Kb mem used] [3,598,822s (+0s)]
[SECTION START] groups [8,384.9Kb mem used] [3,598,822s (+0s)]
		Database error

Another problem is that on certain forums "linkback,pingback etc is ON" is not displayed in the footer area just like html off, bb code on kind of legend. what should i do to enable this in every category of the forum?

thank you

**nadeemjp** · 02-20-2009 08:13 PM

Also I used to get reports in the very beginning but now i dont get any sitemap reports. what should i do to get these reports?

**Michael Biddle** · 02-20-2009 08:30 PM

Right click that page and view source. Copy and paste error here.

**nadeemjp** · 02-20-2009 10:16 PM

this is the error in the source:

Code:

[SECTION START] showthread [7,842.5Kb mem used] [3,606,328s (+3,606,328s)]<br/>
[archive homepage] [8,294.7Kb mem used] [3,606,331s (+2s)]<br/>
[SECTION START] forumdisplay archived [8,296.3Kb mem used] [3,606,331s (+0s)]<br/>
[SECTION START] member [8,398.3Kb mem used] [3,606,331s (+0s)]<br/>
[SECTION START] polls [8,342.5Kb mem used] [3,606,331s (+0s)]<br/>
[SECTION START] blogs [8,364.3Kb mem used] [3,606,331s (+0s)]<br/>
[SECTION START] albums [8,384.2Kb mem used] [3,606,331s (+0s)]<br/>
[SECTION START] groups [8,388.8Kb mem used] [3,606,331s (+0s)]<br/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
 <title>FamilyBunker Pakistani Forum | Radio TV Channels | Urdu Poetry | Arcade Games | Cricket | Blogging Database Error</title>
 <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
 <meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
 <style type="text/css">
 <!-- 
 body { background-color: white; color: black; }
 #container { width: 400px; }
 #message   { width: 400px; color: black; background-color: #FFFFCC; }
 #bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
 .bodytext  { font: 8pt/11pt verdana, arial, sans-serif; }
 a:link     { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
 a:visited  { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
 -->
 </style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
 <td><img src="http://www.familybunker.com/forums/i...p?type=dberror" alt="Database Error" width="48" height="48" /></td>
 <td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
 <td class="bodytext" colspan="2">The FamilyBunker Pakistani Forum | Radio TV Channels | Urdu Poetry | Arcade Games | Cricket | Blogging database has encountered a problem.</td>
</tr>
<tr>
 <td colspan="2"><hr /></td>
</tr>
<tr>
 <td class="bodytext" colspan="2">
  Please try the following:
  <ul>
   <li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
   <li>Open the <a href="/">www.familybunker.com</a> home page, then try to open another page.</li>
   <li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
  </ul>
 </td>
</tr>
<tr>
 <td class="bodytext" colspan="2">The www.familybunker.com forum technical staff have been notified of the error, though you may <a href="mailto:webmaster@familybunker.com">contact them</a> if the problem persists.</td>
</tr>
<tr>
 <td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>

<!--
Database error in vBulletin 3.8.1:
Invalid SQL:
           SELECT count(*)as cnt,max(dateline) as lastupdate
           FROM groupmessage
           WHERE groupid='1';
MySQL Error   : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Friday, February 20th 2009 @ 08:15:10 PM
Error Date    : Friday, February 20th 2009 @ 08:15:13 PM
Script        : http://www.familybunker.com/forums/v...eo_sitemap.php
Referrer      : vBSEO Google / Yahoo Sitemap for vBulletin
IP Address    : 60.35.7.151
Username      : Unregistered
Classname     : vB_Database_MySQLi
MySQL Version : 
-->

</body>
</html>

**nadeemjp** · 02-20-2009 10:24 PM

also when i click the archive pages that appear in the footer area, i get the following error:

Code:

<br />
<b>Warning</b>:  chdir() [<a href='function.chdir'>function.chdir</a>]: No such file or directory (errno 2) in <b>/home/*****/public_html/forums/vbseo.php</b> on line <b>166</b><br />
<br />
<b>Warning</b>:  include() [<a href='function.include'>function.include</a>]: Failed opening '/home/*****/public_html/forums/archive/index.php' for inclusion (include_path='.:/usr/local/php52/pear') in <b>/home/****/public_html/forums/vbseo.php</b> on line <b>192</b><br />

**Shadab** · 02-20-2009 10:47 PM

MySQL Error : Unknown column 'groupid' in 'where clause'

Apply the fix mentioned in this post : Links not working after site transfer

Also take a look at this thread :
[How To] Completely Turn Off the vBulletin Archive

**nadeemjp** · 02-21-2009 12:51 AM

yes shadab, i did apply those changes but still the sitemap is not running and giving the same error.

and as for the turning off vbulletin archive, i would like the archive to stay on. thats what i intended to know how to fix this

**nadeemjp** · 02-21-2009 01:05 AM

ok, upon shadab's advice, i went through once again.
it didnt work.

but then i consistently re-did those changes and then tried it again and this time the sitemap was generated. i dont know what i was missing during the first 3-4 tries and why i accomplished it later. but the important thing is, finally i was able to generate the sitemap. thanx shadab.

now as for the archives, do we need to turn them off? i have seen on some forums that they have the archives in the footer area and i wanted the same for my forum. so by following the steps, will i still be able to display those archives?

**nadeemjp** · 02-21-2009 01:11 AM

a question: where is the robot.txt file located? i tried to find a file with this name but couldnt

**Shadab** · 02-21-2009 03:41 AM

Originally Posted by nadeemjp

ok, upon shadab's advice, i went through once again. it didnt work. but then i consistently re-did those changes and then tried it again and this time the sitemap was generated. i dont know what i was missing during the first 3-4 tries and why i accomplished it later. but the important thing is, finally i was able to generate the sitemap. thanx shadab.

Glad you got it working, finally.

Originally Posted by nadeemjp

now as for the archives, do we need to turn them off? i have seen on some forums that they have the archives in the footer area and i wanted the same for my forum. so by following the steps, will i still be able to display those archives?

IMO, the archives are not quite needed when you have vBSEO. Heres a good read :
Why the vBulletin archive is useless and counterproductive

Originally Posted by nadeemjp

a question: where is the robot.txt file located? i tried to find a file with this name but couldnt

It's located at : domain.com/robots.txt [See example]
If it's not there, you can create it yourself.

**nadeemjp** · 02-21-2009 04:14 AM

thank you very much shadab, bro u have been of great help.

so i create this text file with the name robots.txt in the same format (as you showed in your example) and simply upload it?

i am sorry for my ignorance, but why i dont have it and why is it necessary? bear with my ignorance a bit further

thanx

Verifying your vBSEO Google/Yahoo Sitemap Generator is Installed Correctly

LinkBack

Thread Tools

Display

Google Sitmeap Index link not working

Similar Threads

vBSEO Google/Yahoo Sitemap Generator installed?

Installed vBSEO + vBSEO Google/Yahoo Sitemap Generator v.2.0

vBSEO Google/Yahoo Sitemap Generator

vBSEO Google/Yahoo Sitemap Generator

Posting Permissions