Can't grade some assignments (grading dropdown greyed-out)

Re: Can't grade some assignments (grading dropdown greyed-out)

by Andy Cravens -
Number of replies: 0
You could run an SQL statement to remove all grade overrides for the entire system or for a specific subset of grades. I posted an SQL that removed overrides for gradebook entries where there was no grade listed. But if you know for sure you want to remove all overrides system wide, it would be easy to do so.

This SQL removes the override if rawgrade and finalgrade are both null:

UPDATE mdl_grade_grades SET overridden = 0 WHERE overridden > 0 AND rawgrade is NULL AND finalgrade is NULL;

If you wanted to remove all overrides systemwide you would run:

UPDATE mdl_grade_grades SET overridden = 0;

I don't know the ramifications of removing all overrides. Maybe someone else can chime in here.

If you are sure you NEVER want to use the override functionality you could have your DBA automatically run that last SQL statement at regular intervals. It's probably not the best way to achieve your desired results but it would work.

You would need to test this first on non production data.