I ran into an issue this week where our grades were completely out of order on the site I'm building in Moodle. The reorder tool worked SOME of the time, but not much at all.
I dug into the database and figured out that I could change the grade item ids and it would reorder them, and spent several hours fixing it manually, but I don't like the idea of fiddling in the database, and I actually broke one of our courses-thankfully it was just a copy and hadn't been populated with the correct info yet.
I'm wondering if there's a bug in there somewhere regarding this. I did both course imports and then when that stopped working (imports would run and the course would still be empty) I moved to backing up and restoring to new courses. That works fine it seems.
I also duped lots of forums and then just changed the info on them (I have since started just manually creating all parts of the course). I'm wondering if the mix of duping and restoring/importing messed up the grade order so bad that it couldn't be adjusted?
I noticed too that judging by the database grade item IDs, for the grade reorder to work, it literally has to reorder the entire list of grades to make room to move something. When there was an open ID number where I wanted to move something, I could move it in Moodle. If there was NOT an open ID, it wouldn't move.
Any ideas? Is this just a limitation and glitch I need to live with and keep an eye out for?