I have a problem. I'm trying to do the DB upgrade via PHPMyAdmin. But I get this error message:
SQL query: Documentation
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\'),'
);
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' configuration_value, configuration_description, configuration_group_id, sort_or' at line 1
Here's the mysql I'm trying to execute:
DELETE FROM zen_configuration WHERE configuration_key='GOOGLE_FROOGLE_MANUFACTURER';
DELETE FROM zen_configuration WHERE configuration_key='GOOGLE_FROOGLE_PRODUCT_TYPE_SHOW';
UPDATE zen_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 zen_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\'),');
