Post by midistation » Sat Apr 22, 2017 8:17 am

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 ''58',0,'',1,2.99,0,NOW(),NOW(),NOW(),0.23,1,1,9,0,0,0,0,'1','0','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 (9,1000,'','','','','','','',,'58',0,'',1,2.99,0,NOW(),NOW(),NOW(),0.23,1,1,9,0,0,0,0,'1','0','1','1');

Newbie

Posts

Joined
Tue Apr 11, 2017 5:43 am

Post by oc-extensions » Thu Apr 27, 2017 5:35 am

Hi,

Wrong query.

Code: Select all

VALUES (9,1000,'','','','','','','',,'58'

see double comma before '58'
there should be

Code: Select all

VALUES (9,1000,'','','','','','','','','58'
Good Luck

Image | Extensions and Custom Development


User avatar
Active Member

Posts

Joined
Fri Jan 06, 2012 11:31 pm
Who is online

Users browsing this forum: No registered users and 81 guests