[Deploying Sakai] [Building Sakai] Samigo - Annoymous survey issue
Tom Hall
thall at brocku.ca
Thu Aug 25 07:30:45 PDT 2011
Hi karen
Wehn I go to the URL:
http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881311617657500
I get the message:
The assThe assessment you have requested is no longer available. Please
contact your instructor if you have any questions. Click "Continue" to
go to the system login page.
Checking the SAM_PUBLISHEDMETADATA_T table for this alias I get the
following results, which indicate that the same ALIAS exists in multiple
published surveys.
mysql> select * from SAM_PUBLISHEDMETADATA_T where LABEL = 'ALIAS' and
ENTRY = 'b7d73f3d838d02f84979079ff5a725881311617657500';
+----------------------+--------------+-------+-----------------------------------------------+
| ASSESSMENTMETADATAID | ASSESSMENTID | LABEL |
ENTRY |
+----------------------+--------------+-------+-----------------------------------------------+
| 218205 | 4284 | ALIAS |
b7d73f3d838d02f84979079ff5a725881311617657500 |
| 218268 | 4285 | ALIAS |
b7d73f3d838d02f84979079ff5a725881311617657500 |
| 220307 | 4335 | ALIAS |
b7d73f3d838d02f84979079ff5a725881311617657500 |
| 220651 | 4344 | ALIAS |
b7d73f3d838d02f84979079ff5a725881311617657500 |
| 220659 | 4344 | ALIAS |
b7d73f3d838d02f84979079ff5a725881311617657500 |
| 220678 | 4344 | ALIAS |
b7d73f3d838d02f84979079ff5a725881311617657500 |
| 220861 | 4348 | ALIAS |
b7d73f3d838d02f84979079ff5a725881311617657500 |
+----------------------+--------------+-------+-----------------------------------------------+
7 rows in set (0.10 sec)
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.
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
> <mailto:thall at brocku.ca>> wrote:
>
> Hi Karen
>
> One of the URLs is
> http://lms.brocku.ca/samigo-app/servlet/Login?id=b7d73f3d838d02f84979079ff5a725881313965482863
> where 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
>> <mailto: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
>> <mailto: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
>> <mailto: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/20110825/015ef242/attachment-0001.html
More information about the production
mailing list