Description

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

Attempts: 25

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()