From c6d7689621d7f28e552d3fcb499557ec3e3ddaf6 Mon Sep 17 00:00:00 2001 From: Nathan Mares Date: Tue, 17 Jul 2012 19:37:06 +1000 Subject: [PATCH] MDL-34372: Fix query in backup_cron_helper so it works on Postgres 8.3 Amended by stronk7@moodle.org to use uppercase SQL keywords. --- backup/util/helper/backup_cron_helper.class.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/backup/util/helper/backup_cron_helper.class.php b/backup/util/helper/backup_cron_helper.class.php index 9715a5d06ad..4df43602435 100644 --- a/backup/util/helper/backup_cron_helper.class.php +++ b/backup/util/helper/backup_cron_helper.class.php @@ -255,7 +255,7 @@ abstract class backup_cron_automated_helper { self::BACKUP_STATUS_SKIPPED => 0, ); - $statuses = $DB->get_records_sql('SELECT DISTINCT bc.laststatus, COUNT(bc.courseid) statuscount FROM {backup_courses} bc GROUP BY bc.laststatus'); + $statuses = $DB->get_records_sql('SELECT DISTINCT bc.laststatus, COUNT(bc.courseid) AS statuscount FROM {backup_courses} bc GROUP BY bc.laststatus'); foreach ($statuses as $status) { if (empty($status->statuscount)) { -- 2.43.0