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.
20 freelancers are bidding on average €135 for this job
Hi i can make work Joomla import script i am expert at PHP , Joomla , Software Architecture , MySQL So send me Private message at PMB so we can discuss more about it Thanks
Hello I have read your project and I can create in your budget with wonderful User Interface and delivery to be on the time with full Technical support on 24*7.