[Akonadi] [Bug 483060] Akonadi sending UTC timestamps as local time to MySQL (and this failing around DST change) - QMYSQL bug?
Joshua J. Kugler
bugzilla_noreply at kde.org
Mon Mar 11 19:35:42 GMT 2024
https://bugs.kde.org/show_bug.cgi?id=483060
--- Comment #6 from Joshua J. Kugler <joshua at joshuakugler.com> ---
When I was debugging this, someone in the #maria IRC channel said:
> As a workaround SQL mode flag ALLOW_INVALID_DATES should help, but it is better to store the UTC values properply as UTC.
So, there is that...but that does seem ugly. Can you even specify a TZ on a
TIMESTAMP column in MySQL/MariaDB (it's been too long since I've actively used
MySQL).
Another idea: have Akonadi set the client time zone to UTC when it connects.
BUT: I don't know what that might do to the times it returns in other queries,
so would require investigation, and if code would have to be changed elsewhere.
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Kdepim-bugs
mailing list