I clicked as a admin on the assignment and got this error_log text at the server.
//
[02-Dec-2017 13:18:38 Europe/Stockholm] Default exception handler: Fel vid läsning av databas Debug: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
AND userid NOT IN (
' at line 6
SELECT u.id
FROM mdl_user u
LEFT OUTER JOIN mdl_user_lastaccess ul ON (ul.userid = u.id AND ul.courseid = 334)
JOIN (SELECT DISTINCT userid FROM ( SELECT userid
FROM mdl_role_assignments
WHERE contextid IN (1,42624,53,42621,42617,43009) AND roleid IN ()
AND userid NOT IN (
SELECT userid
FROM mdl_role_assignments
WHERE contextid IN (1,42624,53,42621,42617,43009)
AND roleid IN ()
) ) us) ra ON ra.userid = u.id
WHERE u.deleted = 0 AND u.id <> ?
ORDER BY ul.timeaccess
[array (
0 => '1',
)]
Error code: dmlreadexception
* line 486 of /lib/dml/moodle_database.php: dml_read_exception thrown
* line 1216 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
* line 3490 of /lib/accesslib.php: call to mysqli_native_moodle_database->get_records_sql()
* line 73 of /availability/classes/capability_checker.php: call to get_users_by_capability()
* line 647 of /availability/classes/info.php: call to core_availability\capability_checker->get_users_by_capability()
* line 106 of /availability/classes/info_module.php: call to core_availability\info->filter_user_list()
* line 2021 of /mod/assign/locallib.php: call to core_availability\info_module->filter_user_list()
* line 2128 of /mod/assign/locallib.php: call to assign->list_participants()
* line 5329 of /mod/assign/locallib.php: call to assign->count_participants()
* line 5384 of /mod/assign/locallib.php: call to assign->get_assign_grading_summary_renderable()
* line 615 of /mod/assign/locallib.php: call to assign->view_submission_page()
* line 55 of /mod/assign/view.php: call to assign->view()
//And I got this as a php error on moodle:
Notice: Undefined offset: 0 in /home/sih98c2/public_html/iterum-YH/lib/accesslib.php on line 3456
Warning: array_keys() expects parameter 1 to be array, null given in /home/sih98c2/public_html/iterum-YH/lib/accesslib.php on line 3456
Warning: implode(): Invalid arguments passed in /home/sih98c2/public_html/iterum-YH/lib/accesslib.php on line 3456
Notice: Undefined offset: 0 in /home/sih98c2/public_html/iterum-YH/lib/accesslib.php on line 3461
Warning: array_keys() expects parameter 1 to be array, null given in /home/sih98c2/public_html/iterum-YH/lib/accesslib.php on line 3461
Warning: implode(): Invalid arguments passed in /home/sih98c2/public_html/iterum-YH/lib/accesslib.php on line 3461
Error reading database
ANY Ideas!?