Google SitemapAdmin

[hipgirl]

Hello,

I got the similar problem (sql error). Here is what I did:

1. copy all files to my store directory. I installed zen cart to .../store folder. I also changed the default admin name to my own name (say, abc). So I copied all files except folder admin to .../store. And then copied all the files under admin to .../store/abc. At this point, google xml sitemap showed under 'tool' menu.

2. use 'tool'--install sql patch-- upload to run googlesitemap.sql. I got error in last statement but when I checked the database table, I saw that the first steps ran successfully. The configuration_group_id is 41 (in configuration_gourp table).

3. Then I run the last statement manually using phpsqladmin. 2 things need to be changed: 1. the table name configuration need to be zen_configuration. 2. wherever you see @configuration_group_id, change it to 41 (the number you got in table configuration_group. yours maybe different). Below is my final version (at the end of the message). Then I just copy and paste it to phpsqladmin and run it. At this point, the menu item showed under 'configuration' menu. Then I was able to create sitemap successfully: http://hipgirlclips.com/store/sitemapproducts.xml

The problem is that google told me it must be in highest level, not under ../store folder. I tried to move, copy the files to the upper level but seems the format changed. I think maybe it's using ASCII instead of Binary mode to copy the file. Any way, I didn't get a chance to search for it yet. Could anybody help? Thanks.

INSERT INTO zen_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
(NULL, 'Compress XML File', 'GOOGLE_SITEMAP_COMPRESS', 'false', 'Compress Google XML Sitemap file', 41, 3, NULL, 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.', 41, 3, NULL, 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.', 41, 3, NULL, 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)', 41, 3, NULL, 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.', 41, 3, NULL, NOW(), NULL, NULL),
(NULL, '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.', 41, 3, NULL, NOW(), NULL, NULL);

Michelle

www.hipgirlclips.com