Scheduled backup task not working: backupmng: Unable to fetch backup tasks from database

Created:

2016-11-16 13:01:11 UTC

Modified:

2017-08-08 13:34:23 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Scheduled backup task not working: backupmng: Unable to fetch backup tasks from database

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Scheduled backup task not working and backupmng tool is showing the below error.

# /usr/local/psa/admin/sbin/backupmng
backupmng: Unable to fetch backup tasks from database: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'psa.BackupsScheduled.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
backupmng: Unable to fetch backup tasks from database: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'psa.BackupsScheduled.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Cause

MySQL strict SQL mode with ONLY_FULL_GROUP_BY is enabled

Resolution

  1. Disable the MySQL strict mode by adding the below line under the [mysql] section of /etc/my.cnf :

    [root@cloudlinux ~]# grep -i sql-mode /etc/my.cnf
    sql-mode=""
  2. Restart MySQL service

  3. Log in to MySQL server and check SQL mode:

    mysql> SELECT @@sql_mode;
    +------------+
    | @@sql_mode |
    +------------+
    | |
    +------------+
    1 row in set (0,00 sec)
Have more questions? Submit a request
Please sign in to leave a comment.