Mysqli Error fix
£10-20 GBP
Pago na entrega
I have some code in PHP pulling out some data with mysqli from the database. I've just updated the MySql to 5.7 which has caused me an issue when running the following code:
$getteacherpoints = "SELECT *, SUM(total) AS 'TotalPoints' FROM ".mysqli_real_escape_string($conn, $teacherpoints)." WHERE Week(timestamp)='".mysqli_real_escape_string($conn, $weeknumber)."' AND classcode='".mysqli_real_escape_string($conn, $classcode)."' AND YEAR(timestamp)='".mysqli_real_escape_string($conn, $year)."' GROUP BY studentid ORDER BY TotalPoints DESC";
Error coming from MySql system is:
which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Please contact me if you can fix this ASAP.
ID do Projeto: #18922984
Sobre o projeto
29 freelancers estão ofertando em média £18 nesse trabalho
Hi there, I am a Senior PHP Developer. I am really interested to work for you. Let's discuss with me. I will fix asap. Let's start with me. Thanks
Hello can i fix this error please let's start right and get its done with perfect l'm ready for this job thanks
Hey, I have read your description. I have expertise in web development. Kindly feel free to message so I can assist you
Hello, I'm Abu Gosia. I'm interesting your project very well. I m quite well experienced in these jobs. Let's go ahead with me. Thanks
Hi, I've read carefully of your job description about "Mysqli Error fix".I am a professional "Full Stack Web Developer".I have more than five years experience in Web Development. Your satisfaction with the project Mais
Hi, I would like to fix the error regarding group by clause. Available for discussion and ready to start now. Regards, Manish
Hi, Let's fix this right away. I can help you to get this issue resolved. This will require config change in my sql server. Thanks,
Hello, I can help you. I have more than 10 years of experience in website design and development over HTML, CSS, Bootstrap, Javascript, jQuery, AJAX, Angular, PHP and MySQL technologies. Thanks, regards.
Hello sir, I can fix your mysql error. I have 9 years of experience as PHP web developer. I will give you best quality of work. Waiting for your reply. Thank you.
Hi there, I have read the details, and would say that i can resolve the issue by making some changes through phpmyadmin by running a command . Thanks & regards, S. K. Rawal
Hi, I read your job very carefully. I have rich experience about backend(nodejs,Codeigniter, Laravel) for 5 years,and 3 years experience of frontend development(HTML,CSS,Javascript,Bootstrap,Jquery,AngularJS etc.) Mais
I can fix it for you today. This happened to me to long time ago when I did update mysql version on aws.
hello sir ,, i can help you with this request in less than 1 hour only if you didn't mind please contact me
Hello! I can help you fix this issue. Send me a message if you need any other relevant information! Thank you in advance!
php mysql I can do it plz let me know if you are ready I will resolve it soon...... ..... I am okay do it I know that.....
I am Ring. I am about 18+ years experienced in GNU/Linux based system, server installation and customization, develop, deploy, security and support. I may help you in this regard.
I faced same error when I was upgrade MySQL in aws redis just need to change sql mode so I can do it looking forward to hear back Relevant Skills and Experience Mysql, AWS
""Dear Employer We will give you the best result by using my Past experience and excellent academic skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar pro Mais