View Issue Details

IDProjectCategoryView StatusLast Update
0004914SOGoBackend Calendarpublic2019-12-23 20:22
Reporterschmirl Assigned To 
Status newResolutionopen 
Product Version4.2.0 
Summary0004914: 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).

Additional Information

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.

TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2019-12-23 20:22 schmirl New Issue