Answer the question
In order to leave comments, you need to log in
Error while importing products into OpenCart ( error in your SQL syntax )?
Hello. I'm trying to upload products in OpenCart 3, when importing an XLS file, an error occurs.
I'm guessing it has something to do with the quotes. If yes, how can I edit it in openoffice calc? (looked in the settings, didn't find it) or in any other program
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 '' ',0,'',1,0.00,0,NOW(),NOW(),NOW(),0,1,1, 0,0,0,0,0,'1','0','1','1')' 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 (51,0,'','','','','' ,'','',,' ',0,'',1,0.00,0,NOW(),NOW(),NOW(),0,1,1,0,0,0,0,0, '1','0','1','1');
Answer the question
In order to leave comments, you need to log in
apparently stock_status_id is not transmitted there - there are two commas in a row
And I have such a problem
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 '=Q2,NOW(),NOW(),'2020-04-16',0,2,1,0,0,0,0 ,0,'1','1','1','1')' 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 (180001,1000,'UT000005084','','','','4607091440409','','',7,'
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question