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

DML exception thrown sqlsrv when launching quiz manual grading

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.1
    • Fix Version/s: None
    • Component/s: Quiz
    • Labels:
    • Database:
      Microsoft SQL
    • Testing Instructions:
      Hide

      As a Teacher in your navigation drill down into your Course, Topic, Quiz, Results and then click the Manual Grading link. DML Exception thrown.

      Show
      As a Teacher in your navigation drill down into your Course, Topic, Quiz, Results and then click the Manual Grading link. DML Exception thrown.
    • Workaround:
      Hide

      See description.. safe fix to apply listed

      Show
      See description.. safe fix to apply listed
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      public function load_questions_usages_question_state_summary
      in file ./question/engine/datalib.php

      SQL Server does not seem to like the "summarystate" alias in the GROUP BY clause. Last grouping item being "qas.state" rather than "summarystate" resolves the issue. "summarystate" still needs to be the alias following the case statement to populate the property.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              timhunt Tim Hunt
              Reporter:
              khillvt Kyle Hill
              Participants:
              Component watchers:
              Tim Hunt, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: