Google SitemapAdmin

[rwment]

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:

<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="gss.xsl"?>
<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/site.../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

[a_berezin]

Will be fixed in the following version.

[a_berezin]

v 1.3.10 18.05.2007 12:12
1. Add ez-pages multilanguage support;
2. Fixed filesize error.

[rwment]

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

[rwment]

You Rock Andrew, worked like a charm. Thanks

[Mr hum]

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

[a_berezin]

O! Yes, forgotten about it
Fixed
v 1.3.11 19.05.2007 2:52
1. Remove non used functions.

[maxus]

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

[maxus]

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/...#forumpost6922

[a_berezin]

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