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

I am not able to see submitted assignments

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.0.3
    • Assignment (2.2)
    • None
    • Mac OSx on both firefox and chrome
    • MOODLE_20_STABLE
    • Hide

      Warning: mysqli::query() [mysqli.query]: (22003/1690): BIGINT UNSIGNED value is out of range in '(`qrm3leoq`.`s`.`timemarked` - `qrm3leoq`.`s`.`timemodified`)' in /var/www/ktm/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 '(`qrm3leoq`.`s`.`timemarked` - `qrm3leoq`.`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 = 14 WHERE u.id IN (3,5,9,11,16,19,20,21,22,23,24,25,27,29,30,31,32,33,34,35,36,37,38,39) 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()

      Show
      Warning: mysqli::query() [mysqli.query] : (22003/1690): BIGINT UNSIGNED value is out of range in '(`qrm3leoq`.`s`.`timemarked` - `qrm3leoq`.`s`.`timemodified`)' in /var/www/ktm/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 '(`qrm3leoq`.`s`.`timemarked` - `qrm3leoq`.`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 = 14 WHERE u.id IN (3,5,9,11,16,19,20,21,22,23,24,25,27,29,30,31,32,33,34,35,36,37,38,39) 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()

      I am not able to see submitted assignments

            moodle.com Moodle HQ
            bryanpreach1971 Bryan Allen
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.