Database error student => participants

Database error student => participants

by Davo Smith -
Number of replies: 0
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers
I just got the following error, whilst logged in as a student and clicking on 'participants':

Debug info: Unknown column 'eu.roleid' in 'on clause'
SELECT COUNT(u.id) FROM mdl_user u
JOIN (SELECT DISTINCT eu.id
FROM mdl_user eu
JOIN mdl_role_assignments eu_ra1 ON (eu_ra1.userid = eu.id AND eu_ra1.roleid IN (5,4,3) AND eu_ra1.contextid IN (1,3,15))
JOIN mdl_groups_members eugm ON (eugm.userid = eu.id AND eu.roleid = ?)
WHERE eu.deleted = 0 AND eu.username <> 'guest') e ON e.id = u.id
LEFT JOIN mdl_user_lastaccess ul ON (ul.userid = u.id AND ul.courseid = ?)
LEFT JOIN mdl_context ctx ON (ctx.instanceid = u.id AND ctx.contextlevel = 30)
[array (
0 => '1',
1 => '2',
)]
Stack trace:
  • line 378 of /lib/dml/moodle_database.php: dml_read_exception thrown
  • line 632 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
  • line 1216 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
  • line 1291 of /lib/dml/moodle_database.php: call to moodle_database->get_record_sql()
  • line 1462 of /lib/dml/moodle_database.php: call to moodle_database->get_field_sql()
  • line 459 of /user/index.php: call to moodle_database->count_records_sql()


Average of ratings: -