Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-44276

Samigo - two different published assessments have identical Published Assessment URLs

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: OPEN
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 12.7
    • Fix Version/s: None
    • Labels:
      None

      Description

      Samigo - two different published assessments have identical Published Assessment URLs

      We don't know how this happened but we found it because an instructor created a Lesson page link to a Samigo T&Q quiz, but when users clicked on the link it was sending them to the wrong quiz.

      We found that the Published Assessment URLs for each assessment were both set to e.g.

      https://<sakai.domain>/samigo-app/servlet/Login?id=12345678-aaba-cccc-dddd-1234567890123456789012345

      and checking the database, the urls are generated from the metadata "alias"

      mysql> select * from sam_publishedmetadata_t where label = 'ALIAS' and assessmentid = 444444;
      +----------------------+--------------+-------+---------------------------------------------------+
      | ASSESSMENTMETADATAID | ASSESSMENTID | LABEL | ENTRY |
      +----------------------+--------------+-------+---------------------------------------------------+
      | 22222222 | 444444 | ALIAS | 12345678-aaba-cccc-dddd-1234567890123456789012345 |
      +----------------------+--------------+-------+---------------------------------------------------+
      1 row in set (0.04 sec)
      
      mysql> select * from sam_publishedmetadata_t where label = 'ALIAS' and assessmentid = 555555;
      +----------------------+--------------+-------+---------------------------------------------------+
      | ASSESSMENTMETADATAID | ASSESSMENTID | LABEL | ENTRY |
      +----------------------+--------------+-------+---------------------------------------------------+
      | 33333333 | 555555 | ALIAS | 12345678-aaba-cccc-dddd-1234567890123456789012345 |
      +----------------------+--------------+-------+---------------------------------------------------+
      1 row in set (0.02 sec)
      

        Gliffy Diagrams

          Zeplin

            Attachments

              Issue Links

                Activity

                  People

                  Assignee:
                  maintenanceteam Core Team
                  Reporter:
                  austinUH Austin
                  Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                    Dates

                    Created:
                    Updated:

                      Git Integration