General help

As far as I am aware, you can add, edit and delete scales using the icons in the Action column. The problem is that once you have used the grade book, the the buttons no longer appear and there is no way to change them. This is actually self protection, when you think about it, from the Teacher's perspective, do it for one, do it for all.

However, there is always hope in Moodle. I am not surprised there was no response in the database forum, I don't think this is actually a database issue. Try this:

Back your course up and DO NOT backup ANY user data. Keep the course files AND the Teacher assignment - but leave EVERYTHING else behind. Restore the course as a new course and check out the grade book. If this works, you can backup your courses keeping the original and complete data or delete them as you need. Try it on your test Moodle first - but it should work.

(Second attempt at posting.)

And now having gotten a bee in my bonnet about finally getting rid of that scale that's been annoying me for so long, I've figured out a solution. It's probably not the most elegant, but it's functional.

In a test course, create an assignment with a distinctive name (mine: "Donna's Greek Assignment") and choose the offending scale for the Grade.

Login to your database and run this query:
mysql> SELECT course, name, grade FROM `mdl_assignment` WHERE name like "%Greek%";

My result:
+--------+--------------------------+-------+
| course | name | grade |
+--------+--------------------------+-------+
| 2600 | Donna's Greek Assignment | -2 |
+--------+--------------------------+-------+

course = the course id
name = name of the assignment
grade = the id of the offending scale, yours will probably differ

Now run a query to find all the other assignments using that same scale:
mysql> SELECT course, name FROM `mdl_assignment` WHERE `grade`=-2 order by course;
+--------+---------------------------------------------------------+
| course | name |
+--------+---------------------------------------------------------+
| 2600 | Donna's Greek Assignment |
| 2949 | Preventing STDs Handout |
| 2949 | Growth Chart Assignment |
| 2949 | Accident Prevention Assignment |
| 2949 | Iron Deficiency Anemia Teaching Plan |
| 2949 | Diabetes |
| 3078 | Facts Poem - Part 4 |
| 3079 | Revisions |
| 3079 | Portfolio |
| 3079 | Assignment 3 Due |
| 3079 | Assignment 4 Due |
etc

Use the course ID to track down which course hosts the assignment with the offending scale.
https://your.moodle.site/courses/course/view.php?id=2600

Now all I have to do is compose an e-mail telling the teachers to change the scale before I delete it. Hm. All this rests on the assumption that if all the assignments are changed to some other scale, the offending scale will be available to be deleted. I'll let you know.

Donna Hrynkiw
Pleased that she's *finally* able to give back to the community who has supported her Moodle activities for so long.
Kwantlen Polytechnic

ETA: to correct a typo