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 9715a5d..4df4360 100644 (file)
--- 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,
         );
 
             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)) {
 
         foreach ($statuses as $status) {
             if (empty($status->statuscount)) {