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
    • Affected Branches:
      MOODLE_19_STABLE
    • Fixed Branches:
      MOODLE_19_STABLE
    • Pull from Repository:
    • 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.

      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

          has been marked as being related by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-26416 Intermittent error from the quiz reports on MySQL because of subtracting two unsigned columns

          • Critical - Crashes server, loss of data, severe memory leak
          • Closed
          is duplicated by

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-29735 Unable to view assignment and quiz submission results

          • Major - Major loss of function, incorrect output
          • Closed

            Activity

              People

              Assignee:
              timhunt Tim Hunt
              Reporter:
              jdpark7 Jong-D Park
              Peer reviewer:
              Tim Hunt Tim Hunt
              Integrator:
              Eloy Lafuente (stronk7) Eloy Lafuente (stronk7)
              Tester:
              David Mudrák (@mudrd8mz) David Mudrák (@mudrd8mz)
              Participants:
              Component watchers:
              Tim Hunt, Andrew Lyons, Dongsheng Cai, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

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