Author Topic: Can't list user accounts after MySQL update  (Read 280 times)

0 Members and 1 Guest are viewing this topic.

Offline
*
Can't list user accounts after MySQL update
« on: July 20, 2017, 03:06:26 PM »
Hi,

The problem started after upgrading from MySQL to version 5.7.18.

The error below occurs when accessing User Accounts > List Account.
Quote
DataTables warning: table id=userTable - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1


Offline
*
Re: Can't list user accounts after MySQL update
« Reply #1 on: July 20, 2017, 06:20:25 PM »
Found the problem following this https://datatables.net/manual/tech-notes/1

The response was:
Quote
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'root_cwp.user.domain' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

After setting the sql_mode parameter in /etc/my.cnf the problem has stopped.