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

Unpick quiz.questions DB column

XMLWordPrintable

    • Icon: Improvement Improvement
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 2.7
    • 2.6.1
    • Quiz
    • MOODLE_26_STABLE
    • MOODLE_27_STABLE
    • 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 .

      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) 
      

            timhunt Tim Hunt
            timhunt Tim Hunt
            Eric Merrill Eric Merrill
            Dan Poltawski Dan Poltawski
            Rajesh Taneja Rajesh Taneja
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.