Error when trying to access to the report at course level

[magali-lescano]

When trying to access to the report inside a course, the following error appears:

Error reading from database

More information about this error

Debug info: Unknown column 'rbalias3.id' in 'WHERE'

SELECT COUNT(1)
FROM (SELECT rbalias1.name AS c1_name, rbalias4.firstname AS c2_firstname, rbalias4.lastname AS c2_lastname, rbalias4.id AS c2_id, rbalias9.fullname AS c3_coursefullnamewithlink, rbalias9.id AS c3_id, rbalias10.id AS c3_ctxid, rbalias10.path AS c3_ctxpath, rbalias10.depth AS c3_ctxdepth, rbalias10.contextlevel AS c3_ctxlevel, rbalias10.instanceid AS c3_ctxinstance, rbalias10.locked AS c3_ctxlocked, rbalias2.pluginname AS c4_pluginname, rbalias0.actiondetail AS c5_actiondetail, rbalias0.timestamp AS c6_timestamp
FROM mdl_notificationsagent_report rbalias0 JOIN mdl_notificationsagent_rule rbalias1
ON rbalias0.ruleid = rbalias1.id JOIN mdl_user rbalias4 ON rbalias4.id = rbalias0.userid JOIN mdl_course rbalias9 ON rbalias9.id = rbalias0.courseid LEFT JOIN mdl_context rbalias10
ON rbalias10.contextlevel = 50
AND rbalias10.instanceid = rbalias9.id JOIN mdl_notificationsagent_action rbalias2
ON rbalias0.actionid = rbalias2.id
WHERE (rbalias3.id = ?)

) rbalias13
[array (
0 => '29',
)]
Error code: dmlreadexception

[fpano]

Hi!
Could you give us a little more information? Such as moodle version, plugin version installed...

Thank you!

[magali-lescano]

Hello,

We are using Moodle 4.5.4+ (Build: 20250509) and plugin version installed is 0.6.4 (2025051700).

Thank you!