PleskMainDBException on SSL certificate update

Applicable to:

Symptoms

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

Actual result that you got : ERROR: PleskMainDBExceptionMySQL 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: