Export / import module by JNeuhoff
Posted: Thu Oct 23, 2014 12:06 am
I'm running a clean OC v2.0 install with V2.17 of the export/import module.
seem to be unable to import my file. (tried to import an edited exported file using this tool)
I have used the previous version all perfect and there doesn't seem to be a problem generally with the OC v2 one according to recent forum posts..
So i'm thinking its something i'm doing wrong?
here's some of the error code when uploading :
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 ''N/a',12,'',1,0.84,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (1,0,'0.5M-EE','','','','','','',,'N/a',12,'',1,0.84,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.72,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (2,0,'0.5M-ESC','','','','','','',,'N/a',12,'',1,0.72,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.8,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (3,70,'0.5M-ESS','','','','','','',,'N/a',12,'',1,0.8,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.2,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (4,483,'10-16HPC','','','','','','',,'N/a',12,'',1,0.2,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,1,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
i've done a few checks cross referencing to other similar issues but no fix.. I have the installer patch installed as well to fix the installing issue.. install..
Thanks!
seem to be unable to import my file. (tried to import an edited exported file using this tool)
I have used the previous version all perfect and there doesn't seem to be a problem generally with the OC v2 one according to recent forum posts..
So i'm thinking its something i'm doing wrong?
here's some of the error code when uploading :
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 ''N/a',12,'',1,0.84,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (1,0,'0.5M-EE','','','','','','',,'N/a',12,'',1,0.84,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.72,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (2,0,'0.5M-ESC','','','','','','',,'N/a',12,'',1,0.72,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.8,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (3,70,'0.5M-ESS','','','','','','',,'N/a',12,'',1,0.8,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,0.2,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
Error No: 1064
INSERT INTO `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 (4,483,'10-16HPC','','','','','','',,'N/a',12,'',1,0.2,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1'); in /home/ttadmin1/public_html/system/library/db/mysqli.php on line 40Notice: 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 ''N/a',12,'',1,1,0,NOW(),NOW(),NOW(),0,0,1,9,0,0,0,0,'1','0','1','1')' at line 1
i've done a few checks cross referencing to other similar issues but no fix.. I have the installer patch installed as well to fix the installing issue.. install..

Thanks!