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

mdl_qtype_ordering_options.questionid not found in aggregate or GROUP BY - error when upgrading to 4.5.2 with Microsoft SQL server

XMLWordPrintable

    • MOODLE_404_STABLE, MOODLE_405_STABLE
    • MOODLE_404_STABLE, MOODLE_405_STABLE
    • MDL-84532-404
    • MDL-84532-405
    • MDL-84532-main
    • Hide

      Pre-requisites before applying the patch

      1. Create a Moodle 4.3 instance using Microsoft SQL (I recommend using moodle-docker for an easier configuration)
      2. Install the ordering question type plugin (qtype_ordering)
      3. Create a course.
      4. Create a quiz activity in the course.
      5. In the quiz activity, create one ordering question with 3 draggable items and the following settings:
        • Item selection type = “Select a random subset of items”
        • Size of subset = “All”

      Test

      1. From 4.3, upgrade to Moodle 4.4, 4.5 and 5.0 (main), ensuring that the relevant patches for each version are also applied.
        • confirm that the upgrade is successfully executed without any errors for each version.
      2. After the upgrade is completed, go to quiz activity in the course.
        • (5.0 only) Run the mod_qbank\task\transfer_question_categories ad-hoc task (directly, or via the cron) once the upgrade is completed.
      3. In the quiz, go to Questions and go to the settings (edit) page of the ordering question.
        • confirm that the setting “Size of subset” is set to 3.
      4. Go back to Questions and attempt adding a new Ordering question. In the settings page:
        • confirm that "Size of subset" is preset to 2.
      Show
      Pre-requisites before applying the patch Create a Moodle 4.3 instance using Microsoft SQL (I recommend using moodle-docker for an easier configuration) Install the ordering question type plugin (qtype_ordering) Create a course. Create a quiz activity in the course. In the quiz activity, create one ordering question with 3 draggable items and the following settings: Item selection type = “Select a random subset of items” Size of subset = “All” Test From 4.3, upgrade to Moodle 4.4, 4.5 and 5.0 (main), ensuring that the relevant patches for each version are also applied. confirm that the upgrade is successfully executed without any errors for each version. After the upgrade is completed, go to quiz activity in the course. (5.0 only) Run the mod_qbank\task\transfer_question_categories ad-hoc task (directly, or via the cron) once the upgrade is completed. In the quiz, go to Questions and go to the settings (edit) page of the ordering question. confirm that the setting “Size of subset” is set to 3. Go back to Questions and attempt adding a new Ordering question. In the settings page: confirm that "Size of subset" is preset to 2.
    • Hide

      Code verified against automated checks.

      Checked MDL-84532 using repository: https://github.com/mihailges/moodle.git

      More information about this report

      Built on: Mon Feb 24 10:38:24 AM UTC 2025

      Show
      Code verified against automated checks. Checked MDL-84532 using repository: https://github.com/mihailges/moodle.git MOODLE_404_STABLE (0 errors / 0 warnings) [branch: MDL-84532-404 | CI Job ] MOODLE_405_STABLE (0 errors / 0 warnings) [branch: MDL-84532-405 | CI Job ] main (0 errors / 0 warnings) [branch: MDL-84532-main | CI Job ] More information about this report Built on: Mon Feb 24 10:38:24 AM UTC 2025
    • 3
    • Team Alpha - Sprint 2 I1-2025

      When upgrading a site installed on Microsoft SQL server to Moodle 4.4, there is an error for the qtype_ordering install/upgrade.

      I got this error after taking an upgrade path from 3.5 -> 4.5.2. This is from upgrading specifically from 4.2 -> 4.5.2. I took all of the regular steps before this with no problem and am running into this when I go to finish the upgrade.

      (The query in question is doing GROUP BY id, which works in some, but not all DBs.)

        1. upgrade file - edits.PNG
          154 kB
          Daniel Hackenberg
        2. screenshot-1.png
          172 kB
          Daniel Hackenberg
        3. result_4.png
          57 kB
          Huong Nguyen
        4. result_3.png
          48 kB
          Huong Nguyen

            Geshoski Mihail Geshoski
            dHackenberg Daniel Hackenberg
            Andrew Gosali Andrew Gosali
            Tim Hunt Tim Hunt
            Huong Nguyen Huong Nguyen
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Created:
              Updated:
              Resolved:

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day, 3 hours, 42 minutes
                1d 3h 42m

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