[Building Sakai] Samigo resubmit

[Karen Tsao]

Hi Jeremy,

To recover the data, please run the following query:

UPDATE sam_assessmentgrading_t ag, sam_publishedassessment_t pa,
sam_authzdata_t a, sakai_site s
SET forgrade = 1
WHERE ag.publishedassessmentid = pa.id
AND a.agentid = s.site_id
AND a.qualifierid = pa.id
AND a.functionid = 'GRADE_PUBLISHED_ASSESSMENT'
AND s.title = :site_title
AND pa.title = :assessment_title

Please let me know if your issue cannot get resolved by the above query.

Thanks,
Karen


On Mon, Nov 29, 2010 at 4:19 PM, Kusnetz, Jeremy <JKusnetz at apus.edu> wrote:

> We had a similar issue to the following Jira:
>
> http://jira.sakaiproject.org/browse/SAM-892
>
> The instructor accidentally edited an exam that all the student's
> completed, which retracted the exam.  They went to republish the exam, and
> now Sakai doesn't show the link to "Scores", and all the scores in gradebook
> are gone.
>
> I've looked at the SAM tables and I can see the student scores and even
> answer submissions, but I can't figure out what I need to change in the
> database so that their scores come back to the interface.
> This message is private and confidential. If you have received it in error,
> please notify the sender and remove it from your system.
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20101129/466602b7/attachment.html