Applicable to:
- Plesk 11.x for Linux
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/
Comments
0 comments
Please sign in to leave a comment.