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

Database Error when grading Offline Assignments.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.0
    • Component/s: Assignment (2.2)
    • Labels:
      None
    • Environment:
      moodle preview 4 build 201000905
      centOS 5.5
      apache 2.2.16
      mysql 5.0.91
      php 5.2.14
    • Database:
      MySQL
    • Affected Branches:
      MOODLE_20_STABLE
    • Fixed Branches:
      MOODLE_20_STABLE

      Description

      this relates to MDLQA-218. test stage 2 failed. assignment (single file upload) activity added and submitted ok, but fails when logged in teacher clicks the 'View n submitted assignments' link.

      moodle preview 4 build 201000905

      error dialogue reads: error reading from database. developer debugging info as follows:

      Debug info: Unknown column 'Array' in 'where clause'
      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 = 1 WHERE Array AND u.id IN (4) ORDER BY lastname ASC
      [array (
      )]
      Stack trace:
      line 391 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 732 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1289 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 632 of /mod/assignment/lib.php: call to assignment_base->display_submissions()
      line 56 of /mod/assignment/submissions.php: call to assignment_base->submissions()

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

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

                  Dates

                  • Created:
                    Updated:
                    Resolved:
                    Fix Release Date:
                    24/Nov/10