2023-06-18 12:07:18.606 sogod[51789:51789] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'username' AND c_folder_type = 'Appointment'; 2023-06-18 12:07:18.607 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.607 sogod[51789:51789] SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'username' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-06-18 12:07:18.608 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.611 sogod[51789:51789] SQL: BEGIN; 2023-06-18 12:07:18.611 sogod[51789:51789] query has no results. 2023-06-18 12:07:18.611 sogod[51789:51789] SQL: UPDATE sogo_user_profile SET c_defaults = '{"SOGoCalendarCategoriesColors":{"Statut":"#aaa","Projets":"#aaa","Congés":"#aaa","Jour férié":"#aaa","Congrès":"#aaa","Problèmes":"#aaa","Réunion":"#aaa","Anniversaire":"#aaa","Voyages":"#aaa","Suivis":"#aaa","Fournisseurs":"#aaa","Idées":"#aaa","Préférés":"#aaa","Clients":"#aaa","Appels":"#aaa","Affaire":"#aaa","Divers":"#aaa","Personnel":"#aaa","Compétitions":"#aaa","Cadeaux":"#aaa","Professionnel":"#aaa","Consommation":"#aaa"},"SOGoSieveFilters":[],"SOGoGravatarEnabled":0,"LocaleCode":"fr","SOGoMailComposeFontSize":0,"SOGoMailReceiptNonRecipientAction":"ignore","SOGoMailSynchronizeOnlyDefaultFolders":"0","SOGoMailSortByThreads":"0","SOGoDayStartTime":"08:00","SOGoAlternateAvatar":"none","SOGoLoginModule":"Calendar","SOGoLDAPGroupExpansionEnabled":0,"SOGoCalendarCategories":["Divers", "Fournisseurs", "Cadeaux", "Appels", "Réunion", "Professionnel", "Compétitions", "Projets", "Suivis", "Affaire", "Consommation", "Personnel", "Clients", "Voyages", "Congrès", "Idées", "Jour férié", "Congés", "Anniversaire", "Problèmes", "Préférés", "Statut"],"SOGoTOTPEnabled":0,"emailSeparatorKeys":[9, 13, 186, 188],"SOGoDayEndTime":"18:00","SOGoMailComposeMessageType":"html","SOGoCalendarWeekdays":["SU", "MO", "TU", "WE", "TH", "FR", "SA"],"hasActiveExternalSieveScripts":0,"SOGoShortDateFormat":"%d-%b-%y","SOGoMailSignaturePlacement":"above","SOGoMailMessageForwarding":"inline","ckLocaleCode":"fr","SOGoMailReceiptOutsideDomainAction":"ignore","Forward":{"forwardAddress":[],"enabled":0,"keepCopy":0},"SOGoTimeZone":"Europe/Berlin","SOGoMailReceiptAllow":"1","UserTimeZoneSecondsFromGMT":7200,"SOGoTimeFormat":"%H:%M","Vacation":{"daysBetweenResponse":"7","autoReplyEmailAddresses":["firstname.username@myweb.org", "username@myweb.org", "username@cvz.es"],"enabled":0,"autoReplyText":"","alwaysSend":0,"ignoreLists":1,"days":[],"customSubjectEnabled":0},"SOGoRememberLastModule":1,"SOGoMailMessageCheck":"every_minute","SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoPasswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":"manually","SOGoCalendarDefaultReminder":"NONE","SOGoMailAutoSave":5,"SOGoMailLabelsColors":{"$label5":["Peut attendre", "#993399"],"$label2":["Travail", "#FF9900"],"$label4":["À faire", "#3333FF"],"$label1":["Importante", "#FF0000"],"$label3":["Personnel", "#009900"]},"SOGoLongDateFormat":"%A, %B %d, %Y","SOGoMailReceiptAnyAction":"ignore","SOGoMailAutoMarkAsReadDelay":0,"SOGoBusyOffHours":"0","SOGoDefaultCalendar":"selected","SOGoMailReplyPlacement":"above","SOGoMailShowSubscribedFoldersOnly":"0","SOGoAppointmentSendEMailNotifications":1,"SOGoMailSignature":"" />","SOGoFirstWeekOfYear":"January1","SOGoSelectedAddressBook":"personal","SOGoPasswordRecoveryQuestion":"SecretQuestion1","SOGoAnimationMode":"normal","SOGoCalendarEventsDefaultClassification":"PUBLIC","SOGoMailAddOutgoingAddresses":"0","AuxiliaryMailAccounts":[],"SOGoFirstDayOfWeek":"1","SOGoLanguage":"French","SOGoContactsCategories":["Ami", "Client", "Collègue", "Concurrent", "Famille", "Fournisseur", "Partenaire d\'affaire", "Presse", "VIP"],"SOGoMailDisplayRemoteInlineImages":"never","SOGoMailIdentities":[{"isDefault":1,"email":"firstname.username@myweb.org","fullName":"firstname username","signature":""}]}' WHERE c_uid = 'username'; 2023-06-18 12:07:18.612 sogod[51789:51789] query has no results. 2023-06-18 12:07:18.612 sogod[51789:51789] SQL: COMMIT; 2023-06-18 12:07:18.708 sogod[51789:51789] query has no results. 2023-06-18 12:07:18.710 sogod[51789:51789] SQL: BEGIN; 2023-06-18 12:07:18.710 sogod[51789:51789] query has no results. 2023-06-18 12:07:18.711 sogod[51789:51789] SQL: UPDATE sogo_user_profile SET c_defaults = '{"SOGoCalendarCategoriesColors":{"Statut":"#aaa","Projets":"#aaa","Congés":"#aaa","Jour férié":"#aaa","Congrès":"#aaa","Problèmes":"#aaa","Réunion":"#aaa","Anniversaire":"#aaa","Voyages":"#aaa","Suivis":"#aaa","Fournisseurs":"#aaa","Idées":"#aaa","Préférés":"#aaa","Clients":"#aaa","Appels":"#aaa","Affaire":"#aaa","Divers":"#aaa","Personnel":"#aaa","Compétitions":"#aaa","Cadeaux":"#aaa","Professionnel":"#aaa","Consommation":"#aaa"},"SOGoSieveFilters":[],"SOGoGravatarEnabled":0,"LocaleCode":"fr","SOGoMailComposeFontSize":0,"SOGoMailReceiptNonRecipientAction":"ignore","SOGoMailSynchronizeOnlyDefaultFolders":"0","SOGoMailSortByThreads":"0","SOGoDayStartTime":"08:00","SOGoAlternateAvatar":"none","SOGoLoginModule":"Calendar","SOGoLDAPGroupExpansionEnabled":0,"SOGoCalendarCategories":["Divers", "Fournisseurs", "Cadeaux", "Appels", "Réunion", "Professionnel", "Compétitions", "Projets", "Suivis", "Affaire", "Consommation", "Personnel", "Clients", "Voyages", "Congrès", "Idées", "Jour férié", "Congés", "Anniversaire", "Problèmes", "Préférés", "Statut"],"SOGoTOTPEnabled":0,"emailSeparatorKeys":[9, 13, 186, 188],"SOGoDayEndTime":"18:00","SOGoMailComposeMessageType":"html","SOGoCalendarWeekdays":["SU", "MO", "TU", "WE", "TH", "FR", "SA"],"hasActiveExternalSieveScripts":0,"SOGoShortDateFormat":"%d-%b-%y","SOGoMailSignaturePlacement":"above","SOGoMailMessageForwarding":"inline","ckLocaleCode":"fr","SOGoMailReceiptOutsideDomainAction":"ignore","Forward":{"forwardAddress":[],"enabled":0,"keepCopy":0},"SOGoTimeZone":"Europe/Berlin","SOGoMailReceiptAllow":"1","UserTimeZoneSecondsFromGMT":7200,"SOGoTimeFormat":"%H:%M","Vacation":{"daysBetweenResponse":"7","autoReplyEmailAddresses":["firstname.username@myweb.org", "username@myweb.org", "username@cvz.es"],"enabled":0,"autoReplyText":"","alwaysSend":0,"ignoreLists":1,"days":[],"customSubjectEnabled":0},"SOGoRememberLastModule":1,"SOGoMailMessageCheck":"every_minute","SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoPasswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":"manually","SOGoCalendarDefaultReminder":"NONE","SOGoMailAutoSave":5,"SOGoMailLabelsColors":{"$label5":["Peut attendre", "#993399"],"$label2":["Travail", "#FF9900"],"$label4":["À faire", "#3333FF"],"$label1":["Importante", "#FF0000"],"$label3":["Personnel", "#009900"]},"SOGoLongDateFormat":"%A, %B %d, %Y","SOGoMailReceiptAnyAction":"ignore","SOGoMailAutoMarkAsReadDelay":0,"SOGoBusyOffHours":"0","SOGoDefaultCalendar":"selected","SOGoMailReplyPlacement":"above","SOGoMailShowSubscribedFoldersOnly":"0","SOGoAppointmentSendEMailNotifications":1,"SOGoMailSignature":"","SOGoFirstWeekOfYear":"January1","SOGoSelectedAddressBook":"personal","SOGoPasswordRecoveryQuestion":"SecretQuestion1","SOGoAnimationMode":"normal","SOGoCalendarEventsDefaultClassification":"PUBLIC","SOGoMailAddOutgoingAddresses":"0","AuxiliaryMailAccounts":[],"SOGoFirstDayOfWeek":"1","SOGoLanguage":"French","SOGoContactsCategories":["Ami", "Client", "Collègue", "Concurrent", "Famille", "Fournisseur", "Partenaire d\'affaire", "Presse", "VIP"],"SOGoMailDisplayRemoteInlineImages":"never","SOGoMailIdentities":[{"isDefault":1,"email":"firstname.username@myweb.org","fullName":"firstname username","signature":""}]}' WHERE c_uid = 'username'; 2023-06-18 12:07:18.711 sogod[51789:51789] query has no results. 2023-06-18 12:07:18.711 sogod[51789:51789] SQL: COMMIT; 2023-06-18 12:07:18.712 sogod[51789:51789] query has no results. 2023-06-18 12:07:18.713 sogod[51789:51789] SQL: SELECT c_component, c_status FROM sogosecdir0027040b14f_quick WHERE ((c_component = 'vtodo') AND (c_status != 1) AND (c_status != 3)); 2023-06-18 12:07:18.713 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.714 sogod[51789:51789] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/username/Calendar/92F8-51F13880-9-8CA9BE0'; 2023-06-18 12:07:18.714 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.715 sogod[51789:51789] SQL: SELECT c_component, c_status FROM sogousername00132d7a31b_quick WHERE ((c_component = 'vtodo') AND (c_status != 1) AND (c_status != 3)); 2023-06-18 12:07:18.715 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.715 sogod[51789:51789] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/username/Calendar/personal'; 2023-06-18 12:07:18.716 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.716 sogod[51789:51789] SQL: SELECT c_component, c_status FROM sogousername003078bc0a9_quick WHERE ((c_component = 'vtodo') AND (c_status != 1) AND (c_status != 3)); 2023-06-18 12:07:18.719 sogod[51789:51789] query has results, entering fetch-mode. Jun 18 12:07:18 sogod [51789]: 192.168.73.2 "GET /SOGo/so/username/Calendar/view HTTP/1.1" 200 88252/0 0.132 - - 0 - 14 2023-06-18 12:07:18.901 sogod[51789:51789] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'username' AND c_folder_type = 'Appointment'; 2023-06-18 12:07:18.902 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.902 sogod[51789:51789] SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'username' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-06-18 12:07:18.903 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.904 sogod[51789:51789] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousername003078bc0a9_quick WHERE (((c_nextalarm <= 1687255638) AND (c_nextalarm >= 1687082838)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1687082838) AND (c_enddate > 1687082838))); 2023-06-18 12:07:18.908 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.908 sogod[51789:51789] SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogousername00132d7a31b_quick WHERE (((c_nextalarm <= 1687255638) AND (c_nextalarm >= 1687082838)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1687082838) AND (c_enddate > 1687082838))); 2023-06-18 12:07:18.908 sogod[51789:51789] query has results, entering fetch-mode. Jun 18 12:07:18 sogod [51789]: 192.168.73.2 "GET /SOGo/so/username/Calendar/alarmslist?browserTime=1687082838 HTTP/1.1" 200 475/0 0.011 - - 0 - 14 Jun 18 12:07:18 sogod [51793]: <0x0x56221d42c810[NGImap4Client]> TLS started successfully. 2023-06-18 12:07:18.921 sogod[51789:51789] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'username' AND c_folder_type = 'Appointment'; 2023-06-18 12:07:18.921 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.922 sogod[51789:51789] SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'username' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-06-18 12:07:18.922 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.923 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername003078bc0a9_quick a, sogousername003078bc0a9 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1688335199)) AND ((c_enddate IS NULL) OR (c_enddate >= 1685311200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-06-18 12:07:18.925 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.935 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername003078bc0a9_quick a, sogousername003078bc0a9 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1688335199)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1685311200)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-06-18 12:07:18.941 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.953 sogod[51789:51789] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/username/Calendar/personal'; 2023-06-18 12:07:18.953 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.956 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername00132d7a31b_quick a, sogousername00132d7a31b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1688335199)) AND ((c_enddate IS NULL) OR (c_enddate >= 1685311200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-06-18 12:07:18.956 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:18.956 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername00132d7a31b_quick a, sogousername00132d7a31b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1688335199)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1685311200)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-06-18 12:07:18.957 sogod[51789:51789] query has results, entering fetch-mode. Jun 18 12:07:18 sogod [51793]: 192.168.73.2 "POST /SOGo/so/username/Mail/0/folderINBOX/changes HTTP/1.1" 200 30/126 0.069 - - 0 - 12 Jun 18 12:07:18 sogod [51789]: 192.168.73.2 "GET /SOGo/so/username/Calendar/eventsblocks?ed=20230702&sd=20230529&view=monthview HTTP/1.1" 200 38083/0 0.058 - - 328K - 14 2023-06-18 12:07:19.032 sogod[51789:51789] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'username' AND c_folder_type = 'Appointment'; 2023-06-18 12:07:19.033 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:19.033 sogod[51789:51789] SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'username' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-06-18 12:07:19.034 sogod[51789:51789] query has results, entering fetch-mode. Jun 18 12:07:19 sogod [51789]: 192.168.73.2 "GET /SOGo/so/username/Calendar/monthview?day=20230618¤tday=20230618 HTTP/1.1" 200 42618/0 0.010 - - 0 - 14 Jun 18 12:07:19 sogod [51793]: <0x0x56221d814730[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table Jun 18 12:07:19 sogod [51793]: <0x0x56221d814730[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table 2023-06-18 12:07:19.258 sogod[51789:51789] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'username' AND c_folder_type = 'Appointment'; Jun 18 12:07:19 sogod [51793]: <0x0x56221d814730[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table 2023-06-18 12:07:19.259 sogod[51793:51793] MySQL4 connection established 0x0x56221d4795a0 2023-06-18 12:07:19.259 sogod[51793:51793] ---------- -[MySQL4Channel openChannel]: opens channel count[0] 2023-06-18 12:07:19.259 sogod[51793:51793] MySQL4 channel 0x0x56221d5d2e60 opened (connection=0x0x56221d4795a0,sogo) 2023-06-18 12:07:19.259 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:19.260 sogod[51793:51793] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'username' AND c_folder_type = 'Appointment'; 2023-06-18 12:07:19.260 sogod[51789:51789] SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'username' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-06-18 12:07:19.260 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:19.260 sogod[51793:51793] query has results, entering fetch-mode. 2023-06-18 12:07:19.262 sogod[51789:51789] SQL: BEGIN; 2023-06-18 12:07:19.262 sogod[51789:51789] query has no results. 2023-06-18 12:07:19.262 sogod[51789:51789] SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar":{"FoldersOrder":["secdir_personal", "92F8-51F13880-9-8CA9BE0", "personal"],"View":"monthview","PreventInvitations":0,"FolderShowAlarms":{"secdir:Calendar/personal":0},"FolderColors":{"username:Calendar/92F8-51F13880-9-8CA9BE0":"#AAAAAA","username:Calendar/personal":"#AAAAAA"},"NotifyOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"EventsFilterState":"view_next7","DragHandleVertical":"187","FolderDisplayNames":{"secdir:Calendar/personal":"Calendario personal (Secrétaire Directeur )"},"SelectedList":"eventsListView","FreeBusyExclusions":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"SubscribedFolders":["secdir:Calendar/personal"],"InactiveFolders":["secdir_personal"],"NotifyOnExternalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"NotifyUserOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"PreventInvitationsWhitelist":{},"EventsSortingState":["start", "1"],"NotifiedUserOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":"","username:Calendar/personal":""}},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"09dec6f2e45a34a239fd9343007f66af260f9744","Salt":"47b4d5c1afdf33da11f92bc2d6df268a9f2395b9"},"CalendarDefaultFilter":"view_today","Mail":{"DragHandleHorizontal":"301","ColumnsState":{"priorityHeader":"6","dateHeader":"29","fromHeader":"9","subjectHeader":"44"},"ExpandedFolders":["/0", "/0/folderINBOX"],"DragHandleVertical":"356","SortingState":["date", "0"]}}' WHERE c_uid = 'username'; 2023-06-18 12:07:19.262 sogod[51793:51793] MySQL4 connection established 0x0x56221da8f3a0 2023-06-18 12:07:19.262 sogod[51793:51793] ---------- -[MySQL4Channel openChannel]: opens channel count[1] 2023-06-18 12:07:19.262 sogod[51793:51793] MySQL4 channel 0x0x56221da82510 opened (connection=0x0x56221da8f3a0,sogo) 2023-06-18 12:07:19.262 sogod[51789:51789] query has no results. 2023-06-18 12:07:19.263 sogod[51789:51789] SQL: COMMIT; 2023-06-18 12:07:19.263 sogod[51793:51793] SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'username' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2023-06-18 12:07:19.263 sogod[51793:51793] query has results, entering fetch-mode. 2023-06-18 12:07:19.273 sogod[51789:51789] query has no results. 2023-06-18 12:07:19.274 sogod[51789:51789] SQL: BEGIN; 2023-06-18 12:07:19.274 sogod[51789:51789] query has no results. 2023-06-18 12:07:19.274 sogod[51789:51789] SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar":{"FoldersOrder":["secdir_personal", "92F8-51F13880-9-8CA9BE0", "personal"],"View":"monthview","PreventInvitations":0,"FolderShowAlarms":{"secdir:Calendar/personal":0},"FolderColors":{"username:Calendar/92F8-51F13880-9-8CA9BE0":"#AAAAAA","username:Calendar/personal":"#AAAAAA"},"NotifyOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"EventsFilterState":"view_next7","DragHandleVertical":"187","FolderDisplayNames":{"secdir:Calendar/personal":"Calendario personal (Secrétaire Directeur )"},"SelectedList":"eventsListView","FreeBusyExclusions":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"SubscribedFolders":["secdir:Calendar/personal"],"InactiveFolders":["secdir_personal"],"NotifyOnExternalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"NotifyUserOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"PreventInvitationsWhitelist":{},"EventsSortingState":["start", "1"],"NotifiedUserOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":"","username:Calendar/personal":""}},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"09dec6f2e45a34a239fd9343007f66af260f9744","Salt":"47b4d5c1afdf33da11f92bc2d6df268a9f2395b9"},"CalendarDefaultFilter":"view_today","Mail":{"DragHandleHorizontal":"301","ColumnsState":{"priorityHeader":"6","dateHeader":"29","fromHeader":"9","subjectHeader":"44"},"ExpandedFolders":["/0", "/0/folderINBOX"],"DragHandleVertical":"356","SortingState":["date", "0"]}}' WHERE c_uid = 'username'; 2023-06-18 12:07:19.275 sogod[51789:51789] query has no results. 2023-06-18 12:07:19.275 sogod[51789:51789] SQL: COMMIT; 2023-06-18 12:07:19.275 sogod[51789:51789] query has no results. 2023-06-18 12:07:19.276 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername003078bc0a9_quick a, sogousername003078bc0a9 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1687643999)) AND ((c_enddate IS NULL) OR (c_enddate >= 1687082839)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); Jun 18 12:07:19 sogod [51793]: [WARN] <0x0x7f616ccdef60[WOxElemBuilder]> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder 2023-06-18 12:07:19.284 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:19.284 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername003078bc0a9_quick a, sogousername003078bc0a9 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1687643999)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1687082839)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-06-18 12:07:19.285 sogod[51793:51793] SQL: BEGIN; 2023-06-18 12:07:19.285 sogod[51793:51793] query has no results. 2023-06-18 12:07:19.286 sogod[51793:51793] SQL: UPDATE sogo_user_profile SET c_defaults = '{"SOGoCalendarCategoriesColors":{"Statut":"#aaa","Projets":"#aaa","Congés":"#aaa","Jour férié":"#aaa","Congrès":"#aaa","Problèmes":"#aaa","Réunion":"#aaa","Anniversaire":"#aaa","Voyages":"#aaa","Suivis":"#aaa","Fournisseurs":"#aaa","Idées":"#aaa","Préférés":"#aaa","Clients":"#aaa","Appels":"#aaa","Affaire":"#aaa","Divers":"#aaa","Personnel":"#aaa","Cadeaux":"#aaa","Compétitions":"#aaa","Professionnel":"#aaa","Consommation":"#aaa"},"SOGoSieveFilters":[],"SOGoGravatarEnabled":0,"LocaleCode":"fr","SOGoMailComposeFontSize":0,"SOGoMailReceiptNonRecipientAction":"ignore","SOGoMailSynchronizeOnlyDefaultFolders":"0","SOGoMailSortByThreads":"0","SOGoDayStartTime":"08:00","SOGoAlternateAvatar":"none","SOGoLoginModule":"Calendar","SOGoLDAPGroupExpansionEnabled":0,"SOGoCalendarCategories":["Divers", "Fournisseurs", "Cadeaux", "Appels", "Réunion", "Professionnel", "Compétitions", "Projets", "Suivis", "Affaire", "Consommation", "Personnel", "Clients", "Voyages", "Congrès", "Idées", "Jour férié", "Congés", "Anniversaire", "Problèmes", "Préférés", "Statut"],"SOGoTOTPEnabled":0,"emailSeparatorKeys":[9, 13, 186, 188],"SOGoDayEndTime":"18:00","SOGoMailComposeMessageType":"html","SOGoCalendarWeekdays":["SU", "MO", "TU", "WE", "TH", "FR", "SA"],"hasActiveExternalSieveScripts":0,"SOGoShortDateFormat":"%d-%b-%y","SOGoMailSignaturePlacement":"above","SOGoMailMessageForwarding":"inline","ckLocaleCode":"fr","SOGoMailReceiptOutsideDomainAction":"ignore","Forward":{"forwardAddress":[],"enabled":0,"keepCopy":0},"SOGoTimeZone":"Europe/Berlin","SOGoMailReceiptAllow":"1","UserTimeZoneSecondsFromGMT":7200,"SOGoTimeFormat":"%H:%M","Vacation":{"daysBetweenResponse":"7","enabled":0,"autoReplyEmailAddresses":["firstname.username@myweb.org", "username@myweb.org", "username@cvz.es"],"autoReplyText":"","alwaysSend":0,"days":[],"ignoreLists":1,"customSubjectEnabled":0},"SOGoRememberLastModule":1,"SOGoMailMessageCheck":"every_minute","SOGoCalendarTasksDefaultClassification":"PUBLIC","SOGoPasswordRecoveryMode":"Disabled","SOGoRefreshViewCheck":"manually","SOGoCalendarDefaultReminder":"NONE","SOGoMailAutoSave":5,"SOGoMailLabelsColors":{"$label2":["Travail", "#FF9900"],"$label5":["Peut attendre", "#993399"],"$label1":["Importante", "#FF0000"],"$label4":["À faire", "#3333FF"],"$label3":["Personnel", "#009900"]},"SOGoLongDateFormat":"%A, %B %d, %Y","SOGoMailReceiptAnyAction":"ignore","SOGoMailAutoMarkAsReadDelay":0,"SOGoBusyOffHours":"0","SOGoDefaultCalendar":"selected","SOGoMailReplyPlacement":"above","SOGoMailShowSubscribedFoldersOnly":"0","SOGoAppointmentSendEMailNotifications":1,"SOGoMailSignature":"" />","SOGoFirstWeekOfYear":"January1","SOGoSelectedAddressBook":"personal","SOGoCalendarEventsDefaultClassification":"PUBLIC","SOGoAnimationMode":"normal","SOGoPasswordRecoveryQuestion":"SecretQuestion1","SOGoMailAddOutgoingAddresses":"0","AuxiliaryMailAccounts":[],"SOGoFirstDayOfWeek":"1","SOGoLanguage":"French","SOGoContactsCategories":["Ami", "Client", "Collègue", "Concurrent", "Famille", "Fournisseur", "Partenaire d\'affaire", "Presse", "VIP"],"SOGoMailIdentities":[{"email":"firstname.username@myweb.org","isDefault":1,"fullName":"firstname username","signature":""}],"SOGoMailDisplayRemoteInlineImages":"never"}' WHERE c_uid = 'username'; 2023-06-18 12:07:19.287 sogod[51793:51793] query has no results. 2023-06-18 12:07:19.287 sogod[51793:51793] SQL: COMMIT; 2023-06-18 12:07:19.291 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:19.296 sogod[51793:51793] query has no results. 2023-06-18 12:07:19.297 sogod[51793:51793] SQL: BEGIN; 2023-06-18 12:07:19.297 sogod[51793:51793] query has no results. 2023-06-18 12:07:19.297 sogod[51793:51793] SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar":{"FoldersOrder":["secdir_personal", "92F8-51F13880-9-8CA9BE0", "personal"],"View":"monthview","PreventInvitations":0,"FolderShowAlarms":{"secdir:Calendar/personal":0},"FolderColors":{"username:Calendar/92F8-51F13880-9-8CA9BE0":"#AAAAAA","username:Calendar/personal":"#AAAAAA"},"NotifyOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"EventsFilterState":"view_next7","DragHandleVertical":"187","FolderDisplayNames":{"secdir:Calendar/personal":"Calendario personal (Secrétaire Directeur )"},"SelectedList":"eventsListView","FreeBusyExclusions":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"SubscribedFolders":["secdir:Calendar/personal"],"InactiveFolders":["secdir_personal"],"NotifyOnExternalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"NotifyUserOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":0,"username:Calendar/personal":0},"PreventInvitationsWhitelist":{},"EventsSortingState":["start", "1"],"NotifiedUserOnPersonalModifications":{"username:Calendar/92F8-51F13880-9-8CA9BE0":"","username:Calendar/personal":""}},"Contact":{"SortingState":["c_cn", "1"]},"General":{"PrivateSalt":"09dec6f2e45a34a239fd9343007f66af260f9744","Salt":"47b4d5c1afdf33da11f92bc2d6df268a9f2395b9"},"CalendarDefaultFilter":"view_today","Mail":{"DragHandleHorizontal":"301","ColumnsState":{"priorityHeader":"6","dateHeader":"29","fromHeader":"9","subjectHeader":"44"},"ExpandedFolders":["/0", "/0/folderINBOX"],"DragHandleVertical":"356","SortingState":["date", "0"]}}' WHERE c_uid = 'username'; 2023-06-18 12:07:19.297 sogod[51793:51793] query has no results. 2023-06-18 12:07:19.297 sogod[51793:51793] SQL: COMMIT; 2023-06-18 12:07:19.297 sogod[51793:51793] query has no results. Jun 18 12:07:19 sogod [51793]: 192.168.73.2 "POST /SOGo/so/username/Calendar/saveSelectedList HTTP/1.1" 204 0/25 0.042 - - 4M - 13 2023-06-18 12:07:19.300 sogod[51789:51789] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/username/Calendar/personal'; 2023-06-18 12:07:19.300 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:19.301 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername00132d7a31b_quick a, sogousername00132d7a31b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1687643999)) AND ((c_enddate IS NULL) OR (c_enddate >= 1687082839)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-06-18 12:07:19.302 sogod[51789:51789] query has results, entering fetch-mode. 2023-06-18 12:07:19.302 sogod[51789:51789] SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogousername00132d7a31b_quick a, sogousername00132d7a31b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1687643999)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1687082839)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2023-06-18 12:07:19.302 sogod[51789:51789] query has results, entering fetch-mode. Jun 18 12:07:19 sogod [51789]: 192.168.73.2 "GET /SOGo/so/username/Calendar/eventslist?asc=1&day=20230618&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 6442/0 0.058 - - 0 - 14