I almost never do anything directly with the mysql database, as it should be. And I don't have other experience with mysql. Now I have a need to look into it, and I wondered if I could post here asking for some guidance.
An instructor created a GW quiz. Three students were the first to take it. Then the instructor also clicked to start a version. We think the instructor saw something he wanted to change, and changed something with the global quiz config. But he cannot recall. Then more students took the quiz.
Now we cannot access the quiz versions for the original three students. Their scores are visible in various places, but any attempt to load their quizzes gives the "one or more of the problems in this set have not been assigned to you" message. I know this can happen when quiz question numbering is not consecutive, but I don't see evidence of that being the case here. So I'm wondering what else could cause this. And I thought to actually look in the database and see how the tables are different for these three students compared to the others.
Is someone able to talk me through how I look at these without messing things up?