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

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

    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.

        Gliffy Diagrams

          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