jennki Posted December 31, 2005 Share Posted December 31, 2005 Hi, I've added "Extra Image" contribution in my oscommerce, after finishing the installation process, I cannot run the "Extra images", I got the following error message: Extra Product Images 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 '-16, 16' at line 1 The SQL syntax is as below: DROP TABLE IF EXISTS products_extra_images; CREATE TABLE products_extra_images ( products_extra_images_id int(11) NOT NULL auto_increment, products_id int(11) default NULL, products_extra_image varchar(64) default NULL, KEY products_extra_images_id (products_extra_images_id) ) TYPE=MyISAM; INSERT INTO configuration VALUES ('', 'Display Extra images (on products_info)', 'DISPLAY_EXTRA_IMAGES', 'true', 'Display Extra images', 1, 87, '2005-11-17 17:20:36', '2005-10-20 17:40:05', '', 'tep_cfg_select_option(array(\'false\', \'true\'),'); Could anyone tell me what I've got wrong? Thanks in advance. Link to comment Share on other sites More sharing options...
jennki Posted January 4, 2006 Author Share Posted January 4, 2006 Could anyone give me some advise? Pls. Link to comment Share on other sites More sharing options...
jennki Posted January 4, 2006 Author Share Posted January 4, 2006 SQL Syntax error solved, pls. check the following link: http://www.oscommerce.com/forums/index.php?s=&...ndpost&p=697026 Link to comment Share on other sites More sharing options...
Guest Posted January 4, 2006 Share Posted January 4, 2006 BTW that bug is fixed in the most recent osCommerce download from oscommerce.com. -jared Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.