K
K
Karin Park2020-04-21 11:14:17
MySQL
Karin Park, 2020-04-21 11:14:17

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

2 answer(s)
L
Leonid, 2020-04-21
@Karin_Park

apparently stock_status_id is not transmitted there - there are two commas in a row

S
Sergey Dobrovsky, 2020-05-07
@servres

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 question

Ask a Question

731 491 924 answers to any question