Index: grade_item.php =================================================================== RCS file: /cvsroot/moodle/moodle/lib/grade/grade_item.php,v retrieving revision 1.130.2.26 diff -u -a -w -b -B -r1.130.2.26 grade_item.php --- grade_item.php 27 Mar 2008 17:13:01 -0000 1.130.2.26 +++ grade_item.php 20 Oct 2008 23:17:34 -0000 @@ -1613,10 +1613,12 @@ } // precreate grades - we need them to exist + $course_id_sql = "SELECT courseid FROM {$CFG->prefix}grade_items WHERE id = $this->id"; + $course_id = get_record_sql($course_id_sql); $sql = "SELECT DISTINCT go.userid FROM {$CFG->prefix}grade_grades go JOIN {$CFG->prefix}grade_items gi - ON gi.id = go.itemid + ON ( gi.id = go.itemid AND gi.courseid = $course_id->courseid ) LEFT OUTER JOIN {$CFG->prefix}grade_grades g ON (g.userid = go.userid AND g.itemid = $this->id) WHERE gi.id <> $this->id AND g.id IS NULL";