Article ID: 116668, created on Aug 7, 2013, last review on Aug 7, 2013

  • Applies to:
  • Plesk 11.5 for Linux


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: '' 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.

## 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:

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f

Email subscription for changes to this article
Save as PDF