Google SitemapAdmin

[a_berezin]

Download last version 1.3.2 and load sql-patch.

[kimsonvu]

Hi,

I check my Admin->Configuration->Google Sitemap Configuration and setup all parameters but cant see anything in this box.

What happen with that box?

[kimsonvu]

Download last version 1.3.2 and load sql-patch.

Hi,When i run SQL update, i found this :
#1146 - Table 'handicra_shop.configuration_group' doesn't exist

I check phpadmin and see just have table name handicraconfiguration_group.How to change your SQL update file to use that table?

[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

[drstuey]

Hi,

I installed Google SitemapAdmin and tried to run it, but I got:

Warning: set_time_limit(): Cannot set time limit in safe mode in /home/httpd/vhosts/oscarflowermerchant.co.nz/httpdocs/shop/admin/googlesitemap.php on line 35
Google Sitemap Generation v 1.3.2 02.02.2007 15:51 started

Fatal error: Call to undefined function: zen_get_info_page() in /home/httpd/vhosts/oscarflowermerchant.co.nz/httpdocs/shop/admin/googlesitemap.php on line 332

any ideas? I think I am running 1.3.0

sorry, I tried to search the forum to see if this was covered before but I couldn't find anything and no I didn't read through 20 pages of this thread.

[a_berezin]

What Zen Cart version you really use?

[kimsonvu]

What Zen Cart version you really use?

HI,I installed Google Site map and it's work,but in admin-config-google site map i dont see anything to config!
How to fix that problem?Do you have YIM or AOL NICK?

[a_berezin]

HI,I installed Google Site map and it's work,but in admin-config-google site map i dont see anything to config!
How to fix that problem?

Load googlesitemap.sql.

Do you have YIM or AOL NICK?

Yes.

[kimsonvu]

Load googlesitemap.sql.
Yes.

When i load that file, i see this problem:

1146 Table 'handicra_shop.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;]
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.

[a_berezin]

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