Moodle

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

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

Ascending order - Click to sort in descending order
Hide
Permalink
Tim Hunt added a comment -

This is not a Moodle bug, this is a problem with your site.

See http://docs.moodle.org/en/How_to_check_your_database_for_corruption for how to deal with it.

Note that Google searching for the text of an error message is normally a highly effective strategy. For example

http://www.google.com.au/search?q=%22is+marked+as+crashed+and+should+be+repaired%22+moodle

Would have immediately got you the solution to your problem.

Show
Tim Hunt added a comment - This is not a Moodle bug, this is a problem with your site. See http://docs.moodle.org/en/How_to_check_your_database_for_corruption for how to deal with it. Note that Google searching for the text of an error message is normally a highly effective strategy. For example http://www.google.com.au/search?q=%22is+marked+as+crashed+and+should+be+repaired%22+moodle Would have immediately got you the solution to your problem.
Hide
Permalink
Thomas Bachert added a comment -

I ran the mysqlcheck with the --auto-repair option. The database is repaired to the point that no more errors appear while viewing the gradebook. However, the only quiz grades that are not getting pulled into the gradebook are those that were not entered manually. Will upgrading from 1.9.2 to 1.9.3 repair this issue? Is there a separate gradebook application that I can apply to overwrite my current one?

Show
Thomas Bachert added a comment - I ran the mysqlcheck with the --auto-repair option. The database is repaired to the point that no more errors appear while viewing the gradebook. However, the only quiz grades that are not getting pulled into the gradebook are those that were not entered manually. Will upgrading from 1.9.2 to 1.9.3 repair this issue? Is there a separate gradebook application that I can apply to overwrite my current one?
Hide
Permalink
Tim Hunt added a comment -

Try regrading the quiz.

If that does not work, I think there is an option in the gradebook to refresh the grades, but I can't remember where you find that, so you will have to check in the docs.

Show
Tim Hunt added a comment - Try regrading the quiz. If that does not work, I think there is an option in the gradebook to refresh the grades, but I can't remember where you find that, so you will have to check in the docs.
Hide
Permalink
Sam Hemelryk added a comment -

Thanks

Show
Sam Hemelryk added a comment - Thanks

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.3#663-r165197) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.