-
Bug
-
Resolution: Fixed
-
Minor
-
2.2, 2.3
-
Linux
-
Oracle
-
MOODLE_22_STABLE, MOODLE_23_STABLE
-
MOODLE_21_STABLE, MOODLE_22_STABLE
-
MDL-31806-master -
-
When a teacher tries to click "Enrolled users" link under course administration then the page displays "Error reading from database" if a tag block is added with course tags enabled.
- line 125 of /tag/coursetagslib.php: call to oci_native_moodle_database->get_records_sql()
- line 115 of /blocks/tags/block_tags.php: call to coursetag_get_all_tags()
- line 280 of /blocks/moodleblock.class.php: call to block_tags->get_content()
- line 232 of /blocks/moodleblock.class.php: call to block_base->formatted_contents()
- line 926 of /lib/blocklib.php: call to block_base->get_content_for_output()
- line 978 of /lib/blocklib.php: call to block_manager->create_block_contents()
- line 349 of /lib/blocklib.php: call to block_manager->ensure_content_created()
SELECT id, name, id, tagtype, rawname, f.timemodified, flag, count
FROM e_tag t,
(SELECT tagid, MAX(timemodified) as timemodified, COUNT(id) as count
FROM e_tag_instance WHERE tagid NOT IN
(SELECT tagid FROM e_tag_instance ti, e_course c
WHERE c.visible = 0
AND ti.itemtype = 'course'
AND ti.itemid = c.id)
GROUP BY tagid) f
WHERE t.id = f.tagid
ORDER BY count DESC, name ASC