Verifying your vBSEO Google/Yahoo Sitemap Generator is Installed Correctly

**Carlos SEO** · 02-28-2009 10:13 PM

Installed and verified.

**Carlos SEO** · 03-01-2009 07:18 PM

Now, many hours and hours later, the google bot sees some errors in my sitemap, and google marked my sitemap in red "warnings" label.

**Crank** · 03-28-2009 03:18 PM

I installed after receiving the error email.

Please check I think something is still missing from my install. I am getting a red errors message on Google.

Digital Sellers - buy, sell or trade digital goods. Webmaster's trade forum

This is what I am getting when I go for the sitemap. I think I am missing the actual file. Is that right?

This XML file does not appear to have any style information associated with it. The document tree is shown below.

−
<sitemapindex xsi:schemaLocation=" http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/09/siteindex.xsd">
−
<sitemap>
−
<loc>
http://www.digitalsellers.net/commun...temap_1.xml.gz
</loc>
<lastmod>2009-03-28T13:50:29+00:00</lastmod>
</sitemap>
</sitemapindex>

OK I got the email that it is working now. Thanks.

**auto_freak** · 04-06-2009 12:38 AM

Everytime I run the sitemap generation through vbulletin admin panel, it gives me this error:

Code:

[SECTION START] showthread [5,643.2Kb mem used] [336,909s (+336,909s)]
[archive homepage] [6,004.3Kb mem used] [336,910s (+1s)]
[SECTION START] forumdisplay archived [6,005.9Kb mem used] [336,910s (+0s)]
[SECTION START] member [6,035.7Kb mem used] [336,910s (+0s)]
[SECTION START] polls [5,864.4Kb mem used] [336,912s (+2s)]
[SECTION START] blogs [5,884.4Kb mem used] [336,912s (+0s)]
[SECTION START] albums [5,887.1Kb mem used] [336,912s (+0s)]
[SECTION START] groups [5,887.2Kb mem used] [336,912s (+0s)]
   	 	 	 	 	 	    	 	Database error

**Shadab** · 04-06-2009 02:01 AM

Please view the page's/frame's source code and
paste the (commented) SQL query which resulted in error.

Also, are you running the latest version of vBSEO Sitemap Generator ?

**auto_freak** · 04-06-2009 11:05 AM

Originally Posted by Shadab

Please view the page's/frame's source code and
paste the (commented) SQL query which resulted in error.

Also, are you running the latest version of vBSEO Sitemap Generator ?

running the latest sitemap generator. this is the page source:

Code:

	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en">
	<head>
	<script type="text/javascript">
	<!--
	// get out of any containing frameset
	if (self.parent.frames.length != 0)
	{
		self.parent.location.replace(document.location.href);
	}
	// -->
	</script>
	<title>WheelsBD Forum Admin Control Panel</title>
	</head>

		<frameset cols="195,*"  framespacing="0" border="0" frameborder="0" frameborder="no" border="0">
		<frame src="index.php?do=nav" name="nav" scrolling="yes" frameborder="0" marginwidth="0" marginheight="0" border="no" />
		<frameset rows="20,*"  framespacing="0" border="0" frameborder="0" frameborder="no" border="0">
			<frame src="index.php?do=head" name="head" scrolling="no" noresize="noresize" frameborder="0" marginwidth="10" marginheight="0" border="no" />
			<frame src="index.php?do=home" name="main" scrolling="yes" frameborder="0" marginwidth="10" marginheight="10" border="no" />
		</frameset>
	</frameset>
	
	<noframes>
		<body>
			<p>Your browser does not support frames. Please get one that does!</p>
		</body>
	</noframes>
	</html>

**Shadab** · 04-06-2009 11:21 AM

No, that's not the actual source.
When the error occurs, do this: assuming you are using Firefox

Right Click (in the right-side frame) » This Frame » View Frame Source

and look for the part where it reports "Invalid SQL:", "MySQL Error:" , etc.

**auto_freak** · 04-06-2009 11:47 PM

Ok got it now:

Code:

<!--
Database error in vBulletin 3.8.2:

Invalid SQL:

         		SELECT count(*)as cnt,max(dateline) as lastupdate
         		FROM vb_groupmessage
         		WHERE groupid='2';

MySQL Error   : Unknown column 'groupid' in 'where clause'
Error Number  : 1054
Request Date  : Monday, April 6th 2009 @ 10:46:32 PM
Error Date    : Monday, April 6th 2009 @ 10:46:35 PM
Script        : http://wheelsbd.com/forum/vbseo_sitemap/vbseo_sitemap.php
Referrer      : http://wheelsbd.com/forum/vbseo_sitemap/index.php
IP Address    : 99.255.236.19
Username      : Unregistered
Classname     : vB_Database
MySQL Version : 
-->

**Michael Biddle** · 04-07-2009 12:11 AM

Please update to 2.5. Seems you are running 2.2.

**auto_freak** · 04-07-2009 12:40 AM

thanks, upgraded to 2.5! it works fine now. I found out that the uploads content from the vbseo_sitemap download was not uploaded.

**BlackberryOS** · 04-08-2009 03:28 AM

need help. i added the info to the htacess file. Loaded everything correctly. Ran the sitemap generator but when I go to see the sitemap thing, says something about the xml file. Any help?

**Oleg Ignatiuk** · 04-08-2009 06:31 AM

What exactly is the message?

**breakpoint** · 04-09-2009 03:59 PM

Originally Posted by auto_freak

thanks, upgraded to 2.5! it works fine now. I found out that the uploads content from the vbseo_sitemap download was not uploaded.

that happened to me, I had uploaded and followed the steps correctly but it didnt update. So I reuploaded again and it worked after.

**skylab** · 04-09-2009 04:25 PM

Hey everyone. New here. Is it possible that the file can be located in forums/vbseo_sitemap/data/sitemap_1.xml.gz? I don't have vbSEO yet. Just working on sitemaps right now.

**Michael Biddle** · 04-09-2009 04:28 PM

They are physically located there, however, with a rewrite rule we have it virtually be in the forum root.

Verifying your vBSEO Google/Yahoo Sitemap Generator is Installed Correctly

LinkBack

Thread Tools

Display

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