sql mode error using jetbackups

[prithwirajsinha99]

[ERROR] Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mysql.u.User' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by. (Query: SELECT concat_ws('@', u.user, u.host) as username, u.authentication_string as password, p.TABLE_SCHEMA as database_name, GROUP_CONCAT( p.PRIVILEGE_TYPE SEPARATOR ',') AS database_grants FROM mysql.user as u LEFT JOIN information_schema.SCHEMA_PRIVILEGES as p ON p.GRANTEE = concat('\'',u.user,'\'@\'',u.host,'\'') WHERE (u.user LIKE 'aakankshaen\_%' OR u.user = 'aakankshaen') GROUP BY p.GRANTEE, p.TABLE_SCHEMA)

 

[dierkurakura]

i have same issue.
i have opened ticket support but they suggest me to check this page https://stackoverflow.com/questions...nd-contains-nonaggregated-column-inc/41887524

can anyone help us to solve it?

 

[prithwirajsinha99]

i have same issue.
i have opened ticket support but they suggest me to check this page https://stackoverflow.com/questions...nd-contains-nonaggregated-column-inc/41887524

can anyone help us to solve it?

The problem is solved. Actually you need to modify sql_mode in your /etc/my.cnf (or /etc/my.cnf.d/server.cnf) to empty line, restart mysql and retry. I mean, add this line:

sql_mode=

 

[dierkurakura]

Yes, i have solved it. i used centos 7 and edit /etc/my.cnf
added sql_mode= on my.cnf to disable strict mode.
After save it, restart mysql. Everything looks good now.

I think directadmin should disable strict mode defaultly.
Please check this article https://bobcares.com/blog/mysql-disable-strict-mode/

Good luck all.