Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-18032

Highest Greade does not post in Gradebook. Error ,"mdl_quiz_grades' is marked as crashed and should be repaired"


    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not a bug
    • Affects Version/s: 1.9.2
    • Fix Version/s: None
    • Component/s: Quiz
    • Labels:
    • Environment:
      Moodle 1.9.2, PHP 5.2.4, MySQL 5.0.51a
    • Database:
    • Affected Branches:


      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()
      • line 73 of mod/quiz/report.php: call to quiz_report->display()

        Gliffy Diagrams



            • Votes:
              0 Vote for this issue
              2 Start watching this issue


              • Created: