[#MDL-20668] Under certain circumstances workshop_get_user_assessments may fail

Issue Details (XML | Word | Printable)

Key:	MDL-20668
Type:	Bug
Status:	Resolved
Resolution:	Duplicate
Priority:	Blocker
Assignee:	David Mudrak
Reporter:	Andrea Bicciolo
Votes:	0
Watchers:	1

Operations

Add/Edit UI Mockup to this issue

If you were logged in you would be able to see more operations.

Moodle

Under certain circumstances workshop_get_user_assessments may fail

Created: 29/Oct/09 09:18 PM Updated: 12/Nov/09 07:47 PM

Component/s:

Workshop

Affects Version/s:

1.9.6

Fix Version/s:

1.9.7

Issue Links:

Duplicate

This issue duplicates:

~~MDL-7218~~ workshop_list_student_submissions: unable to get submission

Database:	MySQL
Participants:	Andrea Bicciolo and David Mudrak
Security Level:	None
Difficulty:	Moderate
Resolved date:	12/Nov/09
Affected Branches:	MOODLE_19_STABLE
Fixed Branches:	MOODLE_19_STABLE

Description

« Hide

When a student access a workshop in view, under certain circumstances (that are still under investigation and not always reproducible) get the following error:

workshop_list_student_submissions: unable to get submission

Trying to identify the problem we displayed submission id and user id as follows:

workshop_list_student_submissions: unable to get submission id 694 for user 5709

According to db tables, submission id 694 should not be retrived for this student, thus the error.

Problem appears only for some students, while others does not suffer the issue on the same workshop.

All

Comments

Change History

Version Control

Sort Order:

[ Permalink | « Hide ]

David Mudrak added a comment - 30/Oct/09 03:46 PM

This looks similar to ~~MDL-7218~~. Any chances the solution described there could help your issue?

[ Permalink | « Hide ]

David Mudrak added a comment - 12/Nov/09 06:17 PM

Andrea, does it mean that the user 5709 is neither author nor the reviewer of the submission 694? Can you try to run the following two queries and report the results?

SELECT * FROM mdl_workshop_assessments WHERE submissionid=694 AND userid=5709

and

SELECT * FROM mdl_workshop_submissions WHERE id=694 AND userid=5709

[ Permalink | « Hide ]

Andrea Bicciolo added a comment - 12/Nov/09 06:48 PM

First query:
"id";"workshopid";"submissionid";"userid";"timecreated";"timegraded";"timeagreed";"grade";"gradinggrade";"teachergraded";"mailed";"resubmission";"donotuse";"generalcomment";"teachercomment"
"1069";"152";"694";"5709";"1288311708";"0";"0";"-1";"0";"0";"0";"0";"0";;

Second query:
no record returned

[ Permalink | « Hide ]

David Mudrak added a comment - 12/Nov/09 07:19 PM

OK, so we know the user is reviewer of the submission - it was allocated to him to assess. Now please run the following and report the results please

SELECT * FROM mdl_workshop_submissions WHERE id=694

[ Permalink | « Hide ]

Andrea Bicciolo added a comment - 12/Nov/09 07:29 PM

This third query returned no record.

[ Permalink | « Hide ]

David Mudrak added a comment - 12/Nov/09 07:45 PM

OK, here we go. It is a known problem with inconsistent database state. The student experiencing the error message is expected to assess a submission that was deleted. This is obvious clone of ~~MDL-7218~~. I am going to fix that one. Let us continue the discussion there.

[ Permalink | « Hide ]

David Mudrak added a comment - 12/Nov/09 07:47 PM

Closing this issue as duplicate of ~~MDL-7218~~. I am going to work on this nasty thing.

All content on this web site is made available under the GNU General Public License, unless otherwise stated.