View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005685 | SOGo | Backend Calendar | public | 2023-01-25 13:18 | 2023-06-05 07:36 |
Reporter | MIT | Assigned To | sebastien | ||
Priority | normal | Severity | crash | Reproducibility | have not tried |
Status | resolved | Resolution | fixed | ||
Product Version | 5.8.0 | ||||
Fixed in Version | 5.9.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> The error comes from the sql statement (data removed): <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. | ||||
No changes on SOGo db in 5.8.0. |
|
Just to confirm it is not an isolated problem: I get those errors as well. |
|
Probably related to 0004914 |
|
Hi @MIT can you provide the data structure of the table ? Sebastien |
|
Hi Sebastien, of course: <code sql> |
|
Commit https://github.com/Alinto/sogo/commit/158a5becc902b1d241575ac5098ceb527a0011ff and https://github.com/Alinto/sogo/commit/32a04998e50cc4adbc72b7dc36de67b8e9e4b0f2? Will be in nightly build after 5.8.3 release Seabstien |
|
Thanks! I'll test it when its available in a release. |
|
Hi, Now available in nightly build Any feedback is welcome Sebastien |
|
Hi Sebastien, great, thanks! I've installed sogo=5.8.3.20230531-1 and will report in the next days if this solves the problem. Kind regards Markus |
|
Hi Markus, there is still an issue fixed in ticket 0005777. Please test next nightly build Sebastien |
|
Hi Sebastien, thanks for the hint, installed sogo=5.8.3.20230601-1. Kind regards Markus |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2023-01-25 13:18 | MIT | New Issue | |
2023-01-25 15:41 | sebastien | Note Added: 0016598 | |
2023-05-08 06:56 | Waschbuesch | Note Added: 0016946 | |
2023-05-09 07:36 | schmirl | Note Added: 0016950 | |
2023-05-10 07:09 | sebastien | Note Added: 0016951 | |
2023-05-10 07:20 | MIT | Note Added: 0016952 | |
2023-05-17 09:51 | sebastien | Note Added: 0016963 | |
2023-05-17 09:51 | sebastien | Assigned To | => sebastien |
2023-05-17 09:51 | sebastien | Status | new => feedback |
2023-05-17 09:52 | sebastien | Relationship added | related to 0005770 |
2023-05-18 19:14 | MIT | Note Added: 0016964 | |
2023-05-18 19:14 | MIT | Status | feedback => assigned |
2023-05-31 06:48 | sebastien | Note Added: 0016987 | |
2023-05-31 06:48 | sebastien | Status | assigned => feedback |
2023-06-01 09:59 | MIT | Note Added: 0016988 | |
2023-06-01 09:59 | MIT | Status | feedback => assigned |
2023-06-01 19:15 | sebastien | Note Added: 0016993 | |
2023-06-01 19:15 | sebastien | Status | assigned => feedback |
2023-06-02 07:29 | MIT | Note Added: 0016994 | |
2023-06-02 07:29 | MIT | Status | feedback => assigned |
2023-06-05 07:36 | sebastien | Status | assigned => resolved |
2023-06-05 07:36 | sebastien | Resolution | open => fixed |
2023-06-05 07:36 | sebastien | Fixed in Version | => 5.9.0 |