Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'ngaiyoo_pembeni.invoice.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT * FROM `invoice` WHERE `user_id` = 2765 AND `status` = 1 GROUP BY `invoice`.`created_at` ORDER BY `invoice`.`created_at` DESC LIMIT 20

Filename: modules/payment/models/Payment_model.php

Line Number: 557

I am using Php version 7.4. I don't know what version of PhP is needed again.

Downgraded and still the same. Nothing changed. Please check.

Thank you for your reply. But what you have sent me only ask you to run the code by command, But does not say where to run that command. where do i go exactly on my Cpanel to run this command? Do I go to PhPmyAdmin  and run command on my database or what. I am confused and new to this.

I am not a developer so I have no idea what you are talking about. I run command and get this.

SQL query: 

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))

MySQL said: 

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation