Post by nes4less » Mon Feb 01, 2010 9:14 am

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');

Newbie

Posts

Joined
Fri Jan 29, 2010 2:46 am

Post by Miguelito » Tue Feb 02, 2010 5:33 pm

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?

The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."


Active Member

Posts

Joined
Sun Jan 10, 2010 10:11 pm

Post by nes4less » Wed Feb 03, 2010 8:34 am

I messed with it a bit more and seemed to figure things out. Thanks for the help.

Newbie

Posts

Joined
Fri Jan 29, 2010 2:46 am

Post by ozguy1 » Sat Oct 08, 2011 12:31 pm

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');

Newbie

Posts

Joined
Sat Oct 08, 2011 12:29 pm

Post by Miguelito » Wed Oct 12, 2011 8:56 pm

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?

The Finnish OpenCart Forum
"Real programmers don't document. If it was hard to write, it should be hard to understand."


Active Member

Posts

Joined
Sun Jan 10, 2010 10:11 pm

Post by mshahzad » Sun Apr 05, 2015 3:21 am

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

Newbie

Posts

Joined
Sat Apr 04, 2015 6:58 pm

Post by rmanasir » Mon Jan 16, 2017 10:37 pm

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
Last edited by OpenCart Addons on Thu Jan 19, 2017 11:00 am, edited 1 time in total.
Reason: Moved error into code tag

Newbie

Posts

Joined
Mon Jan 16, 2017 10:29 pm
Who is online

Users browsing this forum: No registered users and 8 guests