Affects Version/s: 2.1.2
Fix Version/s: None
Component/s: Assignment (2.2)
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'
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
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()