Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-43749

Unpick quiz.questions DB column

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.6.1
    • Fix Version/s: 2.7
    • Component/s: Quiz
    • Labels:
    • Testing Instructions:
      Hide

      Note to testers: A lot of the code changed by this patch is going to be changed again as part of the epic MDL-40987, so really, too much detailed testing now is probably not the best use of your time.

      Note, on the order and paging tab, if you have a random question, clicking on the up or down arrows does not work. This is some sort of CSS bug, which will become irrelevant once MDL-40987 is done, so don't bother to report that.

      1. As teacher/admin, create a new course and add a quiz.
      2. On the edit quiz page, Edit quiz tab, make sure all the controls (icons, links and buttons) work. (Remember to expand the question bank.)
      3. Same, but on the Order & paging tab.
      4. When you finish checking all the buttons and icons, ensure you have left yourself with a working quiz, because you will need it for the next steps.
      5. Now preview the quiz.
      6. As student, attempt the quiz.
      7. Back as teacher/admin, have a quick look through all the quiz reports.
      8. Backup the course and restore it as a new course. Ensure that the quizzes have been transferred accurately.
      9. Get a backup including quizzesw with user data from a 2.6 site. Restore it, and ensure the quizzes have been restored accurately.
      10. Get a backup including quizzes with user data from a 2.0 site. Restore it, and ensure the quizzes have been restored accurately.
      11. Get a backup including quizzes from a 1.9 site. Restore it, and ensure the quizzes have been restored accurately. (1.9 restore cannot include user data.)

      For 10, you could use the backup file from MDL-44053, but I have already tested that.

      For 11, I used the backup attached tto MDL-27811.

      Show
      Note to testers: A lot of the code changed by this patch is going to be changed again as part of the epic MDL-40987 , so really, too much detailed testing now is probably not the best use of your time. Note, on the order and paging tab, if you have a random question, clicking on the up or down arrows does not work. This is some sort of CSS bug, which will become irrelevant once MDL-40987 is done, so don't bother to report that. 1. As teacher/admin, create a new course and add a quiz. 2. On the edit quiz page, Edit quiz tab, make sure all the controls (icons, links and buttons) work. (Remember to expand the question bank.) 3. Same, but on the Order & paging tab. 4. When you finish checking all the buttons and icons, ensure you have left yourself with a working quiz, because you will need it for the next steps. 5. Now preview the quiz. 6. As student, attempt the quiz. 7. Back as teacher/admin, have a quick look through all the quiz reports. 8. Backup the course and restore it as a new course. Ensure that the quizzes have been transferred accurately. 9. Get a backup including quizzesw with user data from a 2.6 site. Restore it, and ensure the quizzes have been restored accurately. 10. Get a backup including quizzes with user data from a 2.0 site. Restore it, and ensure the quizzes have been restored accurately. 11. Get a backup including quizzes from a 1.9 site. Restore it, and ensure the quizzes have been restored accurately. (1.9 restore cannot include user data.) For 10, you could use the backup file from MDL-44053 , but I have already tested that. For 11, I used the backup attached tto MDL-27811 .
    • Affected Branches:
      MOODLE_26_STABLE
    • Fixed Branches:
      MOODLE_27_STABLE
    • Pull from Repository:
    • Pull Master Branch:

      Description

      This is transform 2 of https://gist.github.com/timhunt/7342412

      TRANSFORM 2 - eliminate mdl_quiz.questions & rename question_instances -> slots
       
      mdl_quiz
      id SEQUENCE
      ...
      questionsperpage INT(10)
      navmethod CHAR(16) 'free' or 'seq'
      shufflequestions BOOL
      -
      ...
       
      *mdl_quiz_slots
      id SEQUENCE
      quizid INT(10) FK
      + slot INT(10) Similar to question_attempt.slot
      + page INT(10) All slots on a page must have consecutive numbers. Page numbers must be increasing.
      questionid INT(10) FK
      maxmark NUMBER(12.7) 
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  12/May/14