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

Assignment: Error in Database

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.1.2
    • 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.

      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()

            moodle.com Moodle HQ
            garynewport Gary Newport
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:

                Error rendering 'clockify-timesheets-time-tracking-reports:timer-sidebar'. Please contact your Jira administrators.