Web based accomodation booking system - MYSQL 5.7 to 8 upgrade query error resolution

Lengkap Disiarkan 5 bulan lepas Dibayar semasa penghantaran
Lengkap

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)

HTML JavaScript MySQL PHP Reka Bentuk Laman Web

ID Projek: #37537216

Tentang projek

36 cadangan Projek jarak jauh Aktif 5 bulan lepas

Dianugerahkan kepada:

mattfranc25

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 Lagi

$35 AUD / jam
(15 Ulasan)
5.3

36 pekerja bebas membida secara purata $36/jam untuk pekerjaan ini

AwaisChaudhry

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 Lagi

$38 AUD / jam
(122 Ulasan)
8.6
sweetykantha04

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

$25 AUD / jam
(230 Ulasan)
7.8
managersingh

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 Lagi

$25 AUD / jam
(286 Ulasan)
8.2
shelinakhoja2

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 Lagi

$30 AUD / jam
(79 Ulasan)
7.8
Max01

Hi, Greetings! I am a good fit for this project due to my strong skills and experience to work on upgrading task of older version to new version. ******Please send me a message so that we can discuss more details.*** Lagi

$25 AUD / jam
(471 Ulasan)
7.7
techcity

Hello, We are open source customization experts and are available to start fixing your Mysql issues that arise as a result of the upgrade by hosting provider. As its a handful of files and seems a big project where fi Lagi

$60 AUD / jam
(55 Ulasan)
7.4
AITSoft

Hello, I hope you are doing great. I have good experience with doing similar jobs. You can check my portfolio here:https://www.freelancer.com/u/AITSoft I can do this job because have great experience with MySQL, HTML, Lagi

$38 AUD / jam
(20 Ulasan)
6.9
ClearPoint

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 Lagi

$50 AUD / jam
(68 Ulasan)
6.3
ankurbora7

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 Lagi

$50 AUD / jam
(21 Ulasan)
5.6
kevinbowmanIce

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 Lagi

$38 AUD / jam
(15 Ulasan)
5.4
soramaru

Hello, I am a well-qualified full stack developer with extensive experience in Android, iPad, iPhone and mobile app development. He is highly proficient in Objective C and has extensive knowledge of no code app develop Lagi

$30 AUD / jam
(3 Ulasan)
4.2
focusprodev

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 Lagi

$35 AUD / jam
(2 Ulasan)
3.1
fionawongup

I can resolve the issue and then upgrade the mysql to 8.x. Once you contact me, we can start work further. Thanks.

$38 AUD / jam
(2 Ulasan)
2.5
vika4despacito

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 Lagi

$38 AUD / jam
(1 Ulasan)
2.4
alexandrsdombrov

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 Lagi

$45 AUD / jam
(1 Ulasan)
2.0
Fahembaig

I'm Faheem, an eCommerce website expert with specialized knowledge and skills in the field of electronic commerce. I have extensive experience in web development, UX and UI design, product listings and catalog manageme Lagi

$38 AUD / jam
(0 Ulasan)
0.0
lovemoana

Hello, I am happy to bid! Thank you for the job posting and I am very interested in your project. With extensive experience in PHP and MySQL, I understand exactly what you want and am confident that I can handle this p Lagi

$40 AUD / jam
(0 Ulasan)
0.0
nomenstone

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- Lagi

$38 AUD / jam
(0 Ulasan)
0.0
mjanithbandara

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 Lagi

$28 AUD / jam
(0 Ulasan)
0.0
ASIYA6404

Hi, how are you? I can fix your sql error easily. Please message me. Thanks.

$38 AUD / jam
(0 Ulasan)
0.0