Notice: Error: You have an error in your SQL syntax
I made some small corrections in the excel import export spreadsheet and when I tried to import it I had this error.
Notice: Error: 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 'Mascara Black 9,5 ml.jpg',1,70,0,'2014-04-18 04:51:09','2015-06-27 14:33:06','20' at line 1
Error No: 1064
INSERT INTO`oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`, `stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`, `date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`, `width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`)
VALUES (1006,2,'','','','','','','',5,'MAYBL05301 ',38,'data/COSMETICS/Maybelline The Colossal Go Extreme Volum' Mascara Black 9,5 ml.jpg',1,70,0,'2014-04-18 04:51:09','2015-06-27 14:33:06','2014-04-18',0.024,1,1,9,17,0,0,0,'1','1','1','1'); in /home/beauty87/public_html/system/database/mysql.php on line 50
Any help would be greatly appreciated.
Arkenseal
Notice: Error: 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 'Mascara Black 9,5 ml.jpg',1,70,0,'2014-04-18 04:51:09','2015-06-27 14:33:06','20' at line 1
Error No: 1064
INSERT INTO`oc_product` (`product_id`,`quantity`,`sku`,`upc`,`ean`,`jan`,`isbn`,`mpn`,`location`, `stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`points`,`date_added`, `date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`, `width`,`height`,`length_class_id`,`sort_order`,`subtract`,`minimum`)
VALUES (1006,2,'','','','','','','',5,'MAYBL05301 ',38,'data/COSMETICS/Maybelline The Colossal Go Extreme Volum' Mascara Black 9,5 ml.jpg',1,70,0,'2014-04-18 04:51:09','2015-06-27 14:33:06','2014-04-18',0.024,1,1,9,17,0,0,0,'1','1','1','1'); in /home/beauty87/public_html/system/database/mysql.php on line 50
Any help would be greatly appreciated.
Arkenseal
