[Akonadi] [Bug 483060] Akonadi sending UTC timestamps as local time to MySQL (and this failing around DST change) - QMYSQL bug?

[Joshua J. Kugler]

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.