-
Bug
-
Resolution: Unresolved
-
Minor
-
None
-
2.7.2
-
None
-
MOODLE_27_STABLE
We are trying to install the Ranking Block on Moodle 2.7.2 and we are getting the below error. Is the Ranking Block compatable with version 2.7.2? according to the plugin site the version only goes up to Moodle 2.6?
Table 'i850966_mood1.mdl_user' doesn't exist
SELECT
DISTINCT u.id,u.picture,u.firstname,u.lastname,u.firstnamephonetic,u.lastnamephonetic,u.middlename,u.alternatename,u.imagealt,u.email,u.username, concat(u.firstname, ' ',u.lastname) as fullname, r.points
FROM
mdl_user u
INNER JOIN mdl_role_assignments a ON a.userid = u.id
INNER JOIN mdl_ranking_points r ON r.userid = u.id
INNER JOIN mdl_context c ON c.id = a.contextid
WHERE a.contextid = ?
AND a.userid = u.id
AND a.roleid = ?
AND c.instanceid = ?
AND r.courseid = ?
ORDER BY r.points DESC
LIMIT 10
[array (
0 => 36,
1 => 5,
2 => '4',
3 => '4',
)]
Error code: dmlreadexception
Stack trace:
line 443 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1014 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 71 of /blocks/ranking/lib.php: call to mysqli_native_moodle_database->get_records_sql()
line 78 of /blocks/ranking/block_ranking.php: call to block_ranking_get_students()
line 294 of /blocks/moodleblock.class.php: call to block_ranking->get_content()
line 236 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
line 993 of /lib/blocklib.php: call to block_base->get_content_for_output()
line 1045 of /lib/blocklib.php: call to block_manager->create_block_contents()
line 361 of /lib/outputrenderers.php: call to block_manager->ensure_content_created()
line 34 of /theme/essential/layout/includes/header.php: call to core_renderer->standard_head_html()
line 27 of /theme/essential/layout/columns3.php: call to require_once()
line 877 of /lib/outputrenderers.php: call to include()
line 807 of /lib/outputrenderers.php: call to core_renderer->render_page_layout()
line 243 of /course/view.php: call to core_renderer->header()