[Deploying Sakai] [Building Sakai] Samigo - Annoymous survey issue
Karen Tsao
ktsao at stanford.edu
Wed Aug 24 11:48:33 PDT 2011
Hi Tom,
The table you look for should be SAM_PUBLISHEDMETADATA_T not
SAM_ASSESSMETADATA_T. But I am still not sure what goes wrong here... If you
have a certain URL that doesn't work, can you try to query
SAM_PUBLISHEDMETADATA_T using that ALIAS and see if that record exists?
Also, if your support people can reproduce this, can you ask them for the
step by step instruction? That would help me a lot.
Thanks,
Karen
On Wed, Aug 24, 2011 at 6:20 AM, Tom Hall <thall at brocku.ca> wrote:
> Hi Karen
>
> One of the URLs is
> http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881313965482863where the md5 hash corresponds to the LABEL value in the metadata. The
> sample queries (for the same survey) below have multiple label values
> associated with them. Users are reporting that some URLs work and others
> don't. I haven't seen this myself but the folks that provide faculty
> support have seen it.
>
> Tom
>
>
>
> On 8/23/2011 4:57 PM, Karen Tsao wrote:
>
> Hi Tom,
>
> I don't quite understand your issue. Do you mean the id in the following
> URL?
>
>
> http://localhost:8080/samigo-app/servlet/Login?id=a1545c12-bfa2-449c-bd3a-fc5b23a75b30131413288.
> ..
>
> That is not related to the metadata id you selected from the database. Can
> you please explain more or give me some examples?
>
> Thanks,
> Karen
>
> On Tue, Aug 23, 2011 at 11:21 AM, Tom Hall <thall at brocku.ca> wrote:
>
> Hi Everyone
>
> We have just come across an issue in Samigo when using anonymous surveys
> (don't know about other forms of tests/surveys). It has been reported
> to me that the id parameter in the URL for the anonymous survey is
> changing. When I did a check in the database I see the following for
> one of the surveys for which this behavior has been observed.
>
>
> ----------------------+--------------+------------------------------------------------+-----------------------------------------------+
> | ASSESSMENTMETADATAID | ASSESSMENTID |
> LABEL |
> ENTRY |
>
> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
> | 220845 | 4348 |
> itemAccessType_isInstructorEditable |
> true |
> | 220846 | 4348 |
> finalPageURL_isInstructorEditable |
> true |
> | 220847 | 4348 |
> submissionModel_isInstructorEditable |
> true |
> | 220848 | 4348 |
> anonymousRelease_isInstructorEditable |
> true |
> | 220849 | 4348 |
> dueDate_isInstructorEditable |
> true |
> | 220850 | 4348 |
> releaseTo |
> SITE_MEMBERS |
> | 220851 | 4348 |
> displayChunking_isInstructorEditable |
> true |
> | 220852 | 4348 |
> passwordRequired_isInstructorEditable |
> true |
> | 220853 | 4348 |
> testeeIdentity_isInstructorEditable |
> true |
> | 220854 | 4348 |
> bgColor_isInstructorEditable |
> true |
> | 220855 | 4348 |
> releaseDate_isInstructorEditable |
> true |
> | 220856 | 4348 |
> timedAssessmentAutoSubmit_isInstructorEditable |
> true |
> | 220857 | 4348 |
> metadataQuestions_isInstructorEditable |
> true |
> | 220858 | 4348 |
> ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965489462 |
> | 220859 | 4348 |
> feedbackAuthoring_isInstructorEditable |
> true |
> | 220860 | 4348 |
> feedbackType_isInstructorEditable |
> true |
> | 220861 | 4348 |
> ALIAS |
> b7d73f3d838d02f84979079ff5a725881311617657500 |
> | 220862 | 4348 |
> assessmentAuthor_isInstructorEditable |
> true |
> | 220863 | 4348 |
> description_isInstructorEditable |
> true |
> | 220864 | 4348 |
> ipAccessType_isInstructorEditable |
> true |
> | 220865 | 4348 |
> submissionMessage_isInstructorEditable |
> true |
> | 220866 | 4348 |
> metadataAssess_isInstructorEditable |
> true |
> | 220867 | 4348 |
> templateInfo_isInstructorEditable |
> true |
> | 220868 | 4348 |
> hasTimeAssessment |
> false |
> | 220869 | 4348 |
> authenticatedRelease_isInstructorEditable |
> true |
> | 220870 | 4348 |
> feedbackComponents_isInstructorEditable |
> true |
> | 220871 | 4348 |
> bgImage_isInstructorEditable |
> true |
> | 220872 | 4348 |
> recordedScore_isInstructorEditable |
> true |
> | 220873 | 4348 |
> author
> | |
> | 220874 | 4348 |
> lateHandling_isInstructorEditable |
> true |
> | 220875 | 4348 |
> toGradebook_isInstructorEditable |
> true |
> | 220876 | 4348 |
> displayNumbering_isInstructorEditable |
> true |
> | 220877 | 4348 |
> ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965477231 |
> | 220878 | 4348 |
> hasMetaDataForQuestions |
> false |
> | 220879 | 4348 |
> retractDate_isInstructorEditable |
> true |
> | 220880 | 4348 |
> timedAssessment_isInstructorEditable |
> true |
> | 220881 | 4348 |
> ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965482863 |
>
> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
> 37 rows in set (0.00 sec)
>
>
> mysql> select * from SAM_ASSESSMETADATA_T where ASSESSMENTID = '2751';
>
> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
> | ASSESSMENTMETADATAID | ASSESSMENTID |
> LABEL |
> ENTRY |
>
> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
> | 153484 | 2751 |
> assessmentAuthor_isInstructorEditable |
> true |
> | 153485 | 2751 |
> submissionModel_isInstructorEditable |
> true |
> | 153486 | 2751 |
> submissionMessage_isInstructorEditable |
> true |
> | 153487 | 2751 |
> retractDate_isInstructorEditable |
> true |
> | 153488 | 2751 |
> ipAccessType_isInstructorEditable |
> true |
> | 153489 | 2751 |
> displayChunking_isInstructorEditable |
> true |
> | 153490 | 2751 |
> metadataAssess_isInstructorEditable |
> true |
> | 153491 | 2751 |
> bgColor_isInstructorEditable |
> true |
> | 153492 | 2751 |
> bgImage_isInstructorEditable |
> true |
> | 153493 | 2751 |
> displayNumbering_isInstructorEditable |
> true |
> | 153494 | 2751 |
> timedAssessment_isInstructorEditable |
> true |
> | 153495 | 2751 |
> author
> | |
> | 153496 | 2751 |
> authenticatedRelease_isInstructorEditable |
> true |
> | 153497 | 2751 |
> releaseTo |
> SITE_MEMBERS |
> | 153498 | 2751 |
> feedbackComponents_isInstructorEditable |
> true |
> | 153499 | 2751 |
> recordedScore_isInstructorEditable |
> true |
> | 153500 | 2751 |
> dueDate_isInstructorEditable |
> true |
> | 153501 | 2751 |
> ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965477231 |
> | 153502 | 2751 |
> testeeIdentity_isInstructorEditable |
> true |
> | 153503 | 2751 |
> feedbackType_isInstructorEditable |
> true |
> | 153504 | 2751 |
> timedAssessmentAutoSubmit_isInstructorEditable |
> true |
> | 153505 | 2751 |
> ALIAS |
> b7d73f3d838d02f84979079ff5a725881311617657500 |
> | 153506 | 2751 |
> itemAccessType_isInstructorEditable |
> true |
> | 153507 | 2751 |
> anonymousRelease_isInstructorEditable |
> true |
> | 153508 | 2751 |
> metadataQuestions_isInstructorEditable |
> true |
> | 153509 | 2751 |
> hasMetaDataForQuestions |
> false |
> | 153510 | 2751 |
> templateInfo_isInstructorEditable |
> true |
> | 153511 | 2751 |
> finalPageURL_isInstructorEditable |
> true |
> | 153512 | 2751 |
> passwordRequired_isInstructorEditable |
> true |
> | 153513 | 2751 |
> hasTimeAssessment |
> false |
> | 153514 | 2751 |
> lateHandling_isInstructorEditable |
> true |
> | 153515 | 2751 |
> description_isInstructorEditable |
> true |
> | 153516 | 2751 |
> feedbackAuthoring_isInstructorEditable |
> true |
> | 153517 | 2751 |
> toGradebook_isInstructorEditable |
> true |
> | 153518 | 2751 |
> releaseDate_isInstructorEditable |
> true |
>
> +----------------------+--------------+------------------------------------------------+-----------------------------------------------+
> 35 rows in set (0.00 sec)
>
>
> This is leading to confusion for the survey takers.
>
> Does anyone know if this is the expected behavior or is there a problem?
>
> Thanks
>
> Tom
>
>
> _______________________________________________
> 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/production/attachments/20110824/5a019de9/attachment-0001.html
More information about the production
mailing list