0005685: Calendar entry from Outlook via CalDav Synchronizer leads to SQL error "integer out of range" - SOGo

ID	Project	Category	View Status	Date Submitted	Last Update

0005685	SOGo	Backend Calendar	public	2023-01-25 13:18	2023-01-25 15:41

Reporter	MIT	Assigned To
Priority	normal	Severity	crash	Reproducibility	have not tried
Status	new	Resolution	open
Product Version	5.8.0

Summary	0005685: Calendar entry from Outlook via CalDav Synchronizer leads to SQL error "integer out of range"
Description	When using Outlook 2021 with CalDav Synchronizer a brithday entry (which is send to the calendar) leads to the following error: <code> Jan 25 13:11:15 sogod [121490]: <0x0x55fb19443610[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot update content : <PostgreSQL72Exception: 0x55fb196f3c80> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x55fb195eb980[PostgreSQL72Channel]: connection=<0x0x55fb1a02c550[PGConnection]: connection=0x0x55fb1a02c730>>): ERROR: integer out of range </code> The error comes from the sql statement (data removed): <code> update sogoRemoved_quick set [...] c_startdate = 4202346496, [...] where c_name = 'removed.ics'; </code> The c_startdate column is of type INT4. I don't know if the error was introduced by updating to SOGo 5.8.0 or an Outlook / CalDav Synchronizer update. The brithday entry has been in Outlook for years, hasn't been changed and looks ok (no "big" dates entered).
Tags	No tags attached.

Date Modified	Username	Field	Change
2023-01-25 13:18	MIT	New Issue
2023-01-25 15:41	sebastien	Note Added: 0016598

sebastien 2023-01-25 15:41 administrator ~0016598	No changes on SOGo db in 5.8.0.