Post by fattosmatto » Thu Oct 18, 2018 5:46 pm

Hi all, I'm Daniele and I'm from Italy. (sorry for my bad Inglish )
I have a big problem when I try to import XLXS products table to opencart 3.0

This is the error,

2018-10-18 9:33:32 - PHP Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Model name',0,'',1,0,0,'0000-00-00 00:00:00','2018-05-10 21:46:19','0000-00-00'' at line 1<br />Error No: 1064<br />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 (50,0,'','','','','','','',,'Model name',0,'',1,0,0,'0000-00-00 00:00:00','2018-05-10 21:46:19','0000-00-00',0,1,0,0,0,0,0,0,'1','true','0','1'); in C:\xampp\htdocs\mondosmoke\system\library\db\mysqli.php on line 40

Now I don't know what I can do, I saw many people have same problems because MYSQL server is different. But I don't know where I have to edit and what I have to edit for solve this problem.


Hope in your help and best regards

Newbie

Posts

Joined
Mon Oct 15, 2018 10:26 pm

Post by fattosmatto » Thu Oct 18, 2018 10:52 pm

I solved the problem, I have make some mistake formatting my xlxs table. :laugh:

Newbie

Posts

Joined
Mon Oct 15, 2018 10:26 pm
Who is online

Users browsing this forum: No registered users and 5 guests