Google SitemapAdmin

Use last version

CnA:

Even with ez-pages enabled and showing on my site and ezpages sidebox generation enabled, I still get no ezpages in the sitemapindex.xml file and the sitemapezpages.xml file is empty.

I'm using the latest version. I went and added it in by hand. Tried several times to get an auto-generation of the sitemapezpages.xml, but still no luck.

a_berezin:

v 1.3.6a 03.03.2007 10:55
Test one more your version!

I forgot to thank you Andrew for adding gss.xsl to your package. Makes it easy to view/sort the generated xml files.

Upgraded to the latest version of Google Sitemap Generation v 1.3.6a 03.03.2007 (latest version dated 03-21-07).

I have set in Config > Google XML Sitemap
XML Directory = /home/my_account/public_html

I observe success when creating all four sitemap files (all four files in webroot directory and chmod 777).

However when I view the contents of each xml file I see all my data correctly in the products, categories and ez-pages xml files. But when viewing sitemapindex.xml it does not contain data (just XML header info).

When generating feed update I observe:

Google Sitemap Generation v 1.3.6a 03.03.2007 10:55 started

Save path - "/home/your_account/public_html/"
Base URL - "http://www.yourdomain.com/"

(besides the other three correctly processed xml files I also see...)

Processing file: /home/your_account/public_html/sitemapindex.xml OK! Written 345 bytes
Generated Google Sitemap Index Successfully - http://www.yourdomain.com/sitemapindex.xml

• Note that before "updating" the sitemapindex.xml feed file it was originally 0 bytes. Then after I generated feed update the file increasesd to 345 bytes (as previously stated containing XML header info only but no data).

However the xml file should contain data similar to:

<sitemap>
	<loc>http://www.yourdomain.com/sitemapcategories.xml</loc>
	<lastmod>2007-03-18</lastmod>
</sitemap>
<sitemap>
	<loc>http://www.yourdomain.com/sitemapproducts.xml</loc>
	<lastmod>2007-03-18</lastmod>
</sitemap>
<sitemap>
	<loc>http://www.yourdomain.com/sitemapcategories.xml</loc>
	<lastmod>2007-03-18</lastmod>
</sitemap>

Any ideas what's happening? The mod used to work properly (updating sitemapindex.xml) but not since after upgrading to the most current mod version. Thanks for any ideas.

Woody

1146 Table 'mistywat_zc1.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I get this error when I try to install the .sql

Any suggestions?

Try this sql code:

