Sql STatement

[Guest]

I am trying to use this contribute : http://www.oscommerce.com/community/contri...,options+images

 

 

The image option contrib. has an error in the sql file.

 

Here is the sql file:

 

ALTER TABLE `products_options_values` ADD `products_options_values_thumbnail` VARCHAR(60) NOT NULL ;

 

INSERT INTO configuration_group VALUES (735, 'Options as Images', 'Configuration for the Options as Images Function', 20, 1);

 

INSERT INTO configuration VALUES ('', 'Use Images for Product Options?', 'OPTIONS_AS_IMAGES_ENABLED', 'true', 'Do you wish to enable images for options?', 735, 1, '2003-08-18 22:19:45', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

INSERT INTO configuration VALUES ('', 'Maximum number of images per row', 'OPTIONS_IMAGES_NUMBER_PER_ROW', '2', 'Enter the maximum number of images shown per row', 735, 2, '2003-08-20 12:58:16', '0000-00-00 00:00:00', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Options as Images - Image Width', 'OPTIONS_IMAGES_WIDTH', '80', 'Set width of option value images', 735, 3, '2003-08-20 12:55:16', '0000-00-00 00:00:00', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Options as Images - Image Height', 'OPTIONS_IMAGES_HEIGHT', '100', 'Options Images Height', 735, 4, '2003-08-20 12:55:22', '0000-00-00 00:00:00', NULL, NULL);

INSERT INTO configuration VALUES ('', 'Click to Enlarge Function', 'OPTIONS_IMAGES_CLICK_ENLARGE', 'true', 'Do you wish to enable the Click to Enlarge Function?', 735, 5, '2003-08-21 12:59:58', '0000-00-00 00:00:00', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

 

ALTER TABLE `products_options` ADD `products_options_images_enabled` VARCHAR(5) DEFAULT 'false' NOT NULL ;

 

 

 

 

 

 

 

This is the error:

WHERE CONCAT_WS( "-", 735, 'Options as Images', 'Configuration for the Options as Images Function', 20, 1 ) = "735"

ORDER BY 735 , 'Options as Images', 'Configuration for the Options as Images Function', 20, 1

 

MySQL said:

 

#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 'WHERE CONCAT_WS("-", 735, 'Options as Images', 'Configuration for the Options ' at line 3

 

 

Does anyone know how to fix this?