Database Backup Errors: only_full_group_by

While performing a Database Backup, you may encounter the following error:

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column '' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.

This is an error returned from the MySQL Process. We have found that changing the MySQL mode to only_full_group_by can resolve this issue. To do this, please run the following MySQL query.


After setting the MySQL mode, try running the backup again and see if the error persists.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Amazon S3 Backup Sizes Not Displayed In JetBackup

If you notice JetBackup 4 Restore and Download page is missing Backup Sizes for Backups located...

Backup Issue - Skipping Account Not Enough Disk Space

JetBackup uses a local workspace to store an account backup before transferring it to its...

Backup Job stuck on CloudLinux servers

There is a known issue with CloudLinux servers when using JetBackup's default rsync...

Failed to Prepare Temporary Snapshot

The error: Failed to prepare temporary snapshot can appear for many different reasons. Please...

Database Backups Errors: No Such File or Directory

We have found that occasionally mysqldump has problems connecting via localhost on some...