-
Bug
-
Resolution: Fixed
-
Critical
-
2.5.1, 2.6.3, 2.7.5, 2.8.3
-
Oracle
-
MOODLE_25_STABLE, MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
-
MOODLE_27_STABLE, MOODLE_28_STABLE
-
MDL-40776_master -
-
Easy
-
When I try to see Outcomes report in Grade administration I get this error.
Using ORACLE DB the step are the following:
1) enable Outcomes
2) create a course
3) create an Outcome
4) create an Assignment and flag the outcome
5) click on "Grades";
6) click on "Outcomes report" in "Grade administration";
Then I get this error:
Debug info: ORA-00933: SQL command not properly ended
SELECT itemid, AVG(finalgrade) AS avg, COUNT(finalgrade) AS count
FROM d_grade_grades
WHERE itemid = :o_param1GROUP BY itemid
[array (
'o_param1' => 439,
)]
I fixed the error adding a space in line 77 (file: grade/report/outcomes/index.php) before GROUP
73 $sql = "SELECT itemid, AVG(finalgrade) AS avg, COUNT(finalgrade) AS count
74 FROM
75 WHERE itemid = ?".
76 $hidesuspendedsql.
77 "GROUP BY itemid";
modifying the line in " GROUP BY itemid";
- is duplicated by
-
MDL-43935 Fix bug "Error in Outcomes report in Grade administration with ORACLE" - MDL-40776
- Closed