Moodle
  1. Moodle
  2. MDL-30732

Unable to access list of submitted assignments

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.1.2
    • Fix Version/s: None
    • Component/s: Assignment (2.2)
    • Labels:
      None
    • Database:
      MySQL
    • Testing Instructions:
      Hide

      1. Click on link for upload assignment.
      2. Click on Status - To order by status.
      3. Receive error.
      4. No longer able to access assignment information.

      Debug info: Unknown column 'status' in 'order 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 FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid
      AND s.assignment = 10 WHERE u.id IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,88,89,90,91,92,93) ORDER BY status ASC, timemarked ASC
      [array (
      )]
      Stack trace:

      line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 809 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1325 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 649 of /mod/assignment/lib.php: call to assignment_base->display_submissions()
      line 57 of /mod/assignment/submissions.php: call to assignment_base->submissions()

      Show
      1. Click on link for upload assignment. 2. Click on Status - To order by status. 3. Receive error. 4. No longer able to access assignment information. Debug info: Unknown column 'status' in 'order 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 FROM mdl_user u LEFT JOIN mdl_assignment_submissions s ON u.id = s.userid AND s.assignment = 10 WHERE u.id IN (8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,88,89,90,91,92,93) ORDER BY status ASC, timemarked ASC [array ( )] Stack trace: line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown line 809 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end() line 1325 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql() line 649 of /mod/assignment/lib.php: call to assignment_base->display_submissions() line 57 of /mod/assignment/submissions.php: call to assignment_base->submissions()
    • Affected Branches:
      MOODLE_21_STABLE
    • Rank:
      33610

      Description

      When attempting to list assignments (uploaded) by status order receive Error reading from database message. No longer able to access assignments at all.

      Opening with another browser allows for viewing of information. Still can not order list.

        Issue Links

          Activity

          John Romain created issue -
          Sam Marshall made changes -
          Field Original Value New Value
          Assignee Sam Marshall [ quen ] moodle.com [ moodle.com ]
          Component/s Assignment [ 10052 ]
          Component/s Activity completion [ 10800 ]
          Michael de Raadt made changes -
          Link This issue duplicates MDL-29529 [ MDL-29529 ]
          Michael de Raadt made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Resolution Duplicate [ 3 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved: