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

Database Error - BIGINT UNSIGNED value

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.1
    • Fix Version/s: None
    • Component/s: Assignment (2.2)
    • Labels:
      None
    • Workaround:
      Hide

      I'm stuck.

      Show
      I'm stuck.
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      Debug info: BIGINT UNSIGNED value is out of range in '(`moodledb`.`s`.`timemarked` - `moodledb`.`s`.`timemodified`)'
      SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email,
      s.id AS submissionid, s.grade, s.submissioncomment,
      s.timemodified, s.timemarked,
      COALESCE(SIGN(SIGN(s.timemarked) + SIGN(s.timemarked - s.timemodified)), 0) AS status FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid
      AND s.assignment = 26 WHERE u.id IN (7,8,9,10,11,21,22,23,24,25,26,27,28,29,30) ORDER BY lastname ASC
      [array (
      )]
      Stack trace:
      line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
      line 794 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1295 of \mod\assignment\lib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 642 of \mod\assignment\lib.php: call to assignment_base->display_submissions()
      line 57 of \mod\assignment\submissions.php: call to assignment_base->submissions()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              moodle.com moodle.com
              Reporter:
              michellerightler Michelle Rightler
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: