workshop_list_teacher_submissions: unable to get submission

workshop_list_teacher_submissions: unable to get submission

by Joe Panzica -
Number of replies: 9

Two of my students have gotten this error message.  I'm not sure why.  There had been 3 teacher submissions for them to do their practice assessessments on.  They had done those, submitted their own work- and then assessed it.

Now, they can't get back into the Workshop module.  I've even tried deleting a student from the class and re-enrolling them.  Same issue. 

I do not have adminstrative access, but if I had a little more information about what could be done in such a situation. I might feel ok about bothering the adminstrator who is basically a volunteer, at this point.

This particular issue pretty much looks like a bug, but I'm too unfamiliar with Moodle to say.

Separate issue probably: In my first workshop I think I made a mistake allowing students to assess each others' work.  I did not check "Make Assessments Agree", but students are having a hard time seeing my comments on line.  Printing them out is very unsatisfactory too as the page gets cut off.  This relatively annoying glitch (probably of my own creation, somehow) could well be related to other assessment issues. 

If a student has done a "Self Assessment" of their own work and I go in to do the Teacher's Assessment (I am 99.9% sure I am clicking the right link) I often see their assessment with the "Assessment by _Student Name_" on top.  If I "jiggle" it (Click "Add Comment" or go back and click the same link again) I will see the header "Assessment by _My Name_" now but often the students own comments are still there.  (I am 99.9% sure that I know the difference between entering my own assessment and "Grading" a student's assessment of sample work or their own work."

Next month I am going to try a workshop with the Peer Assessments  option turned off.  Maybe that will clear up most or all of the assessment issues.   I'm hoping there is a way of avoiding or redressing the workshop_list_teacher_submissions: unable to get submission issue.

Or, am I in over my head?

Thanks

Average of ratings: -
In reply to Joe Panzica

Re: workshop_list_teacher_submissions: unable to get submission

by Paul Nijbakker -
Hi,

I just ran into the same issue. Two of my students so far get this error message that stops them from completing their task. I haven't the foggiest idea where this error originates, but you can now be sure it is not with you.

I have used the workshop before (in Moodle version 1.4.5) and this is the first time I encounter this bug (in version 1.5.2).

I hope someone with more genius than I can come up with a solution.

Rgrds,
Paul.
Average of ratings: -
In reply to Joe Panzica

Re: workshop_list_teacher_submissions: unable to get submission

by Steve Turley -
This issue has occured with me using the workshop version for Moodle 1.95.  I tried deleting the students' attempts and having them start over, but the problem continues.
Average of ratings: -
In reply to Steve Turley

Re: workshop_list_teacher_submissions: unable to get submission

by David Mudrák -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
Weird. This error message emerges if there is an assessment record without the assessed submission. This has nothing to do with students' submissions but with the example submissions from the teacher. Are you using them?

d.
Average of ratings: -
In reply to David Mudrák

Re: workshop_list_teacher_submissions: unable to get submission

by Steve Turley -

I am using example submissions from the teacher.  The student said they accidentally deleted their assessment after they wrote it and thought that might have triggered it.  I have access to the database so I cleaned it up by executing the following SQL statement in the MySQL database:

DELETE FROM `mdl_workshop_assessments` WHERE `submissionid` NOT IN (SELECT `id` FROM `mdl_workshop_submissions`)

A quick fix for the problem might be giving the user an option to clean up the data base if the PHP code notices this situation has developed.  (Or just clean it up automatically with a warning.)

Average of ratings: -
In reply to Steve Turley

Re: workshop_list_teacher_submissions: unable to get submission

by David Mudrák -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
Thanks Steve for publishing the solution. I am focused on the future version of the Workshop right now but please, record this issue into the tracker so I can have a closer look at it later. Thanks in advance.

d.
Average of ratings: -
In reply to Joe Panzica

Re: workshop_list_teacher_submissions: unable to get submission

by Vernellia Randall -

I just had the same problem.  I found the fixed i tracker. Here is what I did. it didn't correct the problem what did I do wrong.

/********************************delete orphan submissions******************/

delete_records("workshop_assessments", "submissionid", $submission->id);
move out of the cicle:
if ($assessments = workshop_get_assessments($submission, 'ALL')) {
}

Average of ratings: -
In reply to Vernellia Randall

Re: workshop_list_teacher_submissions: unable to get submission

by David Mudrák -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
Hi Vernellia,

I guess you are talking about MDL-7218. Can you please check what Moodle version do you use? Please provide both version number and the build number (see the footer of the Site Administration main page to get these values).

This was fixed in November and the upgrade code should automatically clean up the database. The clean-up is necessary to avoid the current bugs. The fix in the source code just prevents from this issue to appear again.
Average of ratings: -
In reply to David Mudrák

Re: workshop_list_teacher_submissions: unable to get submission

by Vernellia Randall -

My versionMoodle 1.9.5+ (Build: 20090722)

I didn't get around to upgrading the over the holidays and classes have started so I probably won't be able to do anything until april. I think I kow what triggered the problem because I had a similar problem last year.

I used self-assessment. I put up the example to assess after the close of the submission but before the opening of assessment period. However, in both cases, a student had done a self- assessment BEFORE the example went.

Last semester I stopped using self-assessment because of that problem.

Can you see  that in 2.0 Students won't be able to do anything  after the close of submission and before the assessment period is closed?

Average of ratings: -
In reply to Vernellia Randall

Re: workshop_list_teacher_submissions: unable to get submission

by David Mudrák -
Picture of Core developers Picture of Documentation writers Picture of Moodle HQ Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers Picture of Plugins guardians Picture of Testers Picture of Translators
Ah, that explains. You will have to upgrade to the recent Moodle 1.9.x to have this fixed.

In Moodle 2.0, teachers can switch workshop into so called set-up phase where students can not do anything. Also, even if the workshop is in submission phase or assessment phase but it is before/after the deadlines defined in Access control part of the activity settings, students can not do anything.
Average of ratings: -