X-Git-Url: http://git.moodle.org/gw?p=moodle.git;a=blobdiff_plain;f=mod%2Ffeedback%2Fdb%2Fupgradelib.php;h=bff41339dbb5d33fcf7dabceafc635d56d0918a1;hp=fdad98cbba581105049f4c0519909332e7a4cce9;hb=0a0632cee65582daaafed4664749a3a0ee8f3c4d;hpb=c04dc3ca131a4229048da7f97412ba8bfcdb7618

diff --git a/mod/feedback/db/upgradelib.php b/mod/feedback/db/upgradelib.php
index fdad98cbba5..bff41339dbb 100644
--- a/mod/feedback/db/upgradelib.php
+++ b/mod/feedback/db/upgradelib.php
@@ -56,8 +56,9 @@ function mod_feedback_upgrade_courseid($tmp = false) {
     }
 
     // Part 2. Update courseid in the completed table.
-    $sql = "UPDATE {feedback_completed$suffix} c "
+    $sql = "UPDATE {feedback_completed$suffix} "
             . "SET courseid = (SELECT COALESCE(MIN(v.course_id), 0) "
-            . "FROM {feedback_value$suffix} v WHERE v.completed = c.id)";
+            . "FROM {feedback_value$suffix} v "
+            . "WHERE v.completed = {feedback_completed$suffix}.id)";
     $DB->execute($sql);
 }