From 7b78154e39e1131c7cc382ff99c3a60f584638ff Mon Sep 17 00:00:00 2001 From: Adrian Greeve Date: Thu, 20 Jul 2017 09:52:32 +0800 Subject: [PATCH] MDL-57649 mod_lesson: Improvement to upgrade query. We only need one record for each filearea that we are removing. --- mod/lesson/db/upgrade.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/mod/lesson/db/upgrade.php b/mod/lesson/db/upgrade.php index c030dc87fea..0ed06b8e8ac 100644 --- a/mod/lesson/db/upgrade.php +++ b/mod/lesson/db/upgrade.php @@ -144,7 +144,7 @@ function xmldb_lesson_upgrade($oldversion) { if ($oldversion < 2017051501) { // Delete orphaned lesson answer and response files. - $sql = "SELECT DISTINCT f.* + $sql = "SELECT DISTINCT f.contextid, f.component, f.filearea, f.itemid FROM {files} f LEFT JOIN {lesson_answers} la ON f.itemid = la.id WHERE component = :component -- 2.36.1