PleskMainDBException on SSL certificate update

Refers to:

  • Plesk 11.5 for Linux

Created:

2016-11-16 12:42:16 UTC

Modified:

2016-12-21 19:01:00 UTC

0

Was this article helpful?


Have more questions?

Submit a request

PleskMainDBException on SSL certificate update

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/

Have more questions? Submit a request
Please sign in to leave a comment.