Google SitemapAdmin

Woody --

Thanks for getting back to me.

Well, I re-unzipped the files & re-copied them to my site, & now all is working fine. Got a 'Google XML Sitemap' entry in both the 'Configuration' and 'Tools' menus, the .xml files seem to be generated properly, & all is right with the world.

Go figure. Probably operator error on my part somewhere. I'm just glad it's working.

For the record, I'm running Zen Cart 1.3.0.1, with (I believe) all of the current bug-fixes applied.

The mod is identified as: "// $Id: googlesitemap.php admin page,v 1.0 8/11/2005 bhakala AT pc-productions DOT net".

The set-up is Mac OS X 10.4, Apache/1.3.33 (Darwin) PHP/5.1.2 & MySQL 4.0.21 Complete by Server Logistics.

-- Larry

Where can I get a copy for 1.3?

Quote:

---

Originally Posted by rxalex

Where can I get a copy for 1.3?

---

http://zen-cart.spb.ru/zc-contributi...temapAdmin.zip

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

Use 1.3 or search in archive for updating admin/sql_path

Thanks Andrew, I will take a look. It seems kind of strange though considering that when I added the USER TRACKING mod I used the Install SQL Patches and it worked perfect. Thanks for the input and I will check it out.

Rod

Change in sql patch all \' to ''. Or use attachements.

THANKS ANDREW!! This one worked 'as is' through the SQL patch Install. I appreciate all the help!

Rod

A dummy question:

Google sitemapAdmin has generated three XMLs: sitemapcategories.xml, sitemapindex.xml, sitemapproducts.xml. Do I need to upload all three xmls to google, or just load sitemapindex.xml?

Thanks.

I get this error once starting step-1 to create the sitemap after 30 seconds:

Server Error
The following error occurred:

[code=SERVER_RESPONSE_CLOSE] The server closed the connection while reading the response. Contact your system administrator.


?