Uploaded image for project: 'LAMS Development'
  1. LAMS Development
  2. LDEV-2805

On update from 2.3.5, an assessment activity does not display questions in learner

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.4
    • Fix Version/s: 2.4
    • Component/s: Tool Assessment
    • Labels:
      None

      Description

      Andrey, while upgrading some of our servers I discover something rather tricky with assessment tool which I think the issue here has to do with the introduction of question pools.

      This is the scenario:

      On a 2.3.5 server, I created an assessment with 3 questions. As there's no question pool for 2.3.5, then all the questions are asked to the students when you create a lesson.

      Now the problem here is that when you upgrade to 2.4, if you go back to the lesson where the assessment was, there's completely *no* questions displayed to the student and previous answers aren't being displayed.

      So I think there's something we need to do to fix this ASAP as otherwise questions from previous 2.3.5 version are simply gone.

      Note that if I have a look at the question in AUthoring, I can see the questions as part of the pool. But as they aren't in the actual test.... and I think that's what it's happening here.

      So to fix this, I think we need a script that essentially makes *all* available questions in previous assessment activities part of the questions in the list.

      Probably an sql statement will do?

        Activity

        Hide
        dronych Andrey Balan added a comment -
        I added required SQL command to existing autopatch script.
        However, for servers that have been already upgraded to 2.4 you'll need to run the following command manually:

        INSERT INTO tl_laasse10_question_reference ( question_uid , question_type , title, sequence_id, default_grade, random_question, assessment_uid ) select uid , question_type , title, sequence_id, default_grade, 0, assessment_uid from tl_laasse10_assessment_question;
        Show
        dronych Andrey Balan added a comment - I added required SQL command to existing autopatch script. However, for servers that have been already upgraded to 2.4 you'll need to run the following command manually: INSERT INTO tl_laasse10_question_reference ( question_uid , question_type , title, sequence_id, default_grade, random_question, assessment_uid ) select uid , question_type , title, sequence_id, default_grade, 0, assessment_uid from tl_laasse10_assessment_question;
        Hide
        ernieg Ernie Ghiglione added a comment -
        Thanks Andrey, this fixed things.
        Show
        ernieg Ernie Ghiglione added a comment - Thanks Andrey, this fixed things.

          People

          • Assignee:
            dronych Andrey Balan
            Reporter:
            ernieg Ernie Ghiglione
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development