Woodymon:
Did anyone notice the Feb 15 2007 posting of a "Google Froogle Feeder 1.33a" mod in Zen cart downloads area (uploaded by Allan Aoyama)? I did not observe a release announcement in this thread on the Contributions forum. Apparently just includes a SQL typo fix for the last version Andrew released.
I just did a compare of 1.33 vs. 1.33a and only diff was the following change in update_1_3_3.sql
Removed an extra comma and a space from the last INSERT statement. But also you you can observe the line ending semi-colon was moved from the end of the same statement to the very beginning. This is incorrect!
Previous version SQL (1.33): update_1_3_3.sql.bak
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_MANUFACTURER';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW';
UPDATE configuration SET configuration_description='Choose your product type' WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE';
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;
INSERT INTO configuration (configuration_id, configuration_title, , configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your Product\'s Condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),');
Updated SQL (1.33a) update_1_3_3.sql
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_MANUFACTURER';
DELETE FROM configuration WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW';
UPDATE configuration SET configuration_description='Choose your product type' WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE';
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;
;INSERT INTO configuration (configuration_id, configuration_title, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES (NULL, 'Condition', 'GOOGLE_FROOGLE_CONDITION', 'new', 'Choose your Product\'s Condition', @configuration_group_id, 12, NOW(), NULL, 'zen_cfg_select_option(array(\'new\', \'used\', \'refurbished\'),')
I have not run this updated patch so not sure if the moved semi-colon would have any negative effect on processing the SQL patch.
Note that this sql patch file is for upgraders only. If you're installing the mod "fresh" then only need to run googlefroogle.sql.
To bypass the upgrade patch issue altogether I would recommend that upgraders just run uninstall.sql and then run googlefroogle.sql.
(Of course do this after documenting your mod settings and after backing up your database).
Woody
