Moodle in English: Ad-hoc scheduled report email not being sent

Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Friday, February 1, 2019, 11:31 PM

Hi.

We use a number of customised ad-hoc reports that are scheduled either daily or weekly to send to admins. These have worked fine for a number of years but having just updated 2 sites to Moodle 3.6.2+ this past week, the emailed reports are now not being emailed out.

I have checked and all reports are being generated by the Ad-hoc report plugin. I have also checked that other emails are being sent out from the site (ie password reminders, certificates, etc) so it doesn't appear to be an issue with the emails.

Cron and scheduled tasks are all running correctly also.

Are there any known issues with the ad-hoc reporting and the latest version of Moodle that I should be aware of?

Thanks
Mark

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Tim Hunt - Saturday, February 2, 2019, 5:31 AM

We are not yet running Moodle 3.6, so I don't know for sure, but I can't think of any obvious reason why it would stop working. We will be testing this ourselves in a few weeks.

You have checked all the obvious things (other emails working, cron running, etc.) Would be interesting to know what other people have experienced.

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Monday, February 4, 2019, 4:20 PM

Thanks for the quick reply Tim.

If you have any ideas or know anything I can look at that may show what could cause this issue, please let me know. Bit concerned as I now have to manually email out over 40 reports on a weekly basis until this is resolved.

Thanks again.

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Tim Hunt - Monday, February 4, 2019, 6:27 PM

The code to send the email is https://github.com/moodleou/moodle-report_customsql/blob/master/locallib.php#L698.

There were changes in Moodle's messaging system in Moodle 3.6. However, the upgrade notes (https://docs.moodle.org/dev/Moodle_3.6_release_notes#For_developers, https://git.in.moodle.com/moodle/moodle/blob/master/message/upgrade.txt) don't say anything like "You must change your code or it will stop working."

Are there any errors in the PHP log files or in the cron output?

Average of ratings:Useful (1)

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Monday, February 4, 2019, 7:04 PM

The cron appears to be running correctly:

Cron script completed correctly
Cron completed at 11:01:26. Memory used 16.2MB.
Execution took 0.030819 seconds

Where would I check the PHP log files for any error reports?

Thanks

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Wednesday, February 6, 2019, 12:42 AM

I got this error today when I manually tried to run the cronjob.

!!! Exception - Argument 1 passed to message_send() must be an instance of core\message\message, instance of stdClass given, called in [dirroot]/report/customsql/locallib.php on line 714 !!!

Does this mean anything to you?

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Tim Hunt - Wednesday, February 6, 2019, 6:07 AM

Ah! That will be the problem. Thank you for finding the error message. Should be fixable now that I know that.

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Wednesday, February 6, 2019, 4:14 PM

Thanks Tim, that's great to know. Hopefully it shouldn't be too much of an issue to fix.

Look forward to hearing an update.

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Monday, March 4, 2019, 7:31 PM

Hi Tim, hope all's well.

Just wondered if there was any update regarding finding a fix for this issue?

Many thanks
Mark

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Wednesday, April 3, 2019, 5:13 PM

Hi Tim, has there been any progress in investigating the issue with the Ad Hoc reporting plugin sending out the scheduled emails? It has been rather painful manually emailing hundreds of reports on a weekly basis.

Thanks in advance!

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Tim Hunt - Wednesday, April 3, 2019, 6:11 PM

Sorry. Not yet.

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Richard Pochepan - Tuesday, April 9, 2019, 2:43 PM

Hi Mark,

I applied this hack near line 700 in /customsql/locallib.php to get the email reports on my 3.6.2+ system to work.

// Prepare the message.

$eventdata = new \core\message\message();

// $eventdata = new stdClass();

Hope this helps.

Average of ratings:Useful (3)

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Tuesday, April 9, 2019, 4:42 PM

Hi Richard,

Thanks for the info - will apply the hack and see how we get on. Super appreciated!!

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Mark Baldwin - Tuesday, April 9, 2019, 6:12 PM

Just to update, the reports are now finally emailing out - Richard, you are a godsend! You've just made my Monday mornings a hell of a lot easier again!

Average of ratings: -

Re: Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Noveck Gowandan - Tuesday, May 21, 2019, 2:21 AM

Thank you! This also did the trick for me.

Average of ratings: -

Re: Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Noveck Gowandan - Tuesday, May 21, 2019, 2:23 AM

I'm also seeing some further changes proposed in one related pull request by Paul Holden
Hopefully it gets accepted so future upgrades don't require this hack again.

https://github.com/moodleou/moodle-report_customsql/pull/46/files

Average of ratings: -

Re: Ad-hoc scheduled report email not being sent - Moodle 3.6.2+

by Asher Baig - Sunday, March 29, 2020, 3:03 AM

Can you help me, as i have to send daily teaching activity report to admin.

How this could be possible?

I know this is not right way to ask but please help me out this email

Average of ratings: -

Analytics and reporting

Ad-hoc scheduled report email not being sent - Moodle 3.6.2+