Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Major
-
Resolution: Duplicate
-
Affects Version/s: 1.8.7
-
Fix Version/s: None
-
Component/s: Quiz
-
Labels:None
-
Environment:Solaris
-
Database:Oracle
-
Difficulty:Easy
-
Affected Branches:MOODLE_18_STABLE
Description
Teachers can't view the summary of the quizzes answered by their students. It's a specific problem related with Oracle. To solve it it's necessary to edit the mod/quiz/report/overview/report.php file, go to the quiz_report/display method and remove the "AS" in the SQL query in the following line (line 410 aprox.):
ORIGINAL:
$from .= " JOIN {$CFG->prefix}quiz_feedback AS qf ON " .
NEW (it works OK for Oracle and for MySQL):
$from .= " JOIN {$CFG->prefix}quiz_feedback qf ON " .
We attach also the file agora_quiz_problem.png to show you what was happening before to solve the problem.
Attachments
Issue Links
| This issue duplicates: | ||||
| MDL-18122 | Quizzes overview show not results when Feedback is included |
|
|
|
Activity
- All
- Comments
- History
- Activity
- Source
- Test Sessions
You are correct (this is even in the coding guidelines). Thanks for the fix.
However, we already knew about this, and it is fixed in 1.8.8+:
MDL-18122.MDL-18122.