Recovering a "lost" attempt on MoodleCloud

Recovering a "lost" attempt on MoodleCloud

by Davi Odó -
Number of replies: 4

Hello everyone,

I'm hosting a Moodle course using the Moodlecloud basic plan. Last week, one of my students did a quiz attempt but, somehow, it got lost - I think she didn't submit it, but I'm not sure.

The problem is: it's like it never happened. She can't continue the quiz and there's no memory of her attempt. However, I can find it in the logs. When I click it, it shows:

"Can not find data record in database table quiz_attempts"

Is there any way I can access the attempts table on MoodleCloud?

Thanks!

Average of ratings: -
In reply to Davi Odó

Re: Recovering a "lost" attempt on MoodleCloud

by Mathieu Petit-Clair -
Picture of Core developers Picture of Moodle HQ Picture of MoodleCloud team Picture of Plugin developers Picture of Testers

Hi Davi, 

This error is not specific to MoodleCloud and the folks in the quiz forum might be more helpful at explaining how this happens (and how to prevent it).

It is not possible to access the sql tables of a MoodleCloud site, but if you contact us from the MoodleCloud portal (we would then know which site is yours...) we might be able to help. I agree with you that she might have not submitted her attempt and unfortunately in this case, looking at the database would not recover anything.

Mathieu

In reply to Davi Odó

Re: Recovering a "lost" attempt on MoodleCloud

by Tim Hunt -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

There are only two ways this can happen:

  • A teacher goes and manually deletes the attempt using the quiz reports. (Check the logs.)
  • The permissions are set up wrong, so the student has the teacher's permission to preview the quiz instead of attempt it (Use Quiz administration -> Check permissions and look for mod/quiz:preview.)

In reply to Tim Hunt

Re: Recovering a "lost" attempt on MoodleCloud

by Davi Odó -

Thanks for the reply, Tim!

That makes sense: this particular student was also acting as my assistant, so she had administrator privileges. It's very possible that she just previewed the test and thought she was making a real attempt. In this case, is there any way to get her answers back?

Thanks again!