From 9404c7dbe7b4c3e801b18a1b458a9b5f7a78c768 Mon Sep 17 00:00:00 2001 From: David Mudrak Date: Wed, 22 Sep 2010 13:37:24 +0000 Subject: [PATCH] NOMDL backup: missing AS for column alias Throws DML read exception in PostgreSQL. Credit goes to skodak. --- backup/moodle2/backup_stepslib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/backup/moodle2/backup_stepslib.php b/backup/moodle2/backup_stepslib.php index c8536dcbafc..cf61e1ebae7 100644 --- a/backup/moodle2/backup_stepslib.php +++ b/backup/moodle2/backup_stepslib.php @@ -1788,7 +1788,7 @@ class backup_course_completion_structure_step extends backup_structure_step { $cc->add_child($aggregatemethod); // We need to get the courseinstances shortname rather than an ID for restore - $criteria->set_source_sql("SELECT ccc.*, c.shortname courseinstanceshortname + $criteria->set_source_sql("SELECT ccc.*, c.shortname AS courseinstanceshortname FROM {course_completion_criteria} ccc LEFT JOIN {course} c ON c.id = ccc.courseinstance WHERE ccc.course = ?", array(backup::VAR_COURSEID)); -- 2.39.2