SET @configuration_group_id=0;
SELECT (@configuration_group_id:=configuration_group_id) FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google XML Sitemap', 'Google XML Sitemap Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES 
(NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @configuration_group_id, 1, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @configuration_group_id, 2, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),'),
(NULL, 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),'),
(NULL, 'Lastmod tag format', 'GOOGLE_SITEMAP_LASTMOD_FORMAT', 'date', 'Lastmod tag format:<br />date - Complete date: YYYY-MM-DD (eg 1997-07-16)<br />full -    Complete date plus hours, minutes and seconds: YYYY-MM-DDThh:mm:ssTZD (eg 1997-07-16T19:20:30+01:00)', @configuration_group_id, 4, NOW(), NULL, 'zen_cfg_select_option(array(\'date\', \'full\'),'),
(NULL, 'Category priority', 'GOOGLE_SITEMAP_CAT_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL),
(NULL, 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 5, NOW(), NULL, NULL),
(NULL, 'Use Google Sitemaps Stylesheet', 'GOOGLE_SITEMAP_USE_XSL', 'true', 'Google Sitemaps Stylesheet gss.xsl', @configuration_group_id, 6, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'XML directory', 'GOOGLE_SITEMAP_XML_FS_DIRECTORY', '', 'Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.', @configuration_group_id, 7, NOW(), NULL, NULL),
(NULL, 'EZPages Header', 'GOOGLE_SITEMAP_EZPAGES_HEADER', 'true', 'Use EZPages Header links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'EZPages Sidebox', 'GOOGLE_SITEMAP_EZPAGES_SIDEBOX', 'true', 'Use EZPages Sidebox links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'EZPages Footer', 'GOOGLE_SITEMAP_EZPAGES_FOOTER', 'true', 'Use EZPages Footer links to feed sitemapezpages.xml?', @configuration_group_id, 10, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(NULL, 'EZPages changefreq', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_FREQ', 'weekly', 'How frequently the EZPages pages page is likely to change.', @configuration_group_id, 3, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),'),
(NULL, 'EZPages priority', 'GOOGLE_SITEMAP_EZPAGES_CHANGE_PRIOR', '0.5', 'The default priority of the EZPages URL. Valid values range from 0.0 to 1.0.', @configuration_group_id, 3, NOW(), NULL, NULL);

Woody!
I can't understand what was happing.:no:

Woody!
Check up, the function dir is accessible to you.

Anyone else employ the latest GoogleSitemapAdmin mod on Zen Cart 1.37 and observe an incorrectly generated sitemapindex.xml ???

This has my head spinning too.

Maybe an issue with writing to the webroot path. Will change path back to generate xml files in shoproot and see if that makes any diff.

Woody

Yep. I confirmed that on my system the latest version of mod has problem generating correct sitemapindex.xml file when the path (in Config > Google XML Sitemap) is set to the webroot (/home/account/public_html/). But sitemapindex.xml is correctly generated when path points to the the shoproot.

(this does not matter for the other three xml files).

Does not Google want the sitemap xml files to be in the webroot (public_html)?

The moral of this story is to manually view and check your xml sitemap file content immediately after generating, otherwise you won't know is what might be missing.

Just an idea. Would be useful if the pop-up window, reporting successful xml file generation/update, could also display count of products, categories, or ez-pages processed. Or in case of the sitemap index, include count of xml files processed and written into the sitemapindex.xml file.

This would provide a general heads-up if anything might be wrong. Just an idea.

Thanks again Andrew.

Woody

Woodymon:

Just an idea. Would be useful if the pop-up window, reporting successful xml file generation/update, could also display count of products, categories, or ez-pages processed. Or in case of the sitemap index, include count of xml files processed and written into the sitemapindex.xml file.
OK!
v 1.3.7 19.03.2007 19:14

1. Add records count statistic

a_berezin:

OK!
v 1.3.7 19.03.2007 19:14

1. Add records count statistic

WOW! That was quick! Thanks Andrew.

Those count numbers are helpful.

And after installing new version sitemapindex.xml is once again correctly generated in /public_html/

Its like magic! :wink2:

Woody

I added the sql you suggested and it worked like magic until I tried to view my products and got this error.

XML Parsing Error: not well-formed
Location: http://annsceramics.com/sitemapproducts.xml
Line Number 5672, Column 33: <loc>http://annsceramics.com/8-frame-p-827.html</loc>
--------------------------------^

Any suggestions?

Nevermind...I'm a ditz. Just corrected the product name and everything went smoothly. Thank you so much for this:)

Peaches:

I added the sql you suggested and it worked like magic until I tried to view my products and got this error.

XML Parsing Error: not well-formed
Location: http://annsceramics.com/sitemapproducts.xml
Line Number 5672, Column 33: <loc>http://annsceramics.com/8-frame-p-827.html</loc>
--------------------------------^

Any suggestions?

Hi folks.... having trouble here. Any help appreciated. Unlike the other fellow, install went fine. But when I try generate a sitemap, here is the outcome...

Google Sitemap Generation (v 1.3.7 19.03.2007 19:14) started

Save path - "http://www.ironbikeworx.com/zc/gsm/"
Base URL - "http://www.ironbikeworx.com/"

Processing file: http://www.ironbikeworx.com/zc/gsm/sitemapproducts.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/sitemapproducts.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Product Sitemap Generation FAILED!

Processing file: http://www.ironbikeworx.com/zc/gsm/sitemapcategories.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/sitemapcategories.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!

Processing file: http://www.ironbikeworx.com/zc/gsm/sitemapezpages.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/sitemapezpages.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Category Sitemap Generation FAILED!

Processing file: http://www.ironbikeworx.com/zc/gsm/sitemapindex.xml
Warning: fopen(http://www.ironbikeworx.com/zc/gsm/sitemapindex.xml) [function.fopen]: failed to open stream: HTTP wrapper does not support writeable connections. in /home/ironbikeworx/www/www/zc/googlesitemap.php on line 161
Failed!
ERROR: Google Sitemap Index Generation FAILED!

Total Execution Time 0:0.0225

bhunted:

Hi folks.... having trouble here.

/zc/gsm/sitemapproducts.xml
/zc/gsm/sitemapcategories.xm
/zc/gsm/sitemapezpages.xml
/zc/gsm/sitemapindex.xml
Do each of these four files already exist in your /zc/gsm/ directory?
And does each have write permissions enabled? (cmod777)

Woody

bhunted:

Save path - "http://www.ironbikeworx.com/zc/gsm/"

Directory using for saving XML files. Setting it to your root directory. If empty, Google Sitemap use DIR_FS_CATALOG directory.

I think it is necessary to refuse this parameter.

To follow-up on Andrew's post above, if you want to store the mod's XML files in your webroot directory (that;s where I have mine) you may want to try setting in admin (Config >Google XML Sitemap):

XML directory /home/your_account/public_html/

(replace your_account above with your account name on your server. See your Zen Cart configure.php file for the correct path.)

Woody

Hi gang and thanks for responding. What I ended up doing was just leaving it blank and all went to the root. Go figure. Again, many thanks for your help...
:clap:

Andrew-

When you state the mod defaults to writing the "root", do you mean the account root, or the web root, or the shop root?

Woody