Symptoms

While trying to update my ssl certificate, lots of modules are reporting the same error:

Actual result that you got : ERROR: PleskMainDBException
MySQL query failed: 'psa.c.name' isn't in GROUP BY

Cause

The issue is caused by MySQL server configuration.Plesk Panel uses indeterminate results of group by operation in several cases. If ONLY_FULL_GROUP_BY option is enabled in MySQL, such requests will fail with error.

## Resolution

To fix the issue, disable ONLY_FULL_GROUP_BY in /etc/my.cnf , and reload MySQL service.

If you want to know more about indeterminate results, and group by, please refer to these articles:

http://dev.mysql.com/doc/refman/5.1/en/group-by-extensions.html

http://blog.mclaughlinsoftware.com/2010/03/10/mysql-standard-group-by/