Hello Sebastien,
thanks for you time!
> Can you try next nightly build ?
Unfortunately not, this server is heavily used.
Do you see any other options?
Thanks, Marcus
users@sogo.nu (smizr...@alinto.eu), 2023.06.01 (Thu) 17:45 (CEST):
>
> 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
>
>
--
https://www.tor.at/~mcmer/signature.txt
