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

error al leer base de datos de un espacio de tareas creado

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.0.4
    • Fix Version/s: None
    • Labels:
      None
    • Affected Branches:
      MOODLE_20_STABLE

      Description

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

      Debug info: BIGINT UNSIGNED value is out of range in '(`quidcono_mdle1`.`s`.`timemarked` - `quidcono_mdle1`.`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 = 27 WHERE u.id IN (2,3,10,39,106,118,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,183,184,185) 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 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

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved: