I get the following error when creating a new user in the I-MSCP panel:
An unexpected error occurred
An exception has been thrown in file /var/www/imscp/gui/library/Functions/Shared.php at line 2778:SQLSTATE: Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'imscp.sql_user.sqlu_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT sqlu_id, sqlu_name, sqlu_host FROM sql_user INNER JOIN sql_database USING(sqld_id) WHERE domain_id = :domain_id AND sqld_id != :sqld_id AND CONCAT(sqlu_name, sqlu_host) NOT IN( SELECT CONCAT(sqlu_name, sqlu_host) FROM sql_user WHERE sqld_id = :sqld_id ) GROUP BY sqlu_name, sqlu_host
I haven't done that since 6 months ago. But I have updated my MySQL server version from 5.5 to 5.7 since then (run the mysql_upgrade command and the repair all databases command, too with no effect). Is this related to the upgrade?
How do I fix it?
I am running Debian 8.1 with MySQL 5.7.9 and I-MSCP 1.2.9