OpenCart Community

OpenCart Community Forum - Discuss shopping cart and e-commerce solutions.
https://forum.opencart.com/

Import Export Error 1064

https://forum.opencart.com/viewtopic.php?t=10222

Page 1 of 1

Import Export Error 1064

Posted: Mon Feb 01, 2010 9:14 am
by nes4less
I am trying to create new items by filling them into the excel import export sheet. I keep getting this message, and I am unsure if I am using this wrong. What I would like to do, is completely create new items by punching values into the excel sheet. Can this even be done. If so, what do I fill in for Product ID

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')' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`location`,`stock_status_id`,`model`,`manufacturer_id`,`image`,`shipping`,`price`,`date_added`,`date_modified`,`date_available`,`weight`,`weight_class_id`,`status`,`tax_class_id`,`viewed`,`length`,`width`,`height`,`measurement_class_id`) VALUES (49,1,'0','Gameboy Storage',7,'Gameboy',1,'',1,7,'2010-01-28 15:27:50','2010-01-28 15:29:19','2010-01-28',2,4,1,0,0,,,,'0');

Re: Import Export Error 1064

Posted: Tue Feb 02, 2010 5:33 pm
by Miguelito
Could u please post that INSERT INTO 'product' list so we could see the whole list of fields, thanks.

Have you checked that the number of fields listed in INSERT INTO clause matches the number of fields/data in VALUES clause?

Re: Import Export Error 1064

Posted: Wed Feb 03, 2010 8:34 am
by nes4less
I messed with it a bit more and seemed to figure things out. Thanks for the help.

Re: Import Export Error 1064

Posted: Sat Oct 08, 2011 12:31 pm
by ozguy1
HI Migullito

I am having the same problem, how did you fix it. My error is:

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 '' at line 1
Error No: 1064
INSERT INTO `product` (`product_id`,`quantity`,`sku`,`upc`,`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 (586,1,'','','',6,'A0686',0,'',1,#VALUE!,0,'2011-10-08 10:10:30','2011-10-08 10:21:30','2011-10-07',0,1,1,9,0,0,0,0,'1','1','0','1');

Re: Import Export Error 1064

Posted: Wed Oct 12, 2011 8:56 pm
by Miguelito
Well at first sight it seems that there's an error in that INSERT clause because shipping ends without apostrophe. Also there seems to be value '#VALUE!' which I think should be something else, eh?

Re: Import Export Error 1064

Posted: Sun Apr 05, 2015 3:21 am
by mshahzad
products-2015-04-051[color=#BF0000]i have facing same problum please solve mention below error [/color]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 ''MD101ZA',8,'',1,129800,0,NOW(),NOW(),NOW(),0,1,1,9,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 (50,0,'','','','','','','',,'MD101ZA',8,'',1,129800,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/windsvas/public_html/onlinestore/system/library/db/mysqli.php on line 41Notice: 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 ''ME864ZA/A',8,'',1,132000,0,NOW(),NOW(),NOW(),0,1,1,9,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 (51,0,'','','','','','','',,'ME864ZA/A',8,'',1,132000,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/windsvas/public_html/onlinestore/system/library/db/mysqli.php on line 41Notice: 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 ''ME866ZA/A',8,'',1,190300,0,NOW(),NOW(),NOW(),0,1,1,9,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 (52,0,'','','','','','','',,'ME866ZA/A',8,'',1,190300,0,NOW(),NOW(),NOW(),0,1,1,9,0,0,0,0,'1','1','1','1'); in /home/windsvas/public_html/onlinestore/system/library/db/mysqli.php on line 41 [color=#FF0040] further when i upload the file following error [/color] 2015-04-04 18:44:08 - Export/Import: Missing product_ids in worksheet 'Products'! Please suggest further i have add catageroies succesfully but when i upload the product file following error occured [attachment=0]categories-2015-04-05.xlsx
products-2015-04-051 .xlsx

Re: Import Export Error 1064

Posted: Mon Jan 16, 2017 10:37 pm
by rmanasir
I am getting same error while importing database.

Code: Select all

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 ''GR01',11,'catalog/utilities/IMG_8336.JPG',1,250,0,NOW(),NOW(),NOW(),0,0,0,0,0,0' 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 (1045,1,'','','','','','','',,'GR01',11,'catalog/utilities/IMG_8336.JPG',1,250,0,NOW(),NOW(),NOW(),0,0,0,0,0,0,0,0,'0','1','1','1');
See also 'System > Error Logs' for more details.
Please help
All times are UTC+08:00
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/