Resolution: Not a bug
Affects Version/s: 1.9.2
Fix Version/s: None
Environment:Moodle 1.9.2, PHP 5.2.4, MySQL 5.0.51a
The scores to my moodle quizzes are not posting to Moodle's gradebook. Students see their scores after the quiz. They also show up if I click the quiz and look at the results. But they are not posting to Moodle's gradebook. When a student clicks the grades button...no new scores post. The Gradebook shows some initial scores while others are updated with their highest scores. How do I repair the db table or gradebook to show the highest grade. This is a big problem being that this one course has 100's or quizzes to grade. Any workaround suggestions would be appreciated. I have searched the forums and can not find an identical situation.
I set the debug mode to ALL and when I clicked Quizzes, then Attempts (it does not matter for which quiz) I receive the following errors.
Error: Could not insert a new entry to the Moodle log
Showing graded and ungraded attempts for each user. The one attempt for each user that is graded is highlighted. The grading method for this quiz is Highest grade.
Table './centralyork_moodle/mdl_quiz_grades' is marked as crashed and should be repaired
SELECT AVG(qg.grade) AS grade FROM mdl_quiz_grades qg WHERE quiz=1512 AND qg.userid IN (4598,3465,4617,4309,5735,4570,4665,4555,5634,4687,6163,8325,4633,4494,5763,4330,4201,5632,4584,4557)
- line 686 of lib/dmllib.php: call to debugging()
- line 481 of lib/dmllib.php: call to get_recordset_sql()
- line 584 of mod/quiz/report/overview/report.php: call to get_record_sql()
- line 73 of mod/quiz/report.php: call to quiz_report->display()