academic-moodle-cooperation / moodle-mod_offlinequiz

The Offline Quiz activity allows the creation of multiple choice tests with questions from the question bank of a Moodle course, which are handed out to students in printed form. After completion, the answer forms are scanned and can be automatically evaluated online directly in Moodle.
https://academic-moodle-cooperation.org/mod_offlinequiz/
GNU General Public License v3.0
30 stars 58 forks source link

Page Already Exist Problem #263

Open MiuAnnur opened 5 months ago

MiuAnnur commented 5 months ago

offlinequiz

Hello, i've problem with this plugin, error "page already exist", probably because i'm upload same (student id number) file twice i don't know how to resolve this problem event if i delete offline cron job as admin user and upload again it is not solution. it's also not stundent not receive a grade,

cmichale commented 5 months ago

To Whom It May Concern,

I am out of office until 17 June 2024.

In the meantime please contact

Best regards, Claus Rainer Michalek

MiuAnnur @.***> 5.6.24 08:58 >>>

offlinequiz

Hello, i've problem with this plugin, error "page already exist", probably because i'm upload same (student id number) file twice i don't know how to resolve this problem event if i delete offline cron job as admin user and upload again it is not solution. it's also not stundent not receive a grade,

-- Reply to this email directly or view it on GitHub: https://github.com/academic-moodle-cooperation/moodle-mod_offlinequiz/issues/263 You are receiving this because you are subscribed to this thread.

Message ID: @.***>

ndunand commented 5 months ago

Hi @MiuAnnur ,

We also repeatedly encountered this problem. I can't recollect in what case exactly this case arises, but our only solution has always been to tackle this in the Moodle database directly. We have to find the numerical offline quiz ID and the student ID (one entered by the student to map his/her answer page to the Moodle progile, and go with:

DELETE FROM mdl_offlinequiz_scanned_pages WHERE userkey = ### AND offlinequizid = ###;

Note: this is a suggestion and NOT a recommendation, as it's always risky to alter the database in this way. Only proceed if you know and understand what's going on. Last, I am just another Offline Quiz user, and I do not offer any kind of support if something goes wrong following this "trick".

MiuAnnur commented 5 months ago

thank you for your quick response

this is my database:
image

MiuAnnur commented 5 months ago

i've deleted database where "ok status" also delete manually doublepage data your suggestion just solved my problem thank you very much