Google SitemapAdmin

[a_berezin]

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!

[Woodymon]

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

[Peaches]

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?

[a_berezin]

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);

[a_berezin]

Woody!
I can't understand what was happing.

[a_berezin]

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

[Woodymon]

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

[Woodymon]

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