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');
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?
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."
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');
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');
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."
I am getting same error while importing database.
Please help
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.
Last edited by OpenCart Addons on Thu Jan 19, 2017 11:00 am, edited 1 time in total.
Reason: Moved error into code tag
Reason: Moved error into code tag
Who is online
Users browsing this forum: No registered users and 31 guests