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

Assignment: Error in Database

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: 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

      Went to Assignment then view submitted assignments. Clicked on Status to sort by those that had not been marked. Error has arisen since then.

      Show
      Went to Assignment then view submitted assignments. Clicked on Status to sort by those that had not been marked. Error has arisen since then.
    • URL:
      bexhill-vle.co.uk
    • Affected Branches:
      MOODLE_21_STABLE

      Description

      I just tried to sort all assignments by Status and now get an Error reading from database each time on ALL assignments. I have had no issues previously.

      I have purged all caches and have enbaled error messaging. I get the following error message:

      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 = 32 WHERE u.id IN (10,12,14,17,20,27,31,32,34,36,39,42,44,45,48,49,50,51,52,53,55,58,65,66,67,68,69,71,76,79,80,82,83,91,94,96,98,99,100,105,106,109,110,113,115,118,119,120) ORDER BY status ASC, lastname 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()

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              moodle.com moodle.com
              Reporter:
              garynewport Gary Newport
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: