Google SitemapAdmin

[kbalona]

Ok, I think it's something with the SQL patch. I re-uploaded everything and still noting in Tools. So I tried re-patching the database, and get this message:
1146 Table 'edgeande_zc2.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.

Any ideas? Thanks.

[kbalona]

Can anyone help? I think it's trying to enter it in 'edgeande_zc2.configuration_group' which doesn't exist, but it should be entering it in 'zen_configuration_group' which does exist, but I don't know how to point it there?

[Alex Clarke]

Can you post the SQL statement(s) you're trying to run here?

[kbalona]

Yes. It's what I found in the SitemapAdmin folder, googlesitemap.sql

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google XML Sitemap' LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;

INSERT INTO configuration_group (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, 'Google XML Sitemap', 'Google XML Sitemap Configuration', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;

INSERT INTO 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', @configuration_group_id, 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.', @configuration_group_id, 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.', @configuration_group_id, 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)', @configuration_group_id, 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.', @configuration_group_id, 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.', @configuration_group_id, 3, NULL, NOW(), NULL, NULL);

[Alex Clarke]

How are you executing this? phpMyAdmin or Zen Cart?

[kbalona]

I tried it in both of them. They both give the same message. btw, I'm using zen 1.3.7.

[kbalona]

I wanted this to work

[Pixxi]

What table prefix do you have set in your configure files?

[kbalona]

The prefix is
zen_
in both configure files.

[Pixxi]

If you run the SQL through admin->tools->install SQL patches it should add the 'zen_' prefix automatically to the table names in the SQL.

If it doesn't, then you can manually add the 'zen_' prefix to the table names in the SQL and try running it through phpMyAdmin.