To replicate you need a 2.4.3 installation of Moodle.
Go into a course and add a big blue button room and set it to record. Enter the room for a 15-30 seconds so it can create the recording.
Return to the course and add the recordingsbn resource.
Turn editing on and add the "activities" block. In the activities block you will see a link called "resources" which is a Moodle page that aggregates all of the resources in a course and puts it on one page.
Click on the resources link and attempt to view the resources page and you will be presented with an "error reading from database"
The specific error message:
Debug info: Unknown column 'intro' in 'field list'
SELECT id,name,intro,introformat,timemodified FROM mdl_recordingsbn WHERE id = ? ORDER BY id
[array (
0 => '26',
)]
Error code: dmlreadexception
Stack trace:
line 426 of /lib/dml/moodle_database.php: dml_read_exception thrown
line 1023 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
line 1211 of /lib/dml/moodle_database.php: call to mysqli_native_moodle_database->get_records_sql()
line 1184 of /lib/dml/moodle_database.php: call to moodle_database->get_records_select()
line 87 of /course/resources.php: call to moodle_database->get_records_list()
When Moodle is attempting to build out the resources page it is querying the mdl_recordingsbn table but its not receiving the expected data. I don't know if there is a way to bypass this.
The mdl_resources table always has the columns name,intro,introformat, etc.
Moodle 2.4.4 does not have this issue so I don't know if Moodle changed the manner in which this page is built or why it does not cause a problem.
We have a large number of portals in production that use big blue button and the recordings and ideally I could patch this without having to go through a mass upgrade. If we have to that will be the solution but I was hoping you would have a better understanding as why this is occurring.