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

I was not able to view submitted assignments in my course CIT2012C, Exercise C British English, Exercise C American English

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Duplicate
    • Affects Version/s: 2.0.10
    • Fix Version/s: None
    • Component/s: Assignment (2.2)
    • Labels:
      None
    • Affected Branches:
      MOODLE_20_STABLE

      Description

      Warning: mysqli::query() [mysqli.query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`iglesia_mdle1`.`s`.`timemarked` - `iglesia_mdle1`.`s`.`timemodified`)' in /home/iglesia/public_html/start/lib/dml/mysqli_native_moodle_database.php on line 758

      Debug info: BIGINT UNSIGNED value is out of range in '(`iglesia_mdle1`.`s`.`timemarked` - `iglesia_mdle1`.`s`.`timemodified`)'
      SELECT u.id,u.picture,u.firstname,u.lastname,u.imagealt,u.email,
      s.id AS submissionid, s.grade, s.submissioncomment,
      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 = 127 WHERE u.id IN (3,780,559,129,356,821,471,849,224,785,786,787,788,789,790,791,793,431,794,795,796,797,798,799,800,801,802,803,804,805,455,661,806,807,667,748,808,809,222,590,700,669,810,811,812,813,814,815,816,328,368,792,547,818,286,269,550,602,819,820,464,822,824,826,827,828,578,837,25,252,825,80,32,845,823,308,75,848,847,850,574,585,247,505) ORDER BY lastname ASC
      [array (
      )]

      Stack trace:
      line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 759 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1301 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 369 of /mod/assignment/type/upload/assignment.class.php: call to assignment_base->submissions()
      line 57 of /mod/assignment/submissions.php: call to assignment_upload->submissions()

        Gliffy Diagrams

          Issue Links

            Activity

            adminwill William Granados created issue -
            adminwill William Granados made changes -
            Field Original Value New Value
            Priority Minor [ 4 ] Blocker [ 1 ]
            damyon Damyon Wiese made changes -
            Assignee Damyon Wiese [ damyon ] moodle.com [ moodle.com ]
            Component/s Assignment (2.2) [ 10052 ]
            Component/s Assignment [ 12131 ]
            salvetore Michael de Raadt made changes -
            Link This issue duplicates MDL-26284 [ MDL-26284 ]
            salvetore Michael de Raadt made changes -
            Status Open [ 1 ] Closed [ 6 ]
            Resolution Duplicate [ 3 ]
            salvetore Michael de Raadt made changes -
            Link This issue duplicates MDL-27638 [ MDL-27638 ]
            salvetore Michael de Raadt made changes -
            Link This issue duplicates MDL-26284 [ MDL-26284 ]

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: