[Using Sakai] problem with assignment submission

[Anders Nordkvist]

Hi to you all,

Sakai 2.9.x
A few of our teachers have a problem with a student submission in assignment tool. This is the assignment collected from the database assignment_submission table. The problem is that the student claims that he has gotten a returned submission with a grade. If you look below you can see that the submission have been turned in 20151501 and returned 201502190842 but when I check all the 4 instructors who have permission to do this (maintain) in the sakai_event table no one of them have been in there. Isnt that strange? This was my question to the Sakai_Event table and I did it for all four instructors:

select * from sakai_event where EVENT_DATE like '%2015-02-19 08:%' and REF like '%b9533ec2-5640-47bf-9553-c778b64815dd%';


'7eb424cd-9b2d-47f1-858e-ec8562f2eb0d', '94ca6062-2621-4fbe-a575-1dcbefd005d5', 'c1b83f81-4dd0-49d7-8096-1a3ded4aeb2e', '1421329152708', 'true', 'true', '<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<submission assignment=\"94ca6062-2621-4fbe-a575-1dcbefd005d5\" context=\"OM536G-20142-01\" datereturned=\"20150219084207198\" datesubmitted=\"20150115133912708\" feedbackcomment=\"\" feedbackcomment-html=\"\" feedbacktext=\"ICBNdmggw4VzYSBCcm9yc3Nvbg==\" feedbacktext-html=\"PHA+ICBNdmggw4VzYSBCcm9yc3NvbjwvcD4=\" graded=\"true\" gradereleased=\"true\" id=\"7eb424cd-9b2d-47f1-858e-ec8562f2eb0d\" lastmod=\"20150219084207198\" numberoffeedbackattachments=\"0\" numberofsubmittedattachments=\"1\" numberofsubmitters=\"1\" pledgeflag=\"false\" returned=\"true\" reviewError=\"\" reviewReport=\"\" reviewScore=\"\" reviewStatus=\"\" scaled_grade=\"gen.nograd\" submitted=\"true\" submittedattachment0=\"/content/attachment/OM536G-20142-01/Assignments/86db98a3-35b3-4581-8284-aae8dee17b69/xxxx.docx\" submittedtext=\"ICBNdmggw4VzYSBCcm9yc3Nvbg==\" submittedtext-html=\"PHA+ICBNdmggw4VzYSBCcm9yc3NvbjwvcD4=\" submitter0=\"c1b83f81-4dd0-49d7-8096-1a3ded4aeb2e\"><properties><property enc=\"BASE64\" name=\"CHEF:creator\" value=\"ZGRhM2ZmZGItYjE3Mi00MjRkLTk2ODQtODg4YmNlODU0YWIy\"/><property enc=\"BASE64\" name=\"allow_resubmit_closeTime\" value=\"MTQyMTQyMDQwMDAwMA==\"/><property enc=\"BASE64\" name=\"allow_resubmit_number\" value=\"LTE=\"/><property enc=\"BASE64\" name=\"CHEF:modifiedby\" value=\"NGUxOTAyOGYtNGNlZi00YmE5LWIyOGUtYTA2ZTFlOTU3Y2Fh\"/><property enc=\"BASE64\" name=\"DAV:getlastmodified\" value=\"MjAxNTAyMTkwODQyMDcxOTg=\"/><property enc=\"BASE64\" name=\"DAV:creationdate\" value=\"MjAxNDEyMDgxMDUyNTM5MzA=\"/></properties></submission>'


Am I thinking wrong? Can someone please explain this to me?

Regards Anders
University of Skövde
Sweden

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20150219/8b5a0084/attachment-0001.html