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

dmlreadexception when teacher tries to view uploaded assignments using "View 1 submitted assignments" link

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.0.3
    • Fix Version/s: None
    • Component/s: Assignment (2.2)
    • Labels:
      None
    • Environment:
      OS: Windows 7 Home Premium
      Web Server: Apache 2.2
      PHP: 5.2.17
      Database: MySQL 5.5.11
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      If a student uploads a file (in this case a PDF), and the teacher attempts to view it, an error is thrown. However, if the teacher elects to zip all files, then the file is packaged in the zip and can be displayed.

      Debug info:

      Warning: mysqli::query() [mysqli.query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`moodle`.`s`.`timemarked` - `moodle`.`s`.`timemodified`)' in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\moodle\lib\dml\mysqli_native_moodle_database.php on line 789
      Error reading from database

      More information about this error

      Debug info: BIGINT UNSIGNED value is out of range in '(`moodle`.`s`.`timemarked` - `moodle`.`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 = 22 WHERE u.id IN (14,13) ORDER BY lastname ASC
      [array (
      )]
      Stack trace:
      line 391 of \lib\dml\moodle_database.php: dml_read_exception thrown
      line 790 of \lib\dml\mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1303 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:
              q99 Casey Snyder
              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: