Google SitemapAdmin

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

[ngr]

Hello, when i create the sitemapproducts.xml file, only the english products are added (product_info&products_id=199&language=en), i have my shop in spanish and in the future i´ll translate in english but for now i need that sitemapproducts.xml only show language=es and not language=en in the product link.
Is this possible?
thanks

[a_berezin]

Sitemap generate links to products and categories with all installed languages. Links to Default language does not have language parameter.

[aharper78]

ok I have this mod installed, but where is the sitemap generated? I was assuming the sitemap XML files in the root directory is what would be populated but they are completly blank. I have run the program and it says sitemap generation started but I dont see any results. Have I done something wrong?

[a_berezin]

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