Error when generating an attendance report

Question

Error when generating an attendance report

Closed this issue a year ago · 5 comments

Moodle version: 4.1.4
Plugin version: 2023020107

When generating a report via "user menu -> reports -> new report -> report source -> attendance" currently we get the following error:

The report seems to be getting generated but when trying to view the report the same error occurs. Other reports are working fine.
Thanks for your help!

Answer 1 · 2023-08-03T05:24:37.000Z

Thanks for the report! Can you also please clarify what database type you are running? Mysql/postgres etc?

Answer 2 · 2023-08-03T06:29:08.000Z

We are using MariaDB/MySQL.

Answer 3 · 2023-08-03T12:37:19.000Z

We are also seeing this error with MySQL.

Answer 4 · 2023-08-04T00:13:34.000Z

Thanks for confirming that - I usually do my local testing and development against postgres - if you have internal development capabilities, pull requests are always welcome, otherwise I'll try to take a look at this sometime!

Answer 5 · 2023-10-03T07:43:21.000Z

I've just pushed a fix into the github repo that should fix this for 4.1 and higher versions - let me know if you get a chance to test this and if it resolves the issues you were having!

thanks,