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
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
19 freelanceria on tarjonnut keskimäärin $40 tähän työhön
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.
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.
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]
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