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

[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]

How is your crontab configured and how is your non-working report scheduled exactly? I'm aware of different bugs in cron scheduling script.

[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]

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]

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.

[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]

Sorry, but if I'm not on your instance, I can't figure out what is happening.