Assignment

× Debug info: Column 'status' in field list is ambiguous
SELECT
u.id,u.picture,u.firstname,u.lastname,u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.imagealt,u.email, u.id as userid, s.status as status, s.id as submissionid, s.timecreated as firstsubmission, CASE WHEN status <> ? THEN s.timemodified ELSE NULL END as timesubmitted, s.attemptnumber as attemptnumber, g.id as gradeid, g.grade as grade, g.timemodified as timemarked, g.timecreated as firstmarked, uf.mailed as mailed, uf.locked as locked, uf.extensionduedate as extensionduedate, uf.workflowstate as workflowstate, uf.allocatedmarker as allocatedmarker
FROM mdl_user u
LEFT JOIN mdl_assign_submission s
ON u.id = s.userid
AND s.assignment = ?
AND s.latest = 1
LEFT JOIN mdl_assign_grades g
ON u.id = g.userid
AND g.assignment = ? AND g.attemptnumber = s.attemptnumber LEFT JOIN mdl_assign_user_flags uf
ON u.id = uf.userid
AND uf.assignment = ? 
WHERE u.id IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
ORDER BY userid ASC LIMIT 0, 10
[array (
0 => 'new',
1 => 561,
2 => 561,
3 => 561,
4 => 5977,
5 => 5719,
6 => 6060,
7 => 5403,
8 => 5759,
9 => 5859,
10 => 5410,
11 => 5473,
12 => 5571,
13 => 5646,
14 => 5841,
15 => 5810,
16 => 5662,
17 => 5876,
18 => 5495,
19 => 5952,
20 => 5760,
21 => 5927,
22 => 6032,
23 => 5789,
24 => 6056,
25 => 5996,
26 => 5682,
27 => 5887,
28 => 6141,
29 => 5837,
30 => 5629,
31 => 5940,
32 => 6070,
33 => 5436,
34 => 5748,
35 => 5477,
36 => 5441,
37 => 5750,
38 => 5494,
39 => 6144,
)]
Error code: dmlreadexception

× Stack trace:

• line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
• line 1198 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
• line 1609 of /lib/tablelib.php: call to mysqli_native_moodle_database->get_records_sql()
• line 1630 of /lib/tablelib.php: call to table_sql->query_db()
• line 1446 of /mod/assign/renderer.php: call to table_sql->out()
• line 1242 of /mod/assign/renderer.php: call to mod_assign_renderer->flexible_table()
• line 401 of /lib/outputrenderers.php: call to mod_assign_renderer->render_assign_grading_table()
• line 4171 of /mod/assign/locallib.php: call to plugin_renderer_base->render()
• line 4249 of /mod/assign/locallib.php: call to assign->view_grading_table()
• line 588 of /mod/assign/locallib.php: call to assign->view_grading_page()
• line 55 of /mod/assign/view.php: call to assign->view()