Hi,
I ran your sql code but received the following error. What went wrong? Please advise. Thanks.
1146 Table 'dealbyet_zc2.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' 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.
kbalona:
WOOOOOOOHOOOOOOO!!!!!
Yes! It's working! Apparently I hadn't uploaded the new googlefroogle.php to the store's root. (Actually, I believe what happened is that I forgot to check "overwrite old file", and I uploaded but it did not overwrite the old file).
Just make sure you upload all the new files correctly, and use this SQL code (I wonder if someone could change it in the download section?)
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_key, 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'),');
