View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0004914||SOGo||Backend Calendar||public||2019-12-23 20:22||2019-12-23 20:22|
|Summary||0004914: Calendar support for dates <1970 and >2038 (Y2k28 problem)|
Times are stored as UNIX time in a 32-bit signed INT in MySQL. So it is not possible to get beyond 2038-01-18. While dates before 1970 are stored as negative numbers in MySQL, they won't show up in the Webcalendar.
|Steps To Reproduce|
Enter an appointment starting before 1970 which repeats daily. In the web calender you will see the first instance on 1970-01-02 and the last instance on 2038-01-18 (daily view).
As negative values don't show up there's probably also some problem in the Objective-C parts. In earlier SOGo versions negative dates appeared in year 2106 backwards, so negative values had been processed as unsigned. I could no longer reproduce this in SOGo 4.2.0.
|Tags||No tags attached.|