Google SitemapAdmin

garyclemens:

I have been trying to install google site map. I was able to sucessefully install it on another site on the same server. It functions fine on that site. The site im having problems with it doesn't show up under tools.

I looked at the sql database on the site that works. Its listed under the ...

It doesn't appear there on the site thats not functioning correctly. I tried to manually creat it, don't know if i did it correct, but I was able to get it in the sql database. It still doesn't show up under tools. I have even reloaded all files! Using 1.3.7- Can someone help me?
First , do not give out URL's to your administrative areas including phpmyadmin!

Second, what errors are you observing when you installed the SQL patch?

Did you have previous version installed before installing new version?

Try patch uninstall.sql.
Then install.sql

Avoid "uploading" in Tools > Install SQL Patches.
Instead paste in the SQL.

Report any errors, obfuscating private data (including admin directory name).

Woody

After you update the site map admin>tools>Google XML sitemap and notice the 4 files in the root directory have updated.
What is the process to view the sitemap index to see what google has indexed?

haredo:

After you update the site map admin>tools>Google XML sitemap and notice the 4 files in the root directory have updated.
What is the process to view the sitemap index to see what google has indexed?

Log into your Google Webmasters account.

In Zen Cart admin > Tools > Google XML Sitemap
Andrew provided a nice blue box with a link to do just that ;-)

Woody

Woody,
Yes, I went to google, but I would like to look at the sitemap google generated.
Can i view the files on the sitemapindex???
https://www.haredo.com/sitemapindex.xml

haredo:

Woody,
Can i view the files on the sitemapindex???
https://www.haredo.com/sitemapindex.xml

Woody, thank you for the advice.
Went through my notes and I upated to 1.3.8 yesterday
There might be a small bug so I reinstalled 1.3.7 and now I can view products and categories to notice changes.

v 1.3.9 02.05.2007 4:57

1. gss.xls - Support new sitemaps.org namespace 0.9.
2. Remove duplicated links.

haredo:

Yes, I went to google, but I would like to look at the sitemap google generated. Can i view the files on the sitemapindex???
https://www.haredo.com/sitemapindex.xml

Google doee not generate the sitemap. You do. That is, this is what the mod does ;-)

You can view the sitemap files you generate and store on YOUR server, as any other text type file, via a text editor. or via an an XML viewer, or in your browser.

Currently you have generated three sitemap files.

1. http://www.haredo.com/sitemapindex.xml
2. http://www.haredo.com/sitemapcategories.xml
3. http://www.haredo.com/sitemapproducts.xml

The index file just points to the other two, where your products and category pages are indexed.

Since Andrew included "Google Sitemaps Stylesheets" into the mod, you should be able to directly view those files in your browser.

Hope this helps,
Woody

Just installed this mod and it's working great. Just wondering why I can't find the default static html files like shipping info and privacy pages anywhere in the generated xml files.
Should I add these manually (seperate xml file?) or is there no need to include these in the Google sitemap? I just think it's strange since the ez-pages are included. Did I miss something?

Another question.

Found out that there was an update (1.3.8) while I installed 1.3.7. Decided to upgrade by overwriting the 'old' files with the new. Couldn't find any differences in the new sql code so I didn't reinstall the sql part.

Files are generated fine but somehow the xml files show up empty when opened in a browser. Tried several browsers, clear caches and even restarted but the xml files remain blank when opened in a browser. When opened using ftp and a texteditor there's no problem, everything looks fine.

I'm sure the browser displayed fine under 1.3.7. Could this be a minor hick up in a stylesheet somewhere?

davale:

Just wondering why I can't find the default static html files like shipping info and privacy pages anywhere in the generated xml files.
All this links to static pages I defined in EZ-pages and use only EZ-pages box (don't use Information box). It's more flexybility. So, I don't need to build sitemap for old static pages.
davale:

Should I add these manually (seperate xml file?)Yes, you can manually add a seperate xml file.

Ok apparently I need to shoot the seeing eye dog because neither of us could find this problem or figure it out even after reading all 35 pages of this thread. Everything installed right (the third time anyway) and it SEEMS that everything worked right right up until I go to create the sitemap and I get this error:
Google Sitemap Generation (v 1.3.9 02.05.2007 4:57) started

Save path - "/www/htdocs/"
Base URL - "http://www.got-its.com/"

Processing file: /www/htdocs/sitemapproducts.xml OK! Written 319 records, 65755 bytes
Generated Google Product Sitemap Successfully - http://www.got-its.com/sitemapproducts.xml

Processing file: /www/htdocs/sitemapcategories.xml OK! Written 30 records, 6212 bytes
Generated Google Category Sitemap Successfully - http://www.got-its.com/sitemapcategories.xml

Processing file: /www/htdocs/sitemapezpages.xml OK! Written 3 records, 844 bytes
Generated Google EZPages Sitemap Successfully - http://www.got-its.com/sitemapezpages.xml

Warning: filesize(): Stat failed for sitemapezpages.xml (errno=2 - No such file or directory) in /usr/local/etc/httpd/htdocs/zencart/googlesitemap.php on line 220

Warning: filesize(): Stat failed for sitemapcategories.xml (errno=2 - No such file or directory) in /usr/local/etc/httpd/htdocs/zencart/googlesitemap.php on line 220

Warning: filesize(): Stat failed for sitemapproducts.xml (errno=2 - No such file or directory) in /usr/local/etc/httpd/htdocs/zencart/googlesitemap.php on line 220
Processing file: /www/htdocs/sitemapindex.xml OK! Written 0 records, 372 bytes
Generated Google Sitemap Index Successfully - http://www.got-its.com/sitemapindex.xml

If you have not already submitted the sitemap index to Google click this link Google Ping

Total Execution Time 0:0.8737

It appears that everything but the sitemapindex file created correctly, just to make sure I opened it up and this is all it had in there:

<sitemapindex xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9
http://www.sitemaps.org/schemas/sitemap/0.9/siteindex.xsd"
xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
</sitemapindex>

The other three files have what appears to be the correct info in them so it has to be just a little glitch somewhere.

I am using GoogleSitemap ver 1.3.9 and ZC ver 1.3.7

Will be fixed in the following version.

v 1.3.10 18.05.2007 12:12

1. Add ez-pages multilanguage support;
2. Fixed filesize error.

Andrew, you are the man. You spit out versions faster than a vegetarian cat in a bird shop lol.

You Rock Andrew, worked like a charm. Thanks

Hey guys i am getting this error message when i try and set it up.

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of fsockopen(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 412

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of fsockopen(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 412

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php:412) in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/includes/functions/sessions.php on line 108

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php:412) in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php:412) in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/includes/init_includes/init_templates.php on line 78
Google Sitemap Generation (v 1.3.10 18.05.2007 12:12) started

Save path - "/var/www/vhosts/mrhumbucker.co.nz/httpdocs/"
Base URL - "http://www.mrhumbucker.co.nz/"

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 263
Processing file: /var/www/vhosts/mrhumbucker.co.nz/httpdocs/sitemapproducts.xml OK! Written 1431 records, 291196 bytes
Generated Google Product Sitemap Successfully - http://www.mrhumbucker.co.nz/sitemapproducts.xml

Warning: strtotime() [function.strtotime]: Called with an empty time parameter. in /var/www/vhosts/mrhumbucker.co.nz/httpdocs/googlesitemap.php on line 287
Processing file: /var/www/vhosts/mrhumbucker.co.nz/httpdocs/sitemapcategories.xml OK! Written 136 records, 26878 bytes
Generated Google Category Sitemap Successfully - http://www.mrhumbucker.co.nz/sitemapcategories.xml

ERROR: Google Category Sitemap Generation FAILED!

Processing file: /var/www/vhosts/mrhumbucker.co.nz/httpdocs/sitemapindex.xml OK! Written 2 records, 608 bytes
Generated Google Sitemap Index Successfully - http://www.mrhumbucker.co.nz/sitemapindex.xml

Total Execution Time 0:1.2570

Heres my setup

**Database: **MySQL 5.0.27 **PHP Version: **5.0.4 (Zend: 2.0.4-dev)

**HTTP Server: **Apache/2.0.52 (CentOS)

Zen Cart v1.3.7

Cheers

O! Yes, forgotten about it :blush:
Fixed
v 1.3.11 19.05.2007 2:52

1. Remove non used functions.

Privet Andrey

One problem
Only one xml generated for me : sitemapproducts.xml
All other hase size 0 Kb. they empty...

and popup window where I see

Google Sitemap Generation (v 1.3.11 19.05.2007 2:52) started

Processing file: /shop/sitemapproducts.xml OK! Written 564 records, 109216 bytes
Generated Google Product Sitemap Successfully - http://shop.skyhorse.cz/sitemapproducts.xml

1054 Unknown column 'c.parent_id' in 'on clause'
in:
[SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName FROM categories c, categories_description cd LEFT JOIN categories_description cd2 ON c.parent_id=cd2.categories_id AND cd2.language_id='2' WHERE c.categories_id='452' AND cd.categories_id='452' AND cd.language_id='2' LIMIT 1]

Im use SEO mode... and meibe something wrong...but I need SEO

please help

Im sorry - cant edit my post

Im use MySQL 5 and Ultimate_SEO_URLs_v2.103 hase some error for working with vs 5

Here is solutions

file seo.url.php

code
$sql = "SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM ".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd

must be
$sql = "SELECT c.categories_id, c.parent_id, cd.categories_name as cName, cd2.categories_name as pName
FROM (".TABLE_CATEGORIES." c,
".TABLE_CATEGORIES_DESCRIPTION." cd)

information from here
http://www.zencart.cz/modules/newbb/viewtopic.php?post_id=6922#forumpost6922

Privet maxus!
It not my error. Probably it is an error from seo module. I don't use this SEO modules.