Hi Marcus,
Can you try next nightly build ?
Sebastien
Le Jeudi, Juin 01, 2023 13:24 CEST, "Marcus MERIGHI" (mcmer-s...@tor.at)
<users@sogo.nu> a écrit:
Hallo!
I'm seeing an error in my log files regarding a strange calendar entry.
I figure the entry is a somewhat bogus one:
c_cycleenddate = 2147483647 => Tue Jan 19 04:14:07 CET 2038
c_startdate = 4181696896 => Fri Jul 7 08:28:16 CEST 2102
c_enddate = -113184001 => Wed Jun 1 00:59:59 CET 1966
I.e., it starts 2102 and ends 1966.
This calendar entry is probably semantically broken.
And it breaks database rules when beeing saved, see below.
I'd like to get rid of the error, of course.
What can I do?
postgresql: ERROR: integer out of range
postgresql:
STATEMENT: UPDATE sogo_quick_appointment SET c_iscycle = 1, c_orgmail = '',
c_uid = 'fc92474b-c286-4de4-816e-26a65ab86e0a', c_nextalarm = 1717105500,
c_name = 'fc92474b-c286-4de4-816e-26a65ab86e0a.ics', c_category = null,
c_priority = 5, c_cycleinfo = '{rules =
("FREQ=YEARLY;BYMONTH=5;BYMONTHDAY=31"); }', c_sequence = 2, c_isallday = 1,
c_title = 'FooBar BarFoo', c_cycleenddate = 2147483647, c_description = '',
c_status = 1, c_classification = 0, c_startdate = 4181696896, c_participants =
'', c_partmails = '', c_partstates = '', c_component = 'vevent', c_location =
'', c_isopaque = 0, c_enddate = -113184001 WHERE c_folder_id = 68952 AND c_name
= 'fc92474b-c286-4de4-816e-26a65ab86e0a.ics'
sogo:
<0x0x7d5a0fd2288[GCSFolder]>
ERROR(-[GCSFolderwriteContent:fromComponent:container:toName:baseVersion:]):
cannot update content : <PostgreSQL72Exception:
0x7d5bd161688>NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x7d55137b408[PostgreSQL72Channel]:
connection=<0x0x7d61c9fcd48[PGConnection]: connection=0x0x7d5b5c39800>>):
ERROR: integer out of range
sogo:
[ERROR]
<0x7d55f83b308[SOGoAppointmentObject]:fc92474b-c286-4de4-816e-26a65ab86e0a.ics>
write failed: <PostgreSQL72Exception: 0x7d5bd161688>
NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x7d55137b408[PostgreSQL72Channel]:
connection=<0x0x7d61c9fcd48[PGConnection]: connection=0x0x7d5b5c39800>>):
ERROR: integer out of range
Thanks in advance, Marcus
