Google SitemapAdmin

[a_berezin]

Hi magicpants,
You can see, that in the normal googlesitemap.sql is not present any record with configuration_key "".

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

[kimsonvu]

Hi magicpants,
You can see, that in the normal googlesitemap.sql is not present any record with configuration_key "".

Do you have new update for SQL Path?

[a_berezin]

What do you mean?

[magicpants]

Thanks Woodymon and a_berezin!

I used phpmyadmin and it worked fine. Guess I could have tried that from the start -- but I hadn't noticed any difference between the two methods in the past.

kimsonvu, i'm with Andrew: what's this new update to SQL path? I guess I don't have it, I haven't heard about it before.

[Woodymon]

kimsonvu, i'm with Andrew: what's this new update to SQL path? I guess I don't have it, I haven't heard about it before.

I suspect kimsonvu may have been confused by a previous post, declaring an issue in the fresh mod install sql file, when there was not one. The issue was in the updater sql file and the simple correction has been posted to this thread.

And rather than "path" I think he meant "patch"

[a_berezin]

looks a near identical error.....
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!

Ok. As I can see, this is a problem with $_SERVER['DOCUMENT_ROOT']. So, I refuse parameter GOOGLE_SITEMAP_USE_ROOT_DIRECTORY and add new parameter - GOOGLE_SITEMAP_XML_FS_DIRECTORY.

Please, download and test it.

[Crzipilot]

Quick question. I downloaded the Sitemap package, and I see the googlesitemap.sql update. But then there is a 1.3.3 and a 1.3.2 sql patch, are you supposed to upload all three...or just one or just 2 or???

[Woodymon]

Quick question. I downloaded the Sitemap package, and I see the googlesitemap.sql update. But then there is a 1.3.3 and a 1.3.2 sql patch, are you supposed to upload all three...or just one or just 2 or???

Current version is 1.3.3. Are you upgrading the mod from a previous version or is it a fresh install? If fresh install only need to apply googlesitemap.sql

If upgrading the mod, then the sql patch(es) you need to apply depends on which version you are upgrading from.

Or if not sure just run uninstall.sql. Then run googlesitemap.sql

It is very good that Andrew supports his mods with sql updaters and an uninstaller.

Woody

[PhillipHarrison]

anyone have any ideas on my problem?

[Woodymon]

anyone have any ideas on my problem?

Did you download Andrew's new version he kindly updated just for you (see just a few posts above) Please download, test and report back.