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
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.
To fix the issue, disable
/etc/my.cnf, and reload MySQL service.
If you want to know more about indeterminate results, and group by, please refer to these articles: