[Building Sakai] Samigo - Annoymous survey issue
Karen Tsao
ktsao at stanford.edu
Fri Aug 26 15:16:13 PDT 2011
I saw your query looks for four assessments. Can you please give me the
published assessment id and assessments name pair?
Thanks,
Karen
On Fri, Aug 26, 2011 at 7:43 AM, Tom Hall <thall at brocku.ca> wrote:
> Hi Karen
>
> I have attached the file survey_events.txt. It contains the sequence of
> events as best Matt and Mike in CTLET can rember and the results of two
> queries over out SAKAI_EVENTS table. These query results come from two
> different copies (non-overlapping) of the table, so please go by the
> timestamps not the id numbers (I cleared the table when I did a DB hardware
> migration earlier this month).
>
> Thanks again for your help
>
> Tom
>
>
>
> On 8/25/2011 2:30 PM, Karen Tsao wrote:
>
> Hi Tom,
>
> From your records, sounds like there is a bug somewhere. However, I
> couldn't reproduce these duplicates by copying the assessments. Can you get
> more information to help me to reproduce them? For example, what actions the
> instructors have performed on these assessments.
>
>
> I then followed the foreign key in the SAM_PUBLISHEDMETADATA_T table to
> the SAM_PUBLISHEDASSESSMENT_T table and got the following results. They
> indicate that the same ALIAS value is used in multiple sites, with varying
> status values. When I checked with the folks who maintain the site with
> these assessments in it, they tell me that they copied one assessment to
> create the others. It looks to me like the assessment copy operation is
> copying aliases along with all of the other data, which to me doesn't make a
> lot of sense.
>
> The copy action only copies working copies. That is, the data only gets
> copied into SAM_ASSESSMETADATA_T. The aliases in SAM_PUBLISHEDASSESSMENT_T
> is created during publish. So even if they are copied into
> SAM_ASSESSMETADATA_T, you should have the different values in
> SAM_PUBLISHEDASSESSMENT_T. Also, from your example assessment id 4348, there
> are two records in SAM_PUBLISHEDASSESSMENT_T:
>
> | 220858 | 4348 | ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965489462 |
> | 220861 | 4348 | ALIAS |
> b7d73f3d838d02f84979079ff5a725881311617657500 |
>
> The second record is the invalid/duplicate alias and you can see its
> ASSESSMENTMETADATAID is after the first record. That means the first one is
> created during publish and it is an unique alias (I can access it through
> http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881313965489462<http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881311617657500>?).
> And then the second invalid/duplicate one is created at a later point. I
> don't know how the second record got created. Can you ask if the instructors
> modified these published assessments in some way after they published them?
>
> This sounds like a bug in a certain flow. If you can get the navigation
> history from instructors, that will help me to figure out the problem.
>
> Thanks,
> Karen
>
>
>
> mysql> select ID, TITLE, STATUS, LASTMODIFIEDDATE from
> SAM_PUBLISHEDASSESSMENT_T where ID in (4284, 4285, 4335, 4344, 4348);
>
> +------+----------------------------------------------------------------+--------+---------------------+
> | ID | TITLE |
> STATUS | LASTMODIFIEDDATE |
>
> +------+----------------------------------------------------------------+--------+---------------------+
> | 4284 | ADED Online Course Evaluation - SAMPLE - Modified for ADED1P31
> | 2 | 2011-07-25 14:35:32 |
> | 4285 | ADED Online Course Evaluation - SAMPLE - Modified for ADED1P31
> | 2 | 2011-07-25 14:57:23 |
> | 4335 | ADED Online Course Evaluation ADED1P31
> | 2 | 2011-08-17 13:27:28 |
> | 4344 | ADED Online Course Evaluation ADED1P31
> | 1 | 2011-08-21 18:23:58 |
> | 4348 | ADED Online Course Evaluation ADED1P31 - Copy #1
> | 1 | 2011-08-21 18:24:49 |
> +------+----------------------------------------------------------------+--------+---------------------+
>
>
> 5 rows in set (0.00 sec)
>
>
> When I checked one of the working URLs, the result was:
>
>
> mysql> select * from SAM_PUBLISHEDMETADATA_T where LABEL = 'ALIAS' and
> ENTRY = 'b7d73f3d838d02f84979079ff5a725881313965489462';
>
> +----------------------+--------------+-------+-----------------------------------------------+
> | ASSESSMENTMETADATAID | ASSESSMENTID | LABEL |
> ENTRY |
>
> +----------------------+--------------+-------+-----------------------------------------------+
> | 220858 | 4348 | ALIAS |
> b7d73f3d838d02f84979079ff5a725881313965489462 |
>
> +----------------------+--------------+-------+-----------------------------------------------+
> 1 row in set (0.08 sec)
>
>
> I don't currently have a on-line instance of our 2.7.1 installation
> available to me, but a check of the database shows that we did have
> duplicate ALIAS values there, but I had no reports of problems prior to 2.8.
>
> Tom
>
>
>
> On 8/24/2011 2:48 PM, Karen Tsao wrote:
>
> 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/sakai-dev/attachments/20110826/d117b85a/attachment.html
More information about the sakai-dev
mailing list