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

Intermittent error from the quiz reports on MySQL because of subtracting two unsigned columns

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.11
    • Fix Version/s: 1.9.12
    • Component/s: Quiz
    • Environment:
      mysql 5.5.9, moodle 1.9.11+
    • Database:
      MySQL
    • Testing Instructions:
      Hide

      You need a quiz with some student attempts on an 1.9.x install using MySQL > 5.5.5. Make sure you can go to the quiz overview report without errors, and that the durations are displayed correctly.

      It would be good to also test an install using the minimum version of MySQL that Moodle 1.9 is meant to support.

      Show
      You need a quiz with some student attempts on an 1.9.x install using MySQL > 5.5.5. Make sure you can go to the quiz overview report without errors, and that the durations are displayed correctly. It would be good to also test an install using the minimum version of MySQL that Moodle 1.9 is meant to support.
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE
    • Pull from Repository:

      Description

      I am using mysql 5.5.9. I found that same issue was discussed
      at http://tracker.moodle.org/browse/MDL-26416, but for moodle 1.9.11+.
      The solution seems to be posted at https://github.com/moodle/moodle/blob/master/mod/quiz/report/overview/report.php#L210.

      I wonder the patch will be available for moodle 1.9.11+ soon.

      Thanks.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  10/May/11