Google Sitemap v2.7

**grynmoors** · 05-16-2009, 01:02 PM

Right, I was thinking "smarty" code. I submitted it to Google and we'll see what happens. I can't post my completed code to the forums for some reason, it keeps getting cut off.

**carefree2** · 05-16-2009, 01:19 PM

google has crawled and indexed 50,000 of my urls so far using my script, so i know it works.

Just add some settings variables at the top of the page, its quite acceptable for clients to edit a few lines

**ikhebdexfactor** · 05-18-2009, 07:28 AM

I get the following error? any sollutions yet?

The following tags were not closed: urlset. Error processing resource 'http://www.ikhebdexfactor.nl/sitemap.php'.

**carefree2** · 05-18-2009, 09:04 AM

Originally Posted by ikhebdexfactor

I get the following error? any sollutions yet?

The following tags were not closed: urlset. Error processing resource 'http://www.ikhebdexfactor.nl/sitemap.php'.

Error: Table 'ikhebdex_vshare.video' doesn't exist

Table doesn't exist

The script works. Use my version for google

**ikhebdexfactor** · 05-18-2009, 09:14 AM

Don't know what i am doing wrong then, im using your code already, filled in datebase info double checked it, and filled in my URL.

Code:

echo "<url><loc>http://www.ikhebdexfactor.nl/video/".$info[0]."/".$SefUrl."/</loc></url>";

mmmmmmmm help :)

Originally Posted by carefree2

Error: Table 'ikhebdex_vshare.video' doesn't exist

Table doesn't exist

The script works. Use my version for google

**carefree2** · 05-18-2009, 09:26 AM

Yeah im still using version 2.6. Version 2.7 database is different

Change:

Code:

    $sql = "Select  VID, title, description, adddate, flvdoname, duration from video where approve=1 and active=1";

to

Code:

    $sql = "Select  * from videos where video_approve=1 and video_active=1";

**grynmoors** · 05-18-2009, 10:45 AM

Those of you using this for 2.7, just eliminate the database connection (you can also do this for 2.6) and use the sql that I posted (it's for 2.7)

**grynmoors** · 05-18-2009, 10:51 AM

Oh...gonna have to scratch it, it doesn't work for 2.7 at all and nothing was indexed by google. Here's what Google said:

Paths don't match
We've detected that you submitted your Sitemap using a URL path that doesn't include the www prefix (for instance, http://example.com/sitemap.xml). However, the URLs listed inside your Sitemap do use the www prefix (for instance, http://www.example.com/myfile.htm).

Parsing error
We were unable to read your Sitemap. It may contain an entry we are unable to recognize. Please validate your Sitemap before resubmitting.

Empty Sitemap
Your Sitemap does not contain any URLs. Please validate and resubmit your Sitemap.

Invalid XML tag
This tag was not recognized. Please fix it and resubmit. (this one is my fault, I'm going to fix it)

Leading whitespace
We've detected that your Sitemap file begins with whitespace. We've accepted the file, but you may want to remove the whitespace so that the file adheres to the XML standard.

I'm gonna fix the XML tag thing and resubmit, the only other issue is the www.

*IF* any one has problems with this, there is another post with a sitemap somewhere in the forums. I had been using it the entire time I had 2.6 so if this one posted by carefree doesn't work, try the other one. It works for him, it should work for you too but check for the other one.