Web based accomodation booking system - MYSQL 5.7 to 8 upgrade query error resolution
$25-50 AUD / hour
Due a recent MySQL (5.7 to 8.0) upgrade by our hosting company, we require some major version change breaking corrections made to some existing mysql queries in our PHP pages due to this upgrade.
These changes relate to variables and expressions in SET and SELECT statements, and require someone with the specific and demonstrable knowledge of MySQL 8.0 and these changes, with the referenced error:
Warning: #1287 Setting user variables within expressions is deprecated and will be removed in a future release. Consider alternatives: 'SET variable=expression, ...', or 'SELECT expression(s) INTO variables(s)'.
We have a handful of files that will need modifying to meet the major changes and that report the above error, and to check the other PHP files containing mysql queries just for general compliance (we dont think theres any other issues however)
Project ID: #37537216
About the project
Awarded to:
Hi client, I read your job description, and I understand you are looking for a web developer to finish your project. As a Sr. full-stack Developer, I am very confident in this project. My main skills I have for this More
36 freelancers are bidding on average $36/hour for this job
Hi Good afternoon , I have read the brief details on your job listing . I see you have been looking for someone experienced with MySQL, JavaScript, HTML, PHP and Website Design. Its been 8 years since I have been worki More
Hi, I can fix the errors to be compatible with latest php and MySQL 8. I would be happy to hear from you to do it. Thanks
Hello! I understand that you require some major version change breaking corrections made to some existing mysql queries in your PHP pages due to this upgrade. Specifically, variables and expressions within SET and SE More
Hi there, I hope this message finds you well. I've carefully reviewed the challenges you're facing with the recent MySQL 5.7 to 8.0 upgrade, particularly the warning related to deprecated syntax in SET and SELECT stat More
Hello, my name is Adam Levinson and I am a top rated Plus freelancer with 15 years of experience in system administration, specifically in Linux/Windows/Apache/Nginx. I have worked on a variety of challenging tech proj More
As you may know there are a few deprecated functions in newer version for php. And also, there are multiple fundtionalities related with mysql query. So, we have to change them. I've enough experience in that. So I can More
Hello I am a skilled wordpress expert. With 8 years of experience in php, mysql, I have the knowledge and skills necessary to complete this project efficiently. I am looking forward to hearing from you. Thank you for More
Dear [Hiring Manager], I am writing to express my interest in the MySQL Upgrade Compatibility role posted on your website. With a recent MySQL (5.7 to 8.0) upgrade by your hosting company, I am eager to contribute my More
I can resolve the issue and then upgrade the mysql to 8.x. Once you contact me, we can start work further. Thanks.
Hello Angus M., I’ve checked your project ..................Web based accomodation booking system - MYSQL 5.7 to 8 upgrade query error resolution................... and really interested in this job. I can complete yo More
Dear Angus, I hope you are doing well. I understand your issues and am able to fix it since I'm very familiar with MySQL, and PHP, SQL Queries. Also I have faced similar issues for SQL Queries due to MySQL version upg More
Dear client. I am writing to express my interest in the task of making major version change breaking corrections to your existing PHP pages, specifically related to the recent upgrade from MySQL 5.7 to 8.0. With my in- More
Hello, I'm a highly skilled full stack developer with extensive experience in web development, mobile application development, e-commerce development, and AI solutions. I understand that you require some major versio More