From bf9211ef78989342d16ab11613bc51283d0b5fe4 Mon Sep 17 00:00:00 2001
From: skodak <skodak>
Date: Sat, 8 Mar 2008 15:27:42 +0000
Subject: [PATCH] fixed db warning; merged from MOODLE_19_STABLE

---
 grade/edit/outcome/course.php | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

diff --git a/grade/edit/outcome/course.php b/grade/edit/outcome/course.php
index 4df00e75d8..6e45e27cbd 100644
--- a/grade/edit/outcome/course.php
+++ b/grade/edit/outcome/course.php
@@ -72,7 +72,10 @@ foreach($co_custom as $oid=>$outcome) {
 }
 
 // now check all used standard outcomes are in outcomes_course too
-if ($realused = get_records_select('grade_items', "courseid=$courseid and outcomeid IS NOT NULL", '', 'outcomeid')) {
+$sql = "SELECT DISTINCT outcomeid
+          FROM {$CFG->prefix}grade_items
+         WHERE courseid=$courseid and outcomeid IS NOT NULL";
+if ($realused = get_records_sql($sql)) {
     $realused = array_keys($realused);
     foreach ($realused as $oid) {
         if (array_key_exists($oid, $standardoutcomes)) {
-- 
2.39.5