Details
Description
admin > Plugins > Blocks > Manage Blocks - view list of places a particular block is being used, get this error:
Debug info: Unknown column 'bi.contextid' in 'on clause'
SELECT * FROM mdl_course WHERE id IN (
SELECT DISTINCT ctx.instanceid
FROM mdl_context ctx
JOIN mdl_block_instances bi ON bi.contextid = ctx.id
WHERE ctx.contextlevel = 50 AND bi.blockname = ?)
[array (
0 => 'completionstatus',
)]
Stack trace:
- line 378 of /lib/dml/moodle_database.php: dml_read_exception thrown
- line 591 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
- line 140 of /course/search.php: call to mysqli_native_moodle_database->get_recordset_sql()
Attachments
Issue Links
- has a non-specific relationship to
-
MDL-19536 block_instances.contextid should be renamed block_instances.parentcontextid to avoid gross confusion
-
- Closed
-