search

JodliDev / calendar

GNU Affero General Public License v3.0
16 stars 12 forks source link

calendar event creation and modification time 2 hours ahead (saved as local time, not UTC?) #25

Open chaos-prevails opened 2 years ago

chaos-prevails commented 2 years ago

when I click on an event (having the buttons edit, delete, close), I see the creation, and modification time of an event.

In my case (living +2 UTC right now) the time is 2 hours later of the actual creation time (or modification time).

1) in the DB in caldav_events, values in the fields created, and changed are saved in local time, not UTC. 2) the server (timedatectl) is set to local time (CEST, +0200), and php.ini is set to date.timezone Europe/Berlin

I would assume that any date in the DB should be saved in UTC, and then in the interface the local time is shown? So it would only need to make sure the timestamps for creation, and modification are in UTC? (The end, and start date of an event are saved in UTC).

Abyss777 commented 2 months ago

Looks like it is problem of autologin, when timezone missed https://github.com/roundcube/roundcubemail/issues/2443

When i use autologin events stored in UTC, when I login via login page they stored with corrected time to my timezone.