Google SitemapAdmin

[a_berezin]

I can not reproduce this error and so I can't explain this.
What version of Zen Cart you use?

[kimsonvu]

I can not reproduce this error and so I can't explain this.
What version of Zen Cart you use?

I use 1.36 Zencart

[a_berezin]

Sorry, I can't help you

[a_berezin]

Can you test this sql:

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

[a_berezin]

v 1.3.3 07.02.2007 8:44
1. Code clean and optimization;
2. Don't use set_time_limit() in SAFE MODE;
3. Add sitemapezpages.xml generation;

[aharper78]

v 1.3.3 07.02.2007 8:44
1. Code clean and optimization;
2. Don't use set_time_limit() in SAFE MODE;
3. Add sitemapezpages.xml generation;

I have tried installing the SQL patch but it's not working.. Heres the error I get

 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'true', 'false'),'), (NULL, 'Products changefreq', 'GOOGLE_SITEM
in:
[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:
date - Complete date: YYYY-MM-DD (eg 1997-07-16)
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);]
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.

Is there somthing wromg with the code or somthing I did?

[a_berezin]

How you install SQL-Path?

[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.