From: Simey Lameze <simey@moodle.com>
Date: Thu, 14 May 2020 05:02:29 +0000 (+0800)
Subject: MDL-68683 core: fix DML exception on upgrade step
X-Git-Tag: v3.9.2~63^2~2
X-Git-Url: http://git.moodle.org/gw?p=moodle.git;a=commitdiff_plain;h=1547225e5248eb226f0db8e5b5710b7618175103

MDL-68683 core: fix DML exception on upgrade step
---

diff --git a/lib/db/upgrade.php b/lib/db/upgrade.php
index 32298db70a0..96867f6afa1 100644
--- a/lib/db/upgrade.php
+++ b/lib/db/upgrade.php
@@ -2194,8 +2194,11 @@ function xmldb_main_upgrade($oldversion) {
             $DB->delete_records('competency_userevidencecomp', ['userevidenceid' => $userevidence->id]);
             $DB->delete_records('competency_userevidence', ['id' => $userevidence->id]);
 
-            $context = context_user::instance($userevidence->userid);
-            $fs->delete_area_files($context->id, 'core_competency', 'userevidence', $userevidence->id);
+            if ($record = $DB->get_record('context', ['contextlevel' => CONTEXT_USER, 'instanceid' => $userevidence->userid],
+                    '*', IGNORE_MISSING)) {
+                // Delete all orphaned user evidences files.
+                $fs->delete_area_files($record->id, 'core_competency', 'userevidence', $userevidence->userid);
+            }
         }
 
         $sql = "SELECT cp.id