I have an issue with a final quiz, taken by a course participant. This person was enrolled in the course with two roles:
Student (local level, course level)
Manager (global level)
The quiz was carried out, but since he had the role of Manager, it was taken as a preview and not as an actual attempt. The candidate saw the quiz completed, but his answers did not appear in the report with the quiz answers of the other participants.
Following this discussion, I tried to solve the problem in this way
Remove the Manager role
From the database go to mdl_quiz_attempts and change the preview value from 1 to 0 to the record of the person concerned.
Re-evaluate the attempt
Unfortunately I stopped at step one, because the participant no longer had the message of completing the quiz, but he is now allowed to take the quiz again (perhaps this made all the rest going bust).
At that point I was no longer able to find the answers of the quiz that were stored as a preview in the DB, preventing me from taking step 2.
It seems that his preview of the quiz that I wanted to convert into an attempt (see step 2) has disappeared. By doing a general search in the db of an open answer he had given, however, I managed to find it in mdl_question_attempt_step_data.
Maybe there is still hope ... Except that I don't know the structure of the DB and in general I'm not very expert so I would like to avoid getting by hand.
Thanks for support
Moving to the General help forum...