Glad to help 😊
From: users-requ...@sogo.nu <users-requ...@sogo.nu> On Behalf Of "Raoul Schroeder" Sent: lundi 11 septembre 2023 15:31 To: users@sogo.nu Subject: AW: [SOGo] Problems with calendar view Holy moly. Upon deeper inspection, I noticed some collations where utf8mb4_general_ci and some were utf8mb4_bin No idea how that happened. The only thing I can think of is that SOGo made tables before I changed the collation over. In any case, I changed all the collations to utf8mb4_unicode_ci, and now everything works. I have to admit, I am not sure why just having differing collations caused that error, as the encoding was always utf8mb4. Thanks for your help! I would have never guessed an encoding issue without the debugging session. Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert Gesendet: Montag, 11. September 2023 14:26 An: users@sogo.nu <mailto:users@sogo.nu> Betreff: RE: [SOGo] Problems with calendar view Yes there is clearly an encoding problem, when I do the same with the ics you gave: theRecord = {"c_category" = "<null>"; "c_classification" = 0; "c_component" = vevent; "c_content" = "BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 5.8.4//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Berlin LAST-MODIFIED:20230523T092157Z X-LIC-LOCATION:Europe/Berlin BEGIN:DAYLIGHT TZNAME:CEST TZOFFSETFROM:+0100 TZOFFSETTO:+0200 DTSTART:19700329T020000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZNAME:CET TZOFFSETFROM:+0200 TZOFFSETTO:+0100 DTSTART:19701025T030000 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:4287-64F86880-1-169365E0 SUMMARY:Test Neu LOCATION:Test CLASS:PUBLIC X-SOGO-SEND-APPOINTMENT-NOTIFICATIONS:NO TRANSP:OPAQUE DTSTART;TZID=Europe/Berlin:20230906T140000 DTEND;TZID=Europe/Berlin:20230906T150000 CREATED:20230906T115528Z DTSTAMP:20230906T115528Z LAST-MODIFIED:20230906T115528Z END:VEVENT END:VCALENDAR"; "c_creationdate" = 1694433479; "c_cycleinfo" = "<null>"; "c_description" = ""; "c_enddate" = 1694005200; "c_folder" = personal; "c_isallday" = 0; "c_iscycle" = 0; "c_isopaque" = 1; "c_lastmodified" = 1694433479; "c_location" = Test; "c_name" = "4287-64F86880-1-169365E0.ics"; "c_nextalarm" = 0; "c_orgmail" = ""; "c_owner" = "sogo-tests2"; "c_participants" = ""; "c_partmails" = ""; "c_partstates" = ""; "c_priority" = 0; "c_sequence" = 0; "c_startdate" = 1694001600; "c_status" = 1; "c_title" = "Test Neu"; "c_uid" = "4287-64F86880-1-169365E0"; "c_version" = 0; calendarName = "Agenda personnel"; editable = 1; endDate = "2023-09-06 15:00:00 +0200"; erasable = 1; owner = "<0x0x555555e10f10[SOGoUser]: login=sogo-tests2 roles=Authenticated,Anonymous>"; ownerIsOrganizer = 0; startDate = "2023-09-06 14:00:00 +0200"; startHour = "14:00"; viewable = 1; } And: From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> On Behalf Of "Raoul Schroeder" Sent: lundi 11 septembre 2023 13:11 To: users@sogo.nu <mailto:users@sogo.nu> Subject: AW: [SOGo] Problems with calendar view Thanks for your help. I have to admit that I am completely out of my depth here. Should I maybe open a bug report after all? The database table type: | c_partmails | text | YES | | NULL | | Which is correct as per the current schemes The Record looks really strange: First of all, c_partmails is just hex-numbers: "c_partmails" = <72616f75 6c2e7363 68726f65 64657240 6e616365 6c6c652e 6575>; Or is that just the encoding of the database? Mine is: +--------------------------+----------------------+ | @@character_set_database | @@collation_database | +--------------------------+----------------------+ | utf8mb4 | utf8mb4_bin | +--------------------------+----------------------+ Which I think is the currently preferred collation, although I have also seen: utf8mb4_unicode_ci The whole thing looks like this: Breakpoint 3, -[UIxCalListingActions _fixParticipants:] (self=0x5555561b05d0, _cmd=0x7ffff2640230 <_OBJC_SELECTOR_TABLE+1200>, theRecord=0x555555d8e700) at UIxCalListingActions.m:381 381 UIxCalListingActions.m: No such file or directory. (gdb) po theRecord {"c_category" = "<null>"; "c_classification" = 0; "c_component" = vevent; "c_content" = <42454749 4e3a5643 414c454e 4441520d 0a50524f 4449443a 4d696372 6f736f66 74204578 6368616e 67652053 65727665 72203230 31300d0a 56455253 494f4e3a 322e300d 0a4d4554 484f443a 52455155 4553540d 0a424547 494e3a56 54494d45 5a4f4e45 0d0a545a 49443a57 2e204575 726f7065 20537461 6e646172 64205469 6d650d0a 42454749 4e3a5354 414e4441 52440d0a 44545354 4152543a 31363031 30313031 54303330 3030300d 0a545a4f 46465345 5446524f 4d3a2b30 3230300d 0a545a4f 46465345 54544f3a 2b303130 300d0a52 52554c45 3a465245 513d5945 41524c59 3b494e54 45525641 4c3d313b 42594d4f 4e54483d 31303b42 59444159 3d2d3153 550d0a45 4e443a53 54414e44 4152440d 0a424547 494e3a44 41594c49 4748540d 0a445453 54415254 3a313630 31303130 31543032 30303030 0d0a545a 4f464653 45544652 4f4d3a2b 30313030 0d0a545a 4f464653 4554544f 3a2b3032 30300d0a 5252554c 453a4652 45513d59 4541524c 593b494e 54455256 414c3d31 3b42594d 4f4e5448 3d333b42 59444159 3d2d3153 550d0a45 4e443a44 41594c49 4748540d 0a454e44 3a565449 4d455a4f 4e450d0a 42454749 4e3a5645 56454e54 0d0a4f52 47414e49 5a45523b 434e3d22 47617262 6f732c20 44722e20 4d617274 696e223a 6d61696c 746f3a6d 61727469 6e2e6761 72626f73 40657572 612d6167 2e64650d 0a415454 454e4445 453b434e 3d72616f 756c2e73 6368726f 65646572 406e6163 656c6c65 2e65753b 50415254 53544154 3d414343 45505445 443b524f 4c453d52 45512d50 41525449 43495041 0d0a204e 543a6d61 696c746f 3a72616f 756c2e73 6368726f 65646572 406e6163 656c6c65 2e65750d 0a444553 43524950 54494f4e 3b4c414e 47554147 453d6465 2d44453a 5c6e5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 0d0a205f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5c6e4d 6963726f 736f6674 20546561 6d732d42 65737072 65636875 6e675c6e 4e65686d 656e2053 690d0a20 65206175 66206465 6d20436f 6d707574 65725c2c 20696e20 64657220 6d6f6269 6c656e20 41707020 6f646572 20696d20 5261756d 676572c3 a4742074 65696c5c 6e486965 72206b6c 69636b0d 0a20656e 5c2c2075 6d20616e 20646572 20426573 70726563 68756e67 20746569 6c7a756e 65686d65 6e3c6874 7470733a 2f2f7465 616d732e 6d696372 6f736f66 742e636f 6d2f6c2f 6d656574 0d0a2075 702d6a6f 696e2f31 39253361 6d656574 696e675f 4e445177 4f546732 59544d74 4d444d7a 5a693030 4d446b35 4c574669 4e444174 596a5531 5a575178 4f575a6a 59575935 25343074 680d0a20 72656164 2e76322f 303f636f 6e746578 743d2537 62253232 54696425 32322533 61253232 65616365 62343765 2d376430 662d3438 32372d39 3732332d 36646365 64633439 32326263 25320d0a 20322532 63253232 4f696425 32322533 61253232 66376463 36353037 2d633631 322d3463 66612d38 6661312d 61303061 32326536 63636339 25323225 37643e5c 6e426573 70726563 68756e0d 0a206773 2d49443a 20333238 20343635 20313537 20373534 5c6e5061 7373636f 64653a20 5878446d 66635c6e 5465616d 73206865 72756e74 65726c61 64656e3c 68747470 733a2f2f 7777772e 0d0a206d 6963726f 736f6674 2e636f6d 2f656e2d 75732f6d 6963726f 736f6674 2d746561 6d732f64 6f776e6c 6f61642d 6170703e 207c2049 6d205765 62206265 69747265 74656e3c 68747470 730d0a20 3a2f2f77 77772e6d 6963726f 736f6674 2e636f6d 2f6d6963 726f736f 66742d74 65616d73 2f6a6f69 6e2d612d 6d656574 696e673e 5c6e5b68 74747073 3a2f2f77 77772e65 7572612d 61670d0a 202e636f 6d2f6875 6266732f 4c6f676f 732f4575 72412532 304c6f67 6f2e6a70 675d5c6e 5669656c 656e2044 616e6b5c 2c206461 73732053 69652061 6e206569 6e657220 42657370 7265630d 0a206875 6e672064 65722045 75724120 41472074 65696c6e 65686d65 6e2e5c6e 57656974 65726520 496e666f 733c6874 7470733a 2f2f616b 612e6d73 2f4a6f69 6e546561 6d734d65 6574696e 0d0a2067 3e207c20 42657370 72656368 756e6773 6f707469 6f6e656e 3c687474 7--Type <RET> for more, q to quit, c to continue without paging--c 0733a2f 2f746561 6d732e6d 6963726f 736f6674 2e636f6d 2f6d6565 74696e67 4f707469 6f6e732f 3f6f7267 610d0a20 6e697a65 7249643d 66376463 36353037 2d633631 322d3463 66612d38 6661312d 61303061 32326536 63636339 2674656e 616e7449 643d6561 63656234 37652d37 6430662d 34383237 2d390d0a 20373233 2d366463 65646334 39323262 63267468 72656164 49643d31 395f6d65 6574696e 675f4e44 51774f54 67325954 4d744d44 4d7a5a69 30304d44 6b354c57 46694e44 4174596a 55315a0d 0a205751 784f575a 6a595759 35407468 72656164 2e763226 6d657373 61676549 643d3026 6c616e67 75616765 3d64652d 44453e20 7c205265 6368746c 69636865 2048696e 77656973 653c6874 0d0a2074 70733a2f 2f777777 2e657572 612d6167 2e64652f 6a2f7072 69766163 793e5c6e 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f0d0a20 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5c 6e5c6e0d 0a554944 3a303430 30303030 30383230 30453030 30373443 35423731 30314138 32453030 38303030 30303030 30313044 37344634 43374545 31443930 31303030 30303030 30303030 30303030 0d0a2030 31303030 30303030 36464642 39443038 39374444 46303442 42464330 45423531 37363636 39414435 0d0a5355 4d4d4152 593b4c41 4e475541 47453d64 652d4445 3a417573 74617573 6368207a 75204665 65646261 636b205a 494d2044 530d0a44 54535441 52543b54 5a49443d 572e2045 75726f70 65205374 616e6461 72642054 696d653a 32303233 30393131 54303933 3030300d 0a445445 4e443b54 5a49443d 572e2045 75726f70 65205374 616e6461 72642054 696d653a 32303233 30393131 54313030 3030300d 0a434c41 53533a50 55424c49 430d0a50 52494f52 4954593a 350d0a44 54535441 4d503a32 30323330 39303754 30393238 30325a0d 0a545241 4e53503a 4f504151 55450d0a 53544154 55533a43 4f4e4649 524d4544 0d0a5345 5155454e 43453a30 0d0a4c4f 43415449 4f4e3b4c 414e4755 4147453d 64652d44 453a4d69 63726f73 6f667420 5465616d 732d4265 73707265 6368756e 670d0a58 2d4d4943 524f534f 46542d43 444f2d41 5050542d 53455155 454e4345 3a300d0a 582d4d49 43524f53 4f46542d 43444f2d 4f574e45 52415050 5449443a 32303437 33313739 39310d0a 582d4d49 43524f53 4f46542d 43444f2d 42555359 53544154 55533a54 454e5441 54495645 0d0a582d 4d494352 4f534f46 542d4344 4f2d494e 54454e44 45445354 41545553 3a425553 590d0a58 2d4d4943 524f534f 46542d43 444f2d41 4c4c4441 59455645 4e543a46 414c5345 0d0a582d 4d494352 4f534f46 542d4344 4f2d494d 504f5254 414e4345 3a310d0a 582d4d49 43524f53 4f46542d 43444f2d 494e5354 54595045 3a300d0a 582d4d49 43524f53 4f46542d 534b5950 45544541 4d534d45 4554494e 4755524c 3a687474 70733a2f 2f746561 6d732e6d 6963726f 736f6674 2e636f6d 2f6c2f6d 65657475 702d6a6f 696e2f0d 0a203139 2533616d 65657469 6e675f4e 4451774f 54673259 544d744d 444d7a5a 6930304d 446b354c 5746694e 44417459 6a55315a 5751784f 575a6a59 57593525 34307468 72656164 2e76322f 0d0a2030 3f636f6e 74657874 3d253762 25323254 69642532 32253361 25323265 61636562 3437652d 37643066 2d343832 372d3937 32332d36 64636564 63343932 32626325 32322532 63253232 4f0d0a20 69642532 32253361 25323266 37646336 3530372d 63363132 2d346366 612d3866 61312d61 30306132 32653663 63633925 32322537 640d0a58 2d4d4943 524f534f 46542d53 43484544 554c494e 47534552 56494345 55504441 54455552 4c3a6874 7470733a 2f2f6170 692e7363 68656475 6c65722e 7465616d 732e6d69 63726f73 6f660d0a 20742e63 6f6d2f74 65616d73 2f656163 65623437 652d3764 30662d34 3832372d 39373233 2d366463 65646334 39323262 632f6637 64633635 30372d63 3631322d 34636661 2d386661 312d610d 0a203030 61323265 36636363 392f3139 5f6d6565 74696e67 5f4e4451 774f5467 3259544d 744d444d 7a5a6930 304d446b 354c5746 694e4441 74596a55 315a5751 784f575a 6a595759 35407468 0d0a2072 6561642e 76322f30 0d0a582d 4d494352 4f534f46 542d534b 59504554 45414d53 50524f50 45525449 45533a7b 22636964 223a2231 393a6d65 6574696e 675f4e44 51774f54 67325954 4d744d44 4d7a5a69 30304d44 6b0d0a20 354c5746 694e4441 74596a55 315a5751 784f575a 6a595759 35407468 72656164 2e763222 5c2c2270 72697661 7465223a 74727565 5c2c2274 79706522 3a305c2c 226d6964 223a305c 2c220d0a 20726964 223a305c 2c227569 64223a6e 756c6c7d 0d0a582d 4d494352 4f534f46 542d444f 4e4f5446 4f525741 52444d45 4554494e 473a4641 4c53450d 0a582d4d 4943524f 534f4654 2d444953 414c4c4f 572d434f 554e5445 523a4641 4c53450d 0a582d4d 4943524f 534f4654 2d524551 55455354 45444154 54454e44 414e4345 4d4f4445 3a444546 41554c54 0d0a582d 4d494352 4f534f46 542d4c4f 43415449 4f4e533a 5b207b20 22446973 706c6179 4e616d65 22203a20 224d6963 726f736f 66742054 65616d73 2d426573 70726563 68756e67 225c2c20 220d0a20 4c6f6361 74696f6e 416e6e6f 74617469 6f6e2220 3a202222 5c2c2022 4c6f6361 74696f6e 536f7572 63652220 3a20305c 2c202255 6e726573 6f6c7665 6422203a 2066616c 73655c2c 20220d0a 204c6f63 6174696f 6e557269 22203a20 2222207d 205d0d0a 4c415354 2d4d4f44 49464945 443a3230 32333039 31315430 37353933 395a0d0a 42454749 4e3a5641 4c41524d 0d0a4445 53435249 5054494f 4e3a5245 4d494e44 45520d0a 41435449 4f4e3a44 4953504c 41590d0a 54524947 4745523b 56414c55 453d4455 52415449 4f4e3a2d 50543135 4d0d0a45 4e443a56 414c4152 4d0d0a45 4e443a56 4556454e 540d0a45 4e443a56 43414c45 4e444152>; "c_creationdate" = 1694079054; "c_cycleinfo" = "<null>"; "c_description" = <0a5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f0a4d69 63726f73 6f667420 5465616d 732d4265 73707265 6368756e 670a4e65 686d656e 20536965 20617566 2064656d 20436f6d 70757465 722c2069 6e206465 72206d6f 62696c65 6e204170 70206f64 65722069 6d205261 756d6765 72c3a474 20746569 6c0a4869 6572206b 6c69636b 656e2c20 756d2061 6e206465 72204265 73707265 6368756e 67207465 696c7a75 6e65686d 656e3c68 74747073 3a2f2f74 65616d73 2e6d6963 726f736f 66742e63 6f6d2f6c 2f6d6565 7475702d 6a6f696e 2f313925 33616d65 6574696e 675f4e44 51774f54 67325954 4d744d44 4d7a5a69 30304d44 6b354c57 46694e44 4174596a 55315a57 51784f57 5a6a5957 59352534 30746872 6561642e 76322f30 3f636f6e 74657874 3d253762 25323254 69642532 32253361 25323265 61636562 3437652d 37643066 2d343832 372d3937 32332d36 64636564 63343932 32626325 32322532 63253232 4f696425 32322533 61253232 66376463 36353037 2d633631 322d3463 66612d38 6661312d 61303061 32326536 63636339 25323225 37643e0a 42657370 72656368 756e6773 2d49443a 20333238 20343635 20313537 20373534 0a506173 73636f64 653a2058 78446d66 630a5465 616d7320 68657275 6e746572 6c616465 6e3c6874 7470733a 2f2f7777 772e6d69 63726f73 6f66742e 636f6d2f 656e2d75 732f6d69 63726f73 6f66742d 7465616d 732f646f 776e6c6f 61642d61 70703e20 7c20496d 20576562 20626569 74726574 656e3c68 74747073 3a2f2f77 77772e6d 6963726f 736f6674 2e636f6d 2f6d6963 726f736f 66742d74 65616d73 2f6a6f69 6e2d612d 6d656574 696e673e 0a5b6874 7470733a 2f2f7777 772e6575 72612d61 672e636f 6d2f6875 6266732f 4c6f676f 732f4575 72412532 304c6f67 6f2e6a70 675d0a56 69656c65 6e204461 6e6b2c20 64617373 20536965 20616e20 65696e65 72204265 73707265 6368756e 67206465 72204575 72412041 47207465 696c6e65 686d656e 2e0a5765 69746572 6520496e 666f733c 68747470 733a2f2f 616b612e 6d732f4a 6f696e54 65616d73 4d656574 696e673e 207c2042 65737072 65636875 6e67736f 7074696f 6e656e3c 68747470 733a2f2f 7465616d 732e6d69 63726f73 6f66742e 636f6d2f 6d656574 696e674f 7074696f 6e732f3f 6f726761 6e697a65 7249643d 66376463 36353037 2d633631 322d3463 66612d38 6661312d 61303061 32326536 63636339 2674656e 616e7449 643d6561 63656234 37652d37 6430662d 34383237 2d393732 332d3664 63656463 34393232 62632674 68726561 6449643d 31395f6d 65657469 6e675f4e 4451774f 54673259 544d744d 444d7a5a 6930304d 446b354c 5746694e 44417459 6a55315a 5751784f 575a6a59 57593540 74687265 61642e76 32266d65 73736167 6549643d 30266c61 6e677561 67653d64 652d4445 3e207c20 52656368 746c6963 68652048 696e7765 6973653c 68747470 733a2f2f 7777772e 65757261 2d61672e 64652f6a 2f707269 76616379 3e0a5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f5f5f 5f5f0a0a>; "c_enddate" = 1694419200; "c_folder" = personal; "c_isallday" = 0; "c_iscycle" = 0; "c_isopaque" = 1; "c_lastmodified" = 1694419179; "c_location" = "Microsoft Teams-Besprechung"; "c_name" = "040000008200E00074C5B7101A82E0080000000010D74F4C7EE1D9010000000000000000100000006FFB9D0897DDF04BBFC0EB5176669AD5.ics"; "c_nextalarm" = 1694416500; "c_orgmail" = "CorrectEmailAddress"; "c_owner" = aaaaaaa; "c_participants" = <72616f75 6c2e7363 68726f65 64657240 6e616365 6c6c652e 6575>; "c_partmails" = <72616f75 6c2e7363 68726f65 64657240 6e616365 6c6c652e 6575>; "c_partstates" = <31>; "c_priority" = 5; "c_sequence" = 0; "c_startdate" = 1694417400; "c_status" = 1; "c_title" = "CorrectTitle"; "c_uid" = 040000008200E00074C5B7101A82E0080000000010D74F4C7EE1D9010000000000000000100000006FFB9D0897DDF04BBFC0EB5176669AD5; "c_version" = 3; calendarName = "Pers\U00F6nlicher Kalender"; editable = 1; endDate = "2023-09-11 10:00:00 +0200"; erasable = 1; owner = "<0x0x555555e612d0[SOGoUser]: login=aaaaaaa roles=Authenticated,Anonymous>"; ownerIsOrganizer = 0; startDate = "2023-09-11 09:30:00 +0200"; startHour = "09:30"; viewable = 1; } Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert Gesendet: Montag, 11. September 2023 11:52 An: users@sogo.nu <mailto:users@sogo.nu> Betreff: RE: [SOGo] Problems with calendar view The problem seems to be here line 381 https://github.com/Alinto/sogo/blob/master/UI/Scheduler/UIxCalListingActions.m mails = [[theRecord objectForKey: @"c_partmails"] componentsSeparatedByString: @"\n"]; My guess is the value for c_partmails is not a NSString as expected. You cand add a breakpoint there and cheking the value of theRecord: break UI/Scheduler/UIxCalListingActions.m:381 y run Then when stopped : po theRecord You could also check in your database the type of column “c_partmails” from table “sogo_quick_appointment”. Regards, Quentin From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > On Behalf Of "Raoul Schroeder" Sent: dimanche 10 septembre 2023 14:25 To: users@sogo.nu <mailto:users@sogo.nu> Subject: AW: [SOGo] Problems with calendar view Thanks for the gdb instructions. So, when opening the view, once again it happens in alarmlist: Sep 10 14:06:27 sogod [191697]: 2a01:c22:d4a8:ec00:6919:24c2:ed24:5281 "GET /SOGo/so/bbbbbb/Calendar/alarmslist?browserTime=1694347587 HTTP/1.1" 200 204/0 0.007 - - 0 - 12 WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. Breakpoint 1, -[NSException raise] (self=0x555555f62f40, _cmd=0x7ffff7339fe0 <_OBJC_SELECTOR_TABLE+480>) at ./Source/NSException.m:1595 1595 ./Source/NSException.m: No such file or directory. (Is the “no such file or directory an issue”? I did follow the symbol install to the letter) The bt looks like this: (gdb) bt #0 -[NSException raise] (self=0x555555f62f40, _cmd=0x7ffff7339fe0 <_OBJC_SELECTOR_TABLE+480>) at ./Source/NSException.m:1595 #1 0x00007ffff6ff593a in +[NSException raise:format:arguments:] (self=<optimized out>, _cmd=<optimized out>, name=0x7ffff733a990 <_OBJC_INSTANCE_5>, format=<optimized out>, argList=0x7fffffffb610) at ./Source/NSException.m:1487 #2 0x00007ffff6ff6639 in +[NSException raise:format:] (self=0x7ffff733a320 <_OBJC_Class_NSException>, _cmd=<optimized out>, name=0x7ffff733a990 <_OBJC_INSTANCE_5>, format=0x7ffff73753d0 <_OBJC_INSTANCE_11.19>) at ./Source/NSException.m:1472 #3 0x00007ffff705ca6e in -[NSObject doesNotRecognizeSelector:] (self=0x555555721a60, _cmd=<optimized out>, aSelector=<optimized out>) at ./Source/NSObject.m:1740 #4 0x00007ffff712c288 in GSFFIInvocationCallback (cif=0x555555f7cc40, retp=0x7fffffffb950, args=<optimized out>, user=<optimized out>) at ./Source/GSFFIInvocation.m:606 #5 0x00007ffff5d4e7ec in ?? () from /lib/x86_64-linux-gnu/libffi.so.8 #6 0x00007ffff5d4f050 in ?? () from /lib/x86_64-linux-gnu/libffi.so.8 #7 0x00007ffff2614765 in -[UIxCalListingActions _fixParticipants:] (self=0x555555f92c00, _cmd=0x7ffff2640230 <_OBJC_SELECTOR_TABLE+1200>, theRecord=0x5555560c41d0) at UIxCalListingActions.m:381 #8 0x00007ffff26161bd in -[UIxCalListingActions _fetchFields:forComponentOfType:] (self=0x555555f92c00, _cmd=0x7ffff26403a0 <_OBJC_SELECTOR_TABLE+1568>, fields=0x555555722910, component=0x7ffff263ede0 <_OBJC_INSTANCE_74.52>) at UIxCalListingActions.m:621 #9 0x00007ffff2619a22 in -[UIxCalListingActions eventsBlocksAction] (self=0x555555f92c00, _cmd=0x555556066870) at UIxCalListingActions.m:1462 #10 0x00007ffff7966f0c in -[WODirectAction performActionNamed:] (self=0x555555f92c00, _cmd=0x7ffff27f6f90 <_OBJC_SELECTOR_TABLE+720>, _actionName=0x555555fba690) at WODirectAction.m:97 #11 0x00007ffff27e1bda in -[SOGoDirectAction performActionNamed:] (self=0x555555f92c00, _cmd=0x7ffff7b45cc0 <_OBJC_SELECTOR_TABLE+928>, _actionName=0x5555558d9270) at SOGoDirectAction.m:271 #12 0x00007ffff7a05f4a in -[SoActionInvocation callOnObject:withPositionalParametersWhenNotNil:inContext:] ( self=0x5555557261f0, _cmd=0x7ffff7b45cf0 <_OBJC_SELECTOR_TABLE+976>, _client=0x5555556caac0, _positionalArgs=0x0, _ctx=0x55555621d850) at SoActionInvocation.m:300 #13 0x00007ffff7a06097 in -[SoActionInvocation callOnObject:inContext:] (self=0x5555557261f0, _cmd=0x7ffff7b45c10 <_OBJC_SELECTOR_TABLE+752>, _client=0x5555556caac0, _ctx=0x55555621d850) at SoActionInvocation.m:318 #14 0x00007ffff7a05cac in -[SoActionInvocation callOnObject:withPositionalParametersWhenNotNil:inContext:] ( self=0x5555558f1110, _cmd=0x7ffff7b45cf0 <_OBJC_SELECTOR_TABLE+976>, _client=0x5555556caac0, s=0x0, _ctx=0x55555621d850) at SoActionInvocation.m:260 #15 0x00007ffff7a06097 in -[SoActionInvocation callOnObject:inContext:] (self=0x5555558f1110, _cmd=0x7ffff7b3f9c0 <_OBJC_SELECTOR_TABLE+672>, _client=0x5555556caac0, _ctx=0x55555621d850) at SoActionInvocation.m:318 #16 0x00007ffff79ffc0a in -[SoObjectMethodDispatcher dispatchInContext:] (self=0x555555f494a0, _cmd=0x7ffff7b41e60 <_OBJC_SELECTOR_TABLE+1536>, _ctx=0x55555621d850) at SoObjectMethodDispatcher.m:192 #17 0x00007ffff7a02486 in -[SoObjectRequestHandler handleRequest:inContext:session:application:] ( self=0x555555aa1e90, _cmd=0x7ffff7acbc30 <_OBJC_SELECTOR_TABLE+848>, _rq=0x555555a2c070, _ctx=0x55555621d850, _sn=0x0, app=0x55555596e640) at SoObjectRequestHandler.m:584 #18 0x00007ffff797ab78 in -[WORequestHandler handleRequest:] (self=0x555555aa1e90, _cmd=0x7ffff7a941b0 <_OBJC_SELECTOR_TABLE+1616>, _request=0x555555a2c070) at WORequestHandler.m:240 #19 0x00007ffff7934304 in -[WOCoreApplication dispatchRequest:usingHandler:] (self=0x55555596e640, _cmd=0x7ffff7a94200 <_OBJC_SELECTOR_TABLE+1696>, _request=0x555555a2c070, handler=0x555555aa1e90) at WOCoreApplication.m:712 #20 0x00007ffff7934673 in -[WOCoreApplication dispatchRequest:] (self=0x55555596e640, _cmd=0x555555567620 <_OBJC_SELECTOR_TABLE+1664>, _request=0x555555a2c070) at WOCoreApplication.m:752 #21 0x000055555555dafb in -[SOGo dispatchRequest:] (self=0x55555596e640, _cmd=0x7ffff7b31d20 <_OBJC_SELECTOR_TABLE+1760>, _request=0x555555a2c070) at SOGo.m:584 #22 0x00007ffff79ee44f in -[WOHttpTransaction _run] (self=0x555555f237a0, _cmd=0x7ffff7b31d50 <_OBJC_SELECTOR_TABLE+1808>) at WOHttpTransaction.m:566 #23 0x00007ffff79ee821 in -[WOHttpTransaction run] (self=0x555555f237a0, _cmd=0x7ffff7b2e270 <_OBJC_SELECTOR_TABLE+1168>) at WOHttpTransaction.m:619 #24 0x00007ffff79e9d65 in -[WOHttpAdaptor runConnection:] (self=0x55555586ebd0, _cmd=0x7ffff7b2e310 <_OBJC_SELECTOR_TABLE+1328>, _socket=0x555555b0d320) at WOHttpAdaptor.m:373 #25 0x00007ffff79e9fc0 in -[WOHttpAdaptor _handleAcceptedConnection:] (self=0x55555586ebd0, _cmd=0x7ffff7b2e320 <_OBJC_SELECTOR_TABLE+1344>, _connection=0x555555b0d320) at WOHttpAdaptor.m:407 #26 0x00007ffff79ea44d in -[WOHttpAdaptor _handleConnection:] (self=0x55555586ebd0, _cmd=0x7ffff7b2e3c0 <_OBJC_SELECTOR_TABLE+1504>, connection=0x555555b0d320) at WOHttpAdaptor.m:466 #27 0x00007ffff79ea96a in -[WOHttpAdaptor acceptConnection:] (self=0x55555586ebd0, _cmd=0x7ffff7b2e230 <_OBJC_SELECTOR_TABLE+1104>, _notification=0x555555a192d0) at WOHttpAdaptor.m:527 #28 0x00007ffff704da31 in -[NSNotificationCenter _postAndRelease:] (self=0x555555738f40, _cmd=<optimized out>, notification=0x555555a192d0) at ./Source/NSNotificationCenter.m:1198 But I do not think the backtrace is usable without the symbols in NSExceptions.m – at least I presume this is why it says optimized out? Thanks, Raoul Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert Gesendet: Sonntag, 10. September 2023 13:25 An: users@sogo.nu <mailto:users@sogo.nu> Betreff: RE: [SOGo] Problems with calendar view Indeed, nothing wrong with your event. To debug further you could use gdb to add breakpoint. The process is documented here -> https://www.sogo.nu/support/faq/how-do-i-debug-sogo.html Follow the steps to add a breakpoint when any Exception is raised, then get the backtrace to see where in the code it fails. Regards, Quentin From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > On Behalf Of "Raoul Schroeder" Sent: dimanche 10 septembre 2023 11:28 To: users@sogo.nu <mailto:users@sogo.nu> Subject: AW: [SOGo] Problems with calendar view Thank you very much. I was worried no one was going to reply, so thanks for taking notice. It is the latter case, and it does not matter if you create it within Outlook/Android with ActiveSync, or within SOGo web itself. After you create one event, the web view no longer works. I am not sure it is a bug within SOGo, though. Others would have noticed it. I feel like it is an issue with my installation specifically, but there is not enough to the error message for me to understand what would be the underlying issue. Here is a calendar event export from mysql: | 4287-64F86880-1-169365E0.ics | BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 5.8.4//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Berlin LAST-MODIFIED:20230523T092157Z X-LIC-LOCATION:Europe/Berlin BEGIN:DAYLIGHT TZNAME:CEST TZOFFSETFROM:+0100 TZOFFSETTO:+0200 DTSTART:19700329T020000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZNAME:CET TZOFFSETFROM:+0200 TZOFFSETTO:+0100 DTSTART:19701025T030000 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:4287-64F86880-1-169365E0 SUMMARY:Test Neu LOCATION:Test CLASS:PUBLIC X-SOGO-SEND-APPOINTMENT-NOTIFICATIONS:NO TRANSP:OPAQUE DTSTART;TZID=Europe/Berlin:20230906T140000 DTEND;TZID=Europe/Berlin:20230906T150000 CREATED:20230906T115528Z DTSTAMP:20230906T115528Z LAST-MODIFIED:20230906T115528Z END:VEVENT END:VCALENDAR | 1694001328 | 1694001328 | 0 | NULL | Thanks, Raoul Von: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > Im Auftrag von qhivert Gesendet: Sonntag, 10. September 2023 09:27 An: users@sogo.nu <mailto:users@sogo.nu> Betreff: RE: [SOGo] Problems with calendar view Hello, Welcome to SOGo 😊 Very strange behavior. Is the problem when you create an event or when an event has been created and then the calendar view fails? If it’s the first case, check with your browser debug tool the content of the request POST “saveAsAppointment” In the second case, it would be good to see how the event is stored in your database. I strongly suggest you open an issue on https://bugs.sogo.nu. If your account is new, then send an email to b...@sogo.nu <mailto:b...@sogo.nu> with your username so we can enable it to report. Quentin From: users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> <users-requ...@sogo.nu <mailto:users-requ...@sogo.nu> > On Behalf Of "Raoul Schroeder" Sent: jeudi 7 septembre 2023 10:10 To: users@sogo.nu <mailto:users@sogo.nu> Subject: [SOGo] Problems with calendar view Hello all, I am relatively new to SOGo, having used Zarafa/Kopano for over 10 years until they stopped all development to it. It took me a while to figure out the differences between the two systems and getting SOGo to work – especially figuring out how the WOWhelper setting gets overridden, even though it is stated clearly in the documentation. Anyway, I got a problem now that I cannot figure out. My calendar views work perfectly only until there are appointments in it. Then it ends up with request failed, but even with debug settings on, there is very little in terms of error messages. It all comes down to exceptions thrown by malloc: "GET /SOGo/so/aaaaaaa/Calendar/alarmslist?browserTime=1694071570 HTTP/1.1" 200 60/0 0.007 - - 0 - 13 2023-09-07 09:26:14.268 sogod[26468:26468] EXCEPTION: <NSException: 0x55ebf532ec80> NAME:NSInvalidArgumentException REASON:NSDataMalloc(instance) does not recognize componentsSeparatedByString: INFO:(null) Or: "GET /SOGo/so/bbbbbbb/Calendar/alarmslist?browserTime=1694071657 HTTP/1.1" 200 60/0 0.007 - - 0 - 14 2023-09-07 09:27:40.841 sogod[38833:38833] EXCEPTION: <NSException: 0x55ebf53bb0c0> NAME:NSInvalidArgumentException REASON:[NSDataMalloc-jsonRepresentation] should be overridden by subclass INFO:(null) It seems to be consistently happening with the alarmslist, and it looks like NSDataMalloc is getting null pointers? On ActiveSync, I can see the calendar entries on both Outlook 2019 as well as Android I am running on the most recent snapshot of 5.8.4 on Ubuntu 22.04 (5.9 is still masked in the repository) Thanks, Raoul
