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

Assignment: Error in Database

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 2.1.2
    • None
    • Assignment (2.2)
    • None
    • MySQL
    • MOODLE_21_STABLE
    • bexhill-vle.co.uk
    • 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.

    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

              moodle.com Moodle HQ
              garynewport Gary Newport
              Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: