I am running 10.3.25-MariaDB, importing categories work perfect but when trying to import products I get an error:
Code: Select all
2020-12-04 15:17:43 - PHP Notice: Undefined index: Gigabyte in /home/ejraeu/domains/ejura.eu/public_html/admin/model/extension/export_import.php on line 1037
2020-12-04 15:17:43 - 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 ''',1,250,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','0','1','1')' at line 1<br />Error No: 1064<br />INSERT INTO `qfrl_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 (102,5,'232683','','','','','manoserija125','SAN1',5,'GeForce GTX 1050 TI',,'',1,250,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','0','1','1'); in /home/ejraeu/domains/ejura.eu/public_html/system/library/db/mysqli.php on line 40