We are running a script that converts a CSV file to our Joomla webshop (mijoshop). The script imports new products from the CSV and updates the stock on existing products. Since an update on the server (probably SQL related), the script stopped working.
We get a error when running the script. It says:
Error: 1064 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,'2020-03-12 14:55:35',NOW(),'2020-03-12',0,1,1,0,0,0,0,0,'1','0','1','1')' at line 1 SQL=INSERT INTO #__mijoshop_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 (30626,0,'110.500.684','','','','','','',5,'SRB2657 Janna',98,'',1,,0,'2020-03-12 14:55:35',NOW(),'2020-03-12',0,1,1,0,0,0,0,0,'1','0','1','1');
It only related to this particular table, alle other tables are updated without any problems.
We need this fixed asap because we can't update our webshop collection at the moment.