Completed

Fix PHP & MySQL code

We've encountered issues with old PHP code and MySQL follwing a a server move - some scripts are no longer working. Previous version of MySQL was 5.1.69; new is 5.7.34. Techs have tried numerous fixes including disabling strict_mode but have not restored functionality .

Initially the error was: "Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '******.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"

After some changes we are now getting: "ERROR 1064 (42000) at line 93: 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 'STATS_PERSISTENT=0' at line 9".

I need someone with strong PHP and MySQL understanding and experience to get us back up and running.

***the project is for an adult website - please do not bid if that is an issue

Thank you.

Skills: PHP, MySQL, SQL

See more: php mysql code bid, create appointment using php mysql code, php mysql code multiple choice questions answers, php mysql code mobile verification sent sms, read data ticker php mysql code, gift certificate php mysql code, complete php mysql code, load specific web page php mysql code, check availability bookings php mysql code, php mysql code image day, image sharing php mysql code, upload images share users php mysql code, php mysql code export data excell, php mysql code creator, jobboard php mysql code, local business crawler spider php mysql code, php mysql code calculators, php mysql code invoice, we ve encountered an unexpected error please try again error code 3005

About the Employer:
( 11 reviews ) Perth, Australia

Project ID: #30126602

Awarded to:

oliviainfotech

Hi greetings of the day I am a Experienced Full Stack Developer based out in Chennai,India. I can fix ur php and mysql issue. I am Ready to start now. Thanking you, All the very best, Cheers!!! Saurav

$30 USD in 1 day
(109 Reviews)
5.9

19 freelancers are bidding on average $40 for this job

(336 Reviews)
8.0
(28 Reviews)
7.4
dnplugins

Please provide more information about the code, more specifically the query. It seems the the problem you are encountering is an issue on the query itself. I have been a website developer for more than 7 years, workin More

$50 USD in 2 days
(106 Reviews)
6.3
TechnicalKnight

I am php and sql expert. I have strong understanding of mysql. I can fix the error for you. I dont have issue working on adult website. Please send me details over chat.

$30 USD in 1 day
(110 Reviews)
5.9
(11 Reviews)
5.6
ankur625

The errors you mentioned here are not about PHP but MySQL. Looks like you've upgraded to MySQL 8+ version. The MySQL 8 has some default settings which cause some SQL queries not to work properly. I can help you update More

$150 USD in 7 days
(62 Reviews)
5.5
kchoudhary95

Hello, I am an Expert in software. Because of this, I feel confident to deliver this project. I have 7+ years experience. Kindly let us discuss details in the chat. Cheers.

$30 USD in 1 day
(44 Reviews)
4.7
yalinvyacheslav

✤✤✤ FullStack Web Developer 7 years Exp ✤✤✤ I have read your requirement in detail. I can do this task and will start working on it right now! I have excellent knowledge on web technologies PHP,JAVA,Javascript,Laravel, More

$30 USD in 7 days
(4 Reviews)
4.1
towojuads

I will fix all issues in your adult website script, am available to get the task done right away, kindly chat me up sir.

$50 USD in 1 day
(14 Reviews)
4.0
edwarddzi8f

I will help you with new server configurations, most of the time the issue is PHP extensions or version. Hi, I am a senior PHP (Laravel, VueJs) developer and software architect with 10+ years experience in software de More

$40 USD in 3 days
(10 Reviews)
3.5
volodmart

Hello Dear. I read your job description carefully. What you require is basic in MySQL. I am a PHP expert. It is piece of cake for me. I have a lot of experience in this field. Please contact me and let's discuss more d More

$20 USD in 1 day
(9 Reviews)
3.7
technicalfoodie

Dear Sir, I can do the work in 1 day but it may vary depends upon the changes it requires. Let me very clear mysql upgrade shouldn't affect the script as mysql support previous version but it should be with php versio More

$111 USD in 1 day
(4 Reviews)
3.7
VaLer0chka

Hello Sir, I read the description of your project. I am an experienced php programmer. And I can work full time for you because I don't have any projects now. So, if you give me this project, I will work well and maint More

$30 USD in 1 day
(2 Reviews)
2.2
gausstoday

Hi Dear. It's my pleasure to put my bid in your project. I read your requirement very carefully. I hope to discuss with you in more detail by chatting. I have rich experiences in web development by using PHP/Laravel/A More

$20 USD in 2 days
(1 Review)
0.0
svetlana550

Hi,client. I am devs you looking now. I saw your description and I have confidence it can. If you hire me, you will haven't damage. Hope your [login to view URL]

$20 USD in 1 day
(0 Reviews)
0.0
msarsaripro

Hi, I think I know where's the problem, I had work on the seem issue while upgrading an appach server. Let me see the php file to check the SQL .

$20 USD in 7 days
(0 Reviews)
0.0
Maheshspidee

I can fix the issue. So If u wish to take care of it then revert back as soon as possible. The error is because of SQL syntax so we can fix it easily

$20 USD in 4 days
(0 Reviews)
0.0
uvtxyz1991

- previous experience in such topics; - eager to discuss a lot in this chat stream; - degree stats / maths;

$20 USD in 1 day
(0 Reviews)
0.0