Moodle
  1. Moodle
  2. MDL-32796

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

    Details

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

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

        Issue Links

          Activity

          Hide
          Michael de Raadt added a comment -

          Hi, Alejandro.

          Thanks for reporting a problem. Could you please translate this to English?

          Show
          Michael de Raadt added a comment - Hi, Alejandro. Thanks for reporting a problem. Could you please translate this to English?
          Hide
          Michael de Raadt added a comment -

          Looking at your error, it appears to be one that was resolved some time ago. It came about with an update of MySQL. You will need to upgrade your version of Moodle to resolve the problem.

          Show
          Michael de Raadt added a comment - Looking at your error, it appears to be one that was resolved some time ago. It came about with an update of MySQL. You will need to upgrade your version of Moodle to resolve the problem.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: