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 Bug
    • Status: Closed
    • Priority: Blocker 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
    • Rank:
      41289

      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()

        Issue Links

          Activity

          Hide
          Michael de Raadt added a comment -

          Hi, William.

          I'm not sure if you're teacher or admin.

          This error comes about after a MySQL upgrade. This was resolved in Moodle about a year ago now. Updating your Moodle instance should resolve your problem.

          This is duplicate report number 12 for this issue. Please search for existing issues before reporting new ones.

          Show
          Michael de Raadt added a comment - Hi, William. I'm not sure if you're teacher or admin. This error comes about after a MySQL upgrade. This was resolved in Moodle about a year ago now. Updating your Moodle instance should resolve your problem. This is duplicate report number 12 for this issue. Please search for existing issues before reporting new ones.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: