Scheduled backups are not performed: 'psa.BackupsScheduled.id' isn't in GROUP BY

Created:

2016-11-16 13:25:26 UTC

Modified:

2017-08-08 13:40:36 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Scheduled backups are not performed: 'psa.BackupsScheduled.id' isn't in GROUP BY

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Scheduled backups are not performed in scheduled time. The following error is shown while running backupmng utility manually:

 # /usr/local/psa/admin/sbin/backupmng
backupmng: Unable to fetch backup tasks from database: 'psa.BackupsScheduled.id' isn't in GROUP BY
backupmng: Unable to fetch backup tasks from database: 'psa.BackupsScheduled.id' isn't in GROUP BY

Cause

MySQL configuration includes strict options.

Resolution

Review my.cnf file and remove ONLY_FULL_GROUP_BY option from sql-mode setting:

 # grep -ir "sql-mode" /etc/my.cnf
sql-mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY

Restart MySQL service.

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