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"

    Details

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

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

        Activity

          People

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

            Dates

            • Created:
              Updated:
              Resolved: