MDL-55565 core_backup: Fix warning when restoring question categories
authorJake Dallimore <jake@moodle.com>
Mon, 15 Aug 2016 06:19:35 +0000 (14:19 +0800)
committerJake Dallimore <jake@moodle.com>
Thu, 18 Aug 2016 02:15:51 +0000 (10:15 +0800)
Fixed a call to get_records_sql, which was being used incorrectly in
restore_find_best_target_context to determine a unique contextid.

backup/util/dbops/restore_dbops.class.php

index 6d48d36..a4c7075 100644 (file)
@@ -795,7 +795,7 @@ abstract class restore_dbops {
                      // Prepare the query
                      list($stamp_sql, $stamp_params) = $DB->get_in_or_equal($stamps);
                      list($context_sql, $context_params) = $DB->get_in_or_equal($contexts);
-                     $sql = "SELECT contextid
+                     $sql = "SELECT DISTINCT contextid
                                FROM {question_categories}
                               WHERE stamp $stamp_sql
                                 AND contextid $context_sql";