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

Error Reading From Database

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Incomplete
    • 2.3.2
    • None
    • Assignment (2.2)
    • None
    • MOODLE_23_STABLE

    Description

      This moodle is used as a VLE at a school. All of the work that has been uploaded cannot be accessed by myself. I get the same 'Error Reading from Database' message each time I try.

      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 = 1 WHERE u.id IN (84,103,78,88,105,71,70,74,73,75,85,110,109,99,95,100,112,113) ORDER BY status ASC, lastname ASC
      [array (
      )]
      Stack trace:
      line 394 of /lib/dml/moodle_database.php: dml_read_exception thrown
      line 794 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
      line 1321 of /mod/assignment/lib.php: call to mysqli_native_moodle_database->get_records_sql()
      line 645 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()

      Attachments

        Issue Links

          Activity

            People

              moodle.com Moodle HQ
              mobymatt Matthew Pledger
              Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: