View Issue Details

IDProjectCategoryView StatusLast Update
0005794SOGoWeb Mailpublic2023-07-10 20:30
Reportercvz-es Assigned Tosebastien  
PrioritynormalSeverityminorReproducibilityalways
Status assignedResolutionopen 
Product Version5.8.3 
Summary0005794: Webmail calendar showing some events in 1970
Description

Hi all,

Just a short email to report, that we experience a small issue with the latest version (5.8.3.20230616-1)
Several users reported that some events are shown in 1970 through the webmail.
The calendar is also configured from Thunderbird, and the date are fine in Thunderbird.

But as you can see in the screen capture, some events are show in 1970, but if you click on the event from the webmail, the date is fine.

Thanks in advance !

Best
Dam

TagsNo tags attached.

Activities

cvz-es

cvz-es

2023-06-17 15:38

reporter  

webmail.png (13,171 bytes)   
webmail.png (13,171 bytes)   
webmail2.png (13,362 bytes)   
webmail2.png (13,362 bytes)   
sebastien

sebastien

2023-06-18 08:04

administrator   ~0017050

A protection has been added to set timestamp to 0 (01/01/1970) if the event is ovoer or below max int.
You need to enable sql debug and provide log request.

Sebastien

cvz-es

cvz-es

2023-06-25 07:02

reporter   ~0017087

Hi Sebastian,

I repost the requested logs, as it seems it was a bad idea to make it private.

Best
Damien

sogo-2.log (37,499 bytes)   
2023-06-18 12:07:18.606 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:18.607 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.611 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> SQL: BEGIN;
2023-06-18 12:07:18.611 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has no results.
2023-06-18 12:07:18.611 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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":"" /></a>","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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has no results.
2023-06-18 12:07:18.612 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> SQL: COMMIT;
2023-06-18 12:07:18.708 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has no results.
2023-06-18 12:07:18.710 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> SQL: BEGIN;
2023-06-18 12:07:18.710 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has no results.
2023-06-18 12:07:18.711 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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":"<span style=\\"\" /></a>","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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has no results.
2023-06-18 12:07:18.711 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> SQL: COMMIT;
2023-06-18 12:07:18.712 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has no results.
2023-06-18 12:07:18.713 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.714 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:18.715 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.715 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:18.716 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:18.902 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.904 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.908 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.922 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:18.923 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:18.935 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.953 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:18.956 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:18.956 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:19.033 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   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&currentday=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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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]: <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:19.260 sogod[51793:51793] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:19.260 sogod[51793:51793] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0>   query has results, entering fetch-mode.
2023-06-18 12:07:19.262 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> SQL: BEGIN;
2023-06-18 12:07:19.262 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has no results.
2023-06-18 12:07:19.262 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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 <secdir@myweb.org>)"},"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]: <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has no results.
2023-06-18 12:07:19.263 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> SQL: COMMIT;
2023-06-18 12:07:19.263 sogod[51793:51793] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0> 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] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0>   query has results, entering fetch-mode.
2023-06-18 12:07:19.273 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has no results.
2023-06-18 12:07:19.274 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> SQL: BEGIN;
2023-06-18 12:07:19.274 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has no results.
2023-06-18 12:07:19.274 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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 <secdir@myweb.org>)"},"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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has no results.
2023-06-18 12:07:19.275 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> SQL: COMMIT;
2023-06-18 12:07:19.275 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has no results.
2023-06-18 12:07:19.276 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:19.284 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0> SQL: BEGIN;
2023-06-18 12:07:19.285 sogod[51793:51793] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0>   query has no results.
2023-06-18 12:07:19.286 sogod[51793:51793] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0> 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":"" /></a>","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] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0>   query has no results.
2023-06-18 12:07:19.287 sogod[51793:51793] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0> SQL: COMMIT;
2023-06-18 12:07:19.291 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:19.296 sogod[51793:51793] <MySQL4Channel[0x0x56221da82510] connection=0x0x56221da8f3a0>   query has no results.
2023-06-18 12:07:19.297 sogod[51793:51793] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0> SQL: BEGIN;
2023-06-18 12:07:19.297 sogod[51793:51793] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0>   query has no results.
2023-06-18 12:07:19.297 sogod[51793:51793] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0> 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 <secdir@myweb.org>)"},"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] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0>   query has no results.
2023-06-18 12:07:19.297 sogod[51793:51793] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0> SQL: COMMIT;
2023-06-18 12:07:19.297 sogod[51793:51793] <MySQL4Channel[0x0x56221d5d2e60] connection=0x0x56221d4795a0>   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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   query has results, entering fetch-mode.
2023-06-18 12:07:19.301 sogod[51789:51789] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0> 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] <MySQL4Channel[0x0x56221de4e060] connection=0x0x56221de2dde0>   query has results, entering fetch-mode.
2023-06-18 12:07:19.302 sogod[51789:51789] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810> 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] <MySQL4Channel[0x0x56221dd6d9b0] connection=0x0x56221dd84810>   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
sogo-2.log (37,499 bytes)   
sebastien

sebastien

2023-06-27 06:35

administrator   ~0017090

Last edited: 2023-06-27 15:16

I have reproduced the issue only one time with a drag and drop on an event. However I can't reproduce anymore :/

cvz-es

cvz-es

2023-07-10 20:30

reporter   ~0017106

Hi Sebastien,

On 4th of July, I sent you an other calendar by email from my colleague who was experiencing the issue with an higher frequency.
Might be a good study case.
Thanks / Merci
Best
Damien

Issue History

Date Modified Username Field Change
2023-06-17 15:38 cvz-es New Issue
2023-06-17 15:38 cvz-es File Added: webmail.png
2023-06-17 15:38 cvz-es File Added: webmail2.png
2023-06-18 08:04 sebastien Note Added: 0017050
2023-06-18 08:04 sebastien Assigned To => sebastien
2023-06-18 08:04 sebastien Status new => feedback
2023-06-18 10:19 cvz-es Status feedback => assigned
2023-06-25 07:02 cvz-es Note Added: 0017087
2023-06-25 07:02 cvz-es File Added: sogo-2.log
2023-06-27 06:35 sebastien Note Added: 0017090
2023-06-27 15:16 sebastien Note Edited: 0017090
2023-07-10 20:30 cvz-es Note Added: 0017106