Google SitemapAdmin

[aharper78]

Yes, they must be in root directory. They must have write (0666) permission.

I have ch/mod set to 777 and still the .xml sitemap files are blank, are you suppose to wait for the generation after clicking the generate sitemap? If so, how long?

[PhillipHarrison]

Hi,

ive installed the sitemap mod successfully but when i try to create the sitemap i get this :

Google Sitemap Generation v 1.3.3 07.02.2007 8:44 started

 ERROR: Google Product Sitemap Generation FAILED!
 ERROR: Google Category Sitemap Generation FAILED!
 ERROR: Google Category Sitemap Generation FAILED!
 ERROR: Google Sitemap Index Generation FAILED!

 Total Execution Time 0:1.9688
PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapproducts.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(/sitemapproducts.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapcategories.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(/sitemapcategories.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: Invalid argument supplied for foreach() in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 169 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapindex.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151 PHP Warning: fopen(/sitemapindex.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googlesitemap.php on line 151

it looks to me that the root path its grabbing is incorrect? if so, where do i change it?

thanks

[magicpants]

Sorry to add another SQL post to this thread, but I've tried a bunch of methods and it's not worked.

I had a previous version installed, and when i tried to run the googlesitemap.sql, I get this error:

Cannot insert configuration_key "" because it already exists

I ran the uninstall.sql and tried again -- same problem.

I should be able to figure this out, but no luck. This was through the Zen Cart Install SQL Patches screen. I'm using Zen Cart 1.3.6.

[a_berezin]

magicpants,
configuration_key "" already exists?
What sql you install?

[a_berezin]

aharper78 & PhillipHarrison

I add diagnostic message to googlesitemap.php - display full output file name.
Please download and test it.

[PhillipHarrison]

Google Sitemap Generation v 1.3.3 07.02.2007 8:44 started


Processing file: /sitemapproducts.xml Failed!
ERROR: Google Product Sitemap Generation FAILED!

Processing file: /sitemapcategories.xml Failed!
ERROR: Google Category Sitemap Generation FAILED!

ERROR: Google Category Sitemap Generation FAILED!

Processing file: /sitemapindex.xml Failed!
ERROR: Google Sitemap Index Generation FAILED!

Total Execution Time 0:1.6606
PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapproducts.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(/sitemapproducts.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapcategories.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(/sitemapcategories.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: Invalid argument supplied for foreach() in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 179 PHP Warning: fopen(): open_basedir restriction in effect. File(/sitemapindex.xml) is not within the allowed path(s): (C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk) in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159 PHP Warning: fopen(/sitemapindex.xml): failed to open stream: Operation not permitted in C:\webroot1\Administrator1\footprintsglasgow\footprintsglasgow.co.uk\www\googles itemap.php on line 159

looks a near identical error.....

[Woodymon]

Hi. I just installed latest version of GoogleSitemap Admin v 1.3.3 02-07-07

I observed the new feature to write Google Sitemap xml files to the web root and when I updated the feed via Tools > Google XML Sitemap I observed the four files in webroot sucessfully updated!

QUESTION: Is putting the xml files (and xsl) file into the webroot of the domain now absolutely required by Google?

I ask this as previously I had set-up two separate Google Sitemap feeds: one for the website in webroot, then an additional Google sitemap for the shop one level off webroot (/public_html/shop).

So has things now changed where does Google wants all sitemap info for the entire domain combined into the xml files placed in webroot?

If so, then after auto generating Google Sitemap xml feed with Andrew's mod (with shop info) will I then need to manually edit sitemapindex.xml to add any additional Sitemap info for the rest of my site. If so how do I go about merging these separate feeds. Or do I just name them different. e.g sitemapindex.xml (for shop) and sitemap2index.xml (for rest of the domain)?

Sorry if I sound confused. I guess I should go and read updated docs at Google.

Woody

[Woodymon]

I have ch/mod set to 777 and still the .xml sitemap files are blank, are you suppose to wait for the generation after clicking the generate sitemap? If so, how long?

Are you certain the four xml files are in your webroot (e.g. public_html) and not in your the root of your shop (e.g. /public_html/yourshop/). Andrew's mod now defaults to write to the webroot.

See admin setting in Config > Google XML Sitemap
Use root directory true

GoogleSiteMapAdmin v 1.3.3 (02-07-07) settings as they appear in Zen Cart 1.37

Below are the defaults. Adjust accordingly.

Compress XML File false
Products changefreq weekly
Category priority 0.5
Category changefreq weekly
EZPages changefreq weekly
EZPages priority 0.5
Lastmod tag format date
Products priority 0
Use Google Sitemaps Stylesheet true
Use root directory true
EZPages Header true
EZPages Sidebox true
EZPages Footer true

[magicpants]

Hi Andrew, it's just the normal googlesitemap.sql. I did it through zen cart's install sql patches. Here it is:

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, 'Use root directory', 'GOOGLE_SITEMAP_USE_ROOT_DIRECTORY', 'true', 'Use root directory for sitemap files', @configuration_group_id, 7, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),'),
(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);

[Woodymon]

Sorry to add another SQL post to this thread, but I've tried a bunch of methods and it's not worked.

I had a previous version installed, and when i tried to run the googlesitemap.sql, I get this error:

Cannot insert configuration_key "" because it already exists

I ran the uninstall.sql and tried again -- same problem.

I should be able to figure this out, but no luck. This was through the Zen Cart Install SQL Patches screen. I'm using Zen Cart 1.3.6.

I just setup a fresh new 1.37 test shop and installed latest Google Sitemap Admin 1.33 mod (fresh install) and did not observe any errors patching with googlesitemap.sql

The SQL error report should be different when patching with googlesitemap.sql vs. uninstall.sql. If/when there is an error usually you will receive more info than just the single line you offered. Can you provide the additional info?

Or better yet, have you tried patching using phpmyadmin? I have observed too many issues patching with integrated SQL Query Executor (for 1.3x shops). Anymore I just avoid patching via Tools > Install SQL Patches and instead use phpmyadmin.

Woody