All scheduled reports will be sent at 00:00 o'clock

Backend functionalities: user management, course management, reports, certificates, etc.
Post Reply
SarahF20
Newbie
Posts: 9
Joined: Tue Nov 24, 2020 10:54 am

All scheduled reports will be sent at 00:00 o'clock

Post by SarahF20 »

Hi,

After lots of investigation, finally we realized what is our issue, all reports with different schedule time will just be sent at 00:00 o'clock.

Is it a known bug?

alfa24
Senior Boarder
Posts: 1321
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: All scheduled reports will be sent at 00:00 o'clock

Post by alfa24 »

How is your crontab configured and how is your non-working report scheduled exactly? I'm aware of different bugs in cron scheduling script.
I'm Jasmines, the One. If you need, you can contact me.

SarahF20
Newbie
Posts: 9
Joined: Tue Nov 24, 2020 10:54 am

Re: All scheduled reports will be sent at 00:00 o'clock

Post by SarahF20 »

Thanks for your reply/help

Well, cron job set to run every 10 minutes.
wrt non-working report schedules time: we tried many way, i.e "Everyday, at hour 12:10:00" and weekly, but no luck, it only will be sent at 00:00 o'clock.

SarahF20
Newbie
Posts: 9
Joined: Tue Nov 24, 2020 10:54 am

Re: All scheduled reports will be sent at 00:00 o'clock

Post by SarahF20 »

But now I see something random:

I've created a repot at 05/10/2021 12:09 with schedule time at Everyday, at hour 12:10:00 but it just sent at 14:11.
But I other report that has been created a few days ago just sent at 00:00 !!!
I've no idea tbh whats going on.... could someone guide me.

alfa24
Senior Boarder
Posts: 1321
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: All scheduled reports will be sent at 00:00 o'clock

Post by alfa24 »

In /cron/cron.report.php

find:

Code: Select all

$curtime = date("d-m-Y G:i:s");
change it to:

Code: Select all

$curtime = date("Y-m-d H:i:s");
Tell me if it solves.
I'm Jasmines, the One. If you need, you can contact me.

SarahF20
Newbie
Posts: 9
Joined: Tue Nov 24, 2020 10:54 am

Re: All scheduled reports will be sent at 00:00 o'clock

Post by SarahF20 »

I've changed the code as you said, then I created a new report with this time table

creation time : 05/10/2021 14:54
Scheduled time: Everyday, at hour 14:56:00
Cron job run every minutes

But no email yet.

alfa24
Senior Boarder
Posts: 1321
Joined: Fri Nov 24, 2017 8:45 am
Version: forma.lms 1.4.2

Re: All scheduled reports will be sent at 00:00 o'clock

Post by alfa24 »

Sorry, but if I'm not on your instance, I can't figure out what is happening.
I'm Jasmines, the One. If you need, you can contact me.

Post Reply