Re: Google SitemapAdmin
Hello!
I am running Zen ver 1.2.7 and trying to install the Google SitemapAdmin but keep coming up with an error when I try to install the SQL patch.
I have uploaded all the files and changed all the .xml files to 777, the link for Google XML Sitemap shows on my menu but as I said when I try to install the patch 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'),')' at line 1
I have not edited/changed anything, and here is what is in the googlesitemap.sql file I have:
SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Google XML Sitemap';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
insert into configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) values ('', 'Google XML Sitemap', 'Google XML Sitemap Configuration', '1', '1');
SET @t1=last_insert_id();
UPDATE configuration_group SET sort_order = @t1 WHERE configuration_group_id = @t1;
insert into configuration values ('', 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'true\', \'false\'),');
insert into configuration values ('', 'Products changefreq', 'GOOGLE_SITEMAP_PROD_CHANGE_FREQ', 'weekly', 'How frequently the Product pages page is likely to change.', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),');
insert into configuration values ('', 'Category changefreq', 'GOOGLE_SITEMAP_CAT_CHANGE_FREQ', 'weekly', 'How frequently the Category pages page is likely to change.', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'always\', \'hourly\', \'daily\', \'weekly\', \'monthly\', \'yearly\', \'never\'),');
insert into configuration values ('', '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)', @t1, 3, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'date\', \'full\'),');
insert into configuration values ('', '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.', @t1, 3, NULL, NOW(), NULL, NULL);
insert into configuration values ('', 'Products priority', 'GOOGLE_SITEMAP_PROD_CHANGE_PRIOR', '0.5', 'The default priority of the products URL. Valid values range from 0.0 to 1.0.', @t1, 3, NULL, NOW(), NULL, NULL);
Thanks,
Rod
