Not a bug

Time difference incorrect on file downloaded notifications

Mark F 3 years ago updated by Vlad R 3 years ago 4

The time difference listed in the email notifications for downloaded files it always incorrect.  I believe that it is returning the localtime offset from GMT as it always says 5 hours ago and I am in Central Daylight Time (CDT), UTC -5.

Here are some lines from several email notifications that I have received and when the email was received.

2019-10-03 10:26:45(5 hours ago), email received at 2019-10-03 10:27

2019-10-02 10:31:04(5 hours ago), email received at 2019-10-02 11:27

2019-10-03 12:45:30(5 hours ago), email received at 2019-10-03 12:45

2019-10-01 11:20:11(5 hours ago), email received at 2019-10-01 11:27

2019-03-25 01:39:42 (5 hours ago), email received at 2019-03-25 2:27

customizables/emails/folder_notifications/upload.tpl.txt  has the line

{$info.details.date} ({$info.details.date|MySQLTimeDiff}

Under review

Can it be that PHP is configured with one timezone (date.timezone) and the MySQL server with a different one?

you are correct.

php is in UTC and mysql is in CDT

Not a bug

It can be adjusted via a config option in FileRun, but it would be better to be adjusted in the server itself, to avoid other possible problems.