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.

Taidot: PHP, MySQL, SQL

Näytä lisää: 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

Tietoa työnantajasta:
( 11 arvostelua ) Perth, Australia

Projektin tunnus: #30126602

Myönnetty käyttäjälle:


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 1 päivässä
(109 Arvostelua)

19 freelanceria on tarjonnut keskimäärin $40 tähän työhön

(336 arvostelua)
(28 arvostelua)

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 Lisää

$50 USD 2 päivässä
(106 arvostelua)

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 1 päivässä
(110 arvostelua)
(11 arvostelua)

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 Lisää

$150 USD 7 päivässä
(62 arvostelua)

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 1 päivässä
(44 arvostelua)

✤✤✤ 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, Lisää

$30 USD 7 päivässä
(4 arvostelua)

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 1 päivässä
(14 arvostelua)

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 Lisää

$40 USD 3 päivässä
(10 arvostelua)

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 Lisää

$20 USD 1 päivässä
(9 arvostelua)

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 Lisää

$111 USD 1 päivässä
(4 arvostelua)

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 Lisää

$30 USD 1 päivässä
(2 arvostelua)

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 Lisää

$20 USD 2 päivässä
(1 arvostelu)

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 1 päivässä
(0 arvostelua)

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 7 päivässä
(0 arvostelua)

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 4 päivässä
(0 arvostelua)

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

$20 USD 1 päivässä
(0 arvostelua)