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

Error from the quiz participation reports on MySQL because of subtracting two unsigned columns

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 2.0
    • 2.0.3
    • Quiz
    • None
    • Windows; MySQL 5.5.9;
    • MySQL
    • MOODLE_20_STABLE
    • MOODLE_20_STABLE
    • Easy

    Description

      Same problem as http://tracker.moodle.org/browse/MDL-26416, except the error occurs in the "Response" section of the quiz results.

      Debug info: BIGINT UNSIGNED value is out of range in '(`xxx`.`qa`.`timefinish` - `xxx`.`qa`.`timestart`)'
      SELECT CONCAT(u.id, '#', COALESCE(qa.attempt, 0)) AS concattedid, qa.uniqueid, qa.id AS attempt, u.id AS userid, u.idnumber, u.firstname, u.lastname, u.institution, u.department, u.email, u.picture, u.imagealt, qa.sumgrades, qa.timefinish, qa.timestart, qa.timefinish - qa.timestart AS duration, qa.layout FROM mdl_user u LEFT JOIN mdl_quiz_attempts qa ON qa.userid = u.id AND qa.quiz = ? WHERE qa.id IS NOT NULL AND qa.preview = 0 ORDER BY concattedid ASC LIMIT 0, 30

      Attachments

        Issue Links

          Activity

            People

              timhunt Tim Hunt
              twilhelm Travis Wilhelm
              Aparup Banerjee Aparup Banerjee
              Tim Hunt, Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                5/May/11