Hello, something weird is happening with my Moodle instance.
Students are submitting their assignments but the status in the submission page remains as "No submission"
If I click the 'Grade' button the file is there. If I log in as the student the file and submission shows ok and the status as "Submitted for grading".
I was searching for an answer in the mdl_assign_submission tables and I realized that there should be an entry where the latest column should be equal to 1 for status submitted. In my case the value is zero.
Looking into the looks I found the following
[08-Apr-2021 00:40:15] Default exception handler: Error writing to the Database Debug: Duplicate entry '40014-72562-0-0' for key 'mdl_assisubm_assusegroatt_uix'
0 => '40014',
1 => '72562',
2 => 1617831615,
3 => 1617831615,
4 => 'new',
5 => 0,
6 => 1,
I tried almost everything I could think of to fix this, I resubmitted the students file, I renamed the file and uploaded it again. I tried to revert it to draft but I dont get the option.
So I have 2 questions:
1. Is there a way to fix it? Either manually, using INSERT/UPDATE something to the database or from Moodle GUI?
2. Anyone knows why this could happen?