From: Nathan Mares <nathan@catalyst-au.net>
Date: Tue, 17 Jul 2012 09:37:06 +0000 (+1000)
Subject: MDL-34372: Fix query in backup_cron_helper so it works on Postgres 8.3
X-Git-Tag: v2.3.2~79
X-Git-Url: http://git.moodle.org/gw?p=moodle.git;a=commitdiff_plain;h=c6d7689621d7f28e552d3fcb499557ec3e3ddaf6

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

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)) {