Completed

Joomla import script stopped working after SQL update

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.

Skills: PHP, Joomla, MySQL, Software Architecture

See more: content joomla import sql wordpress, joomla import script sobi2, need script lets connect sql server update data, myspace friend script stopped working, build bcp import script sql server 2000, joomla import sql mysql, flash sql joomla login script, import script xls sql server, joomla sql update php, php pagerank script stopped working, joomla import sql articles, display sql joomla table script, sql xml import script, sql update script, joomla csv import script, sql update script excel, joomla paypal stopped working, sql update script append number, create sql update script from excel

About the Employer:
( 9 reviews ) Dongen, Netherlands

Project ID: #24378751

Awarded to:

icreatewebtech

Hello employer, I am professional Joomla developer and Designer from India. I am playing with Joomla from last 8 years. I would love to start your job for you. Can we discuss? Work with me I am sure you will get 100 More

€120 EUR in 2 days
(192 Reviews)
7.2

20 freelancers are bidding on average €135 for this job

rinsadsl

Hello Good Day I know what the issue is and I can fix it immediately for you. Looking forward to working with you. Thanks & Regards Rinsad

€200 EUR in 1 day
(1127 Reviews)
8.9
TakeReal

Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you as an experienced programmer to fix Joomla import script, fix issues related to MySQL syntax. Can be fixed today. 2000+ su More

€100 EUR in 1 day
(1888 Reviews)
8.2
gopalvora

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

€129 EUR in 7 days
(537 Reviews)
8.4
dbuglab

Hi, I'm an elegant professional and expert Joomla website developer and I have worked thousands of hours on a lot of different projects in many different languages with all kinds of clients. I can surely help you to i More

€129 EUR in 7 days
(204 Reviews)
7.6
gursukh

Right now I can help you with joomla import script. I read through the job details extremely carefully and I am confident I can exceed your expectations. Individual no timing issue. I have long 6 year experience with r More

€111 EUR in 1 day
(278 Reviews)
7.0
topworkerbd

Need to fix import module to import product?............... I am ready to solve the issue Thanks Suman

€50 EUR in 1 day
(84 Reviews)
5.5
squaridroid

"Hello Sir, This is my Freelancer Profile : https://www.freelancer.com/squaridroid => I HAVE READ YOUR PROJECT DETAILS AND AS PER THAT YOU WANT TO RESOLVE THE EXISTING JOOMLA WEBSITE ISSUE. => I HAVE 15+ TEAM MEMBERS More

€125 EUR in 2 days
(15 Reviews)
5.2
santoshm143

Hi there, I am ready to fix Joomla import script stopped working after SQL update Already delivered many quality Joomla website and have the ability to resolve the complex issue on quick note. Joomla- https://www.w More

€200 EUR in 7 days
(50 Reviews)
6.2
dev152

Hello!!, I will solve asap your website errors according to your needs and under your budget . I will provide you very high-quality work. if you want to check my technical skills so please open my profile after that More

€220 EUR in 5 days
(37 Reviews)
5.1
kaizensoftvn

Hello. What is your website ? i'm expert in Joomla, so i can help you on this task. I have 5 years of web development experience, so I can help you on this project. My skill focus on Joomla, MySQL. Please contact to me More

€111 EUR in 1 day
(1 Review)
3.9
hardeepkumar01

yes after go through your job details I assure to you that i am fix the error in your website script that converts a CSV file to our Joomla webshop (mijoshop) as per your requirements using my JOOMLA development skills More

€250 EUR in 7 days
(12 Reviews)
4.0
artemzlobin900

Hello! I read your description carefully. I've always done my project as the fastest and highest quality. I think your project is best for me. The reason is that I am a Joomla development expert. If you want to check m More

€150 EUR in 3 days
(9 Reviews)
3.9
Phonesynoan

How are you? I have read your description carefully. I am a professional web developer and I have full experience in joomla. I will do my best for you. I am a honest freelancer and I think actions speak louder than wor More

€100 EUR in 1 day
(3 Reviews)
2.5
inetsoftware01

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.

€129 EUR in 6 days
(0 Reviews)
0.0
anayapallavi

It will be done. Hello, After reviewing the detail carefully i understood that you need joomla expert and i think I am the perfect person for this job . I have a strong team having experience of more than 5 years. I More

€100 EUR in 4 days
(0 Reviews)
0.0
expertsol21

Hi, "I have gone through your description. Please ping me in person. I can help you to complete all tasks. I and my team have hands-on experience in this field. We have already done similar types of [login to view URL] w More

€129 EUR in 7 days
(0 Reviews)
0.0
Arsath1994

hi i have read your requirement i have a team of experience website and app developers. contact me we will discuss thank you

€110 EUR in 6 days
(0 Reviews)
0.0
webdev9202204

⭐Wow ⭐,Joomla and SQL expert here! I have read your description carefully and very interested in your project. I am sure I can give you perfect results on time and I can keep good communication with you every day, incl More

€90 EUR in 2 days
(0 Reviews)
0.0
€143 EUR in 10 days
(0 Reviews)
0.0