From 23e2a9cb7c3b8e475522cf355bad442300f5a693 Mon Sep 17 00:00:00 2001 From: Adrian Greeve Date: Wed, 19 Jul 2017 15:44:42 +0800 Subject: [PATCH] MDL-57649 mod_lesson: Additional refinement to upgrade script. --- mod/lesson/db/upgrade.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/mod/lesson/db/upgrade.php b/mod/lesson/db/upgrade.php index 6c9baf79a14..c030dc87fea 100644 --- a/mod/lesson/db/upgrade.php +++ b/mod/lesson/db/upgrade.php @@ -148,9 +148,11 @@ function xmldb_lesson_upgrade($oldversion) { FROM {files} f LEFT JOIN {lesson_answers} la ON f.itemid = la.id WHERE component = :component + AND (filearea = :fileareaanswer OR filearea = :filearearesponse) AND la.id IS NULL"; - $orphanedfiles = $DB->get_recordset_sql($sql, array('component' => 'mod_lesson')); + $orphanedfiles = $DB->get_recordset_sql($sql, array('component' => 'mod_lesson', 'fileareaanswer' => 'page_answers', + 'filearearesponse' => 'page_responses')); $fs = get_file_storage(); foreach ($orphanedfiles as $file) { $fs->delete_area_files($file->contextid, $file->component, $file->filearea, $file->itemid); -- 2.17.1