I seem to witness the same symptoms of viewing submitted assignments with result "Nothing to display". This has been happening for the last few versions of Moodle (v1.9 branch) and the teacher claimed that it started happening this school year (last 2 months). Moodle version 1.9.14, mysql 4.1.22, php 4.3.9, debug info is as follows:
Unknown column 'status' in 'order clause'
SELECT u.id, u.firstname, u.lastname, u.picture, u.imagealt, 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 = 8308 WHERE u.id IN (2202,2102,2096,2121,2112,2196,2109,2110,2111,2097,2095,2106,1962,2094,2103,2099,2101,2104,2108,2098,2105,2100,2113,2107) ORDER BY status ASC
- line 687 of lib/dmllib.php: call to debugging()
- line 967 of lib/dmllib.php: call to get_recordset_sql()
- line 1184 of mod/assignment/lib.php: call to get_records_sql()
- line 524 of mod/assignment/lib.php: call to assignment_upload->display_submissions()
- line 43 of mod/assignment/submissions.php: call to assignment_upload->submissions()
After some searching the initial error seems similar to MDL-29529 although that bug corresponds to Moodle version 2.1.1 (same error however). Any suggestions?