Post by duivelken » Tue Feb 12, 2019 6:44 pm

Hi,

I am not a native English speaker so sorry for any mistakes :-)

I made an export of my OpenCart DB using the Export/Import Tool.

I added some new lines and changed some existing lines, and I keep getting an error message on the first added line. No error message on the changed existing lines.

Error message:

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 ''KRMK0061 - Basis rechthoek 23cm',7,'catalog/soon.jpg',1,9,0,NOW(),NOW(),NOW(),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 (110,0,'KRMK0061','','','','','56','slpkr tuin rek 1',,'KRMK0061 - Basis rechthoek 23cm',7,'catalog/soon.jpg',1,9,0,NOW(),NOW(),NOW(),0,1,1,0,0,0,0,0,'1','0','1','1');

Can you please help me?

Thx.

Kr,

Francisco

Newbie

Posts

Joined
Mon Oct 29, 2018 5:14 am

Post by ocmod.space » Thu Feb 14, 2019 2:15 am

'slpkr tuin rek 1',,'KRMK0061 - Basis rechthoek 23cm',
It seems like stock_status_id between 'slpkr tuin rek 1', and ,'KRMK0061 - Basis rechthoek 23cm' is missing

--
My OC extensions
--
What Do You Care What Other People Think?


Newbie

Posts

Joined
Wed Jan 10, 2018 9:30 pm

Who is online

Users browsing this forum: mRC and 10 guests