MDL-35252: Fix a bug that creates unneccessary rows in grade_grades table when unchec...
authorRaymond Wijaya <raymond.wijaya@netspot.com.au>
Wed, 12 Sep 2012 06:19:32 +0000 (14:19 +0800)
committerRaymond Wijaya <raymond.wijaya@netspot.com.au>
Tue, 25 Sep 2012 04:19:07 +0000 (12:19 +0800)
mod/assign/locallib.php

index d248681..8ba72d4 100644 (file)
@@ -3380,7 +3380,7 @@ class assign {
         $graderesults = $DB->get_recordset_sql('SELECT u.id as userid, s.timemodified as datesubmitted, g.grade as rawgrade, g.timemodified as dategraded, g.grader as usermodified
                             FROM {user} u
                             LEFT JOIN {assign_submission} s ON u.id = s.userid and s.assignment = ?
-                            LEFT JOIN {assign_grades} g ON u.id = g.userid and g.assignment = ?
+                            JOIN {assign_grades} g ON u.id = g.userid and g.assignment = ?
                             ' . $where, array($assignmentid, $assignmentid, $userid));