Feb 02 09:40:04 sogod [1254]: |SOGo| starting method 'GET' on uri '/SOGo/so/valerio/Calendar/personal/newguid' Feb 02 09:40:04 sogod [1256]: |SOGo| starting method 'GET' on uri '/SOGo/so/valerio/Calendar/UIxAppointmentEditorTemplate' 2016-02-02 09:40:04.544 sogod[1254] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'valerio' AND c_folder_type = 'Appointment'; 2016-02-02 09:40:04.544 sogod[1256] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'valerio' AND c_folder_type = 'Appointment'; 2016-02-02 09:40:04.546 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:40:04.546 sogod[1254] query has results, entering fetch-mode. Feb 02 09:40:04 sogod [1254]: |SOGo| request took 0.010493 seconds to execute Feb 02 09:40:04 sogod [1254]: 172.17.10.86 "GET /SOGo/so/valerio/Calendar/personal/newguid HTTP/1.1" 200 56/0 0.011 - - 0 Feb 02 09:40:04 sogod [1256]: |SOGo| request took 0.031753 seconds to execute Feb 02 09:40:04 sogod [1256]: 172.17.10.86 "GET /SOGo/so/valerio/Calendar/UIxAppointmentEditorTemplate HTTP/1.1" 200 23039/0 0.033 - - 392K Feb 02 09:41:07 sogod [1256]: |SOGo| starting method 'POST' on uri '/SOGo/so/valerio/Calendar/personal/4E6-56B06B80-1-300EAA00.ics/saveAsAppointment' 2016-02-02 09:41:07.501 sogod[1256] MySQL4 connection established 0x0x7f48349a7560 2016-02-02 09:41:07.501 sogod[1256] MySQL4 channel 0x0x7f48348eb718 opened (connection=0x0x7f48349a7560,sogo) 2016-02-02 09:41:07.502 sogod[1256] SQL: BEGIN; 2016-02-02 09:41:07.502 sogod[1256] query has no results. 2016-02-02 09:41:07.502 sogod[1256] SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='QwC6K4KShR9fsB492T/w5g=='; 2016-02-02 09:41:07.503 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.503 sogod[1256] SQL: ROLLBACK; 2016-02-02 09:41:07.503 sogod[1256] query has no results. 2016-02-02 09:41:07.504 sogod[1256] MySQL4 connection established 0x0x7f48349b9030 2016-02-02 09:41:07.504 sogod[1256] MySQL4 channel 0x0x7f4834a72a28 opened (connection=0x0x7f48349b9030,sogo) 2016-02-02 09:41:07.504 sogod[1256] SQL: BEGIN; 2016-02-02 09:41:07.504 sogod[1256] query has no results. 2016-02-02 09:41:07.504 sogod[1256] SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='QwC6K4KShR9fsB492T/w5g=='; 2016-02-02 09:41:07.504 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.504 sogod[1256] SQL: ROLLBACK; 2016-02-02 09:41:07.504 sogod[1256] query has no results. 2016-02-02 09:41:07.504 sogod[1256] SQL: BEGIN; 2016-02-02 09:41:07.504 sogod[1256] query has no results. 2016-02-02 09:41:07.505 sogod[1256] SQL: UPDATE sogo_sessions_folder SET c_value = 'JJJFYPJFtrQbTxfaYy5PQFFjPcUKlFUldSh+keI4eTwhaQ1hCD0dYuvsS63ePgzF+NX1brGGoiAWFHnqWMKA1JfzNG/zG/uNjALVCy4a/gcAqm9eb8bHjntn3vDUZiqO7YIHA+OsJ/j/ZiZtdnDSnoPllvyPC+Vg3jscUCv2icgzvywcqMfSwSUMviHnf5A6REPXxIugMIWnVRA+y2ixYw==', c_lastseen = 1454402467, c_creationdate = 1454402134, c_id = 'QwC6K4KShR9fsB492T/w5g==' WHERE c_id='QwC6K4KShR9fsB492T/w5g=='; 2016-02-02 09:41:07.506 sogod[1256] query has no results. 2016-02-02 09:41:07.506 sogod[1256] SQL: COMMIT; 2016-02-02 09:41:07.520 sogod[1256] query has no results. 2016-02-02 09:41:07.522 sogod[1256] MySQL4 connection established 0x0x7f48349b9870 2016-02-02 09:41:07.522 sogod[1256] MySQL4 channel 0x0x7f4834a6cfc8 opened (connection=0x0x7f48349b9870,sogo) 2016-02-02 09:41:07.522 sogod[1256] SQL: SELECT c_password FROM sogo_view WHERE c_uid = 'valerio'; 2016-02-02 09:41:07.522 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.523 sogod[1256] SQL: SELECT * FROM sogo_view WHERE (c_uid = 'valerio') OR (mail = 'valerio'); 2016-02-02 09:41:07.523 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.524 sogod[1256] SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'valerio'; 2016-02-02 09:41:07.524 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.524 sogod[1256] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'valerio' AND c_folder_type = 'Appointment'; 2016-02-02 09:41:07.524 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.525 sogod[1256] SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'valerio'; 2016-02-02 09:41:07.525 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.525 sogod[1256] SQL: SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'valerio' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2016-02-02 09:41:07.525 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.526 sogod[1256] SQL: SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE (a.c_name = '4E6-56B06B80-1-300EAA00.ics') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:41:07.526 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.543 sogod[1256] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/valerio/Calendar/personal'; 2016-02-02 09:41:07.544 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.549 sogod[1256] SQL: SELECT * FROM sogo_view WHERE (c_uid = 'valerio') OR (mail = 'valerio'); 2016-02-02 09:41:07.549 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.557 sogod[1256] SQL: SELECT c_version, c_deleted FROM sogovalerio001061d620b WHERE (c_name = '4E6-56B06B80-1-300EAA00.ics'); 2016-02-02 09:41:07.558 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.560 sogod[1256] SQL: BEGIN; 2016-02-02 09:41:07.560 sogod[1256] query has no results. 2016-02-02 09:41:07.560 sogod[1256] SQL: BEGIN; 2016-02-02 09:41:07.560 sogod[1256] query has no results. 2016-02-02 09:41:07.561 sogod[1256] SQL: INSERT INTO sogovalerio001061d620b_quick (c_cycleinfo, c_isopaque, c_partstates, c_isallday, c_nextalarm, c_cycleenddate, c_status, c_sequence, c_component, c_priority, c_enddate, c_description, c_category, c_iscycle, c_location, c_title, c_uid, c_classification, c_startdate, c_orgmail, c_name) VALUES ('{rules = (""); }', 1, '', 0, 0, 2147483647, 1, 0, 'vevent', 0, 1454406300, 'fun with friends', null, 1, 'new york', 'party', '4E6-56B06B80-1-300EAA00', 0, 1454402700, '', '4E6-56B06B80-1-300EAA00.ics'); 2016-02-02 09:41:07.563 sogod[1256] query has no results. 2016-02-02 09:41:07.563 sogod[1256] SQL: INSERT INTO sogovalerio001061d620b (c_creationdate, c_lastmodified, c_name, c_version, c_content) VALUES (1454402467, 1454402467, '4E6-56B06B80-1-300EAA00.ics', 0, 'BEGIN:VCALENDAR PRODID:-//Inverse inc./SOGo 3.0.0//EN VERSION:2.0 BEGIN:VTIMEZONE TZID:Europe/Rome X-LIC-LOCATION:Europe/Rome BEGIN:DAYLIGHT TZOFFSETFROM:+0100 TZOFFSETTO:+0200 TZNAME:CEST DTSTART:19700329T020000 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=-1SU END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:+0200 TZOFFSETTO:+0100 TZNAME:CET DTSTART:19701025T030000 RRULE:FREQ=YEARLY;BYMONTH=10;BYDAY=-1SU END:STANDARD END:VTIMEZONE BEGIN:VEVENT UID:4E6-56B06B80-1-300EAA00 SUMMARY:party LOCATION:new york DESCRIPTION:fun with friends CLASS:PUBLIC STATUS:NOT-SPECIFIED DTSTART;TZID=Europe/Rome:20160202T094500 DTEND;TZID=Europe/Rome:20160202T104500 CREATED:20160202T084107Z DTSTAMP:20160202T084107Z LAST-MODIFIED:20160202T084107Z END:VEVENT END:VCALENDAR'); 2016-02-02 09:41:07.565 sogod[1256] query has no results. 2016-02-02 09:41:07.565 sogod[1256] SQL: COMMIT; 2016-02-02 09:41:07.567 sogod[1256] query has no results. 2016-02-02 09:41:07.567 sogod[1256] SQL: COMMIT; 2016-02-02 09:41:07.568 sogod[1256] query has no results. Feb 02 09:41:07 sogod [1256]: |SOGo| request took 0.071105 seconds to execute Feb 02 09:41:07 sogod [1256]: 172.17.10.86 "POST /SOGo/so/valerio/Calendar/personal/4E6-56B06B80-1-300EAA00.ics/saveAsAppointment HTTP/1.1" 200 21/559 0.073 - - 1M Feb 02 09:41:07 sogod [1256]: |SOGo| starting method 'GET' on uri '/SOGo/so/valerio/Calendar/eventsblocks?ed=20160206&sd=20160131&view=weekview' Feb 02 09:41:07 sogod [1254]: |SOGo| starting method 'GET' on uri '/SOGo/so/valerio/Calendar/alarmslist?browserTime=1454402469' 2016-02-02 09:41:07.583 sogod[1256] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'valerio' AND c_folder_type = 'Appointment'; 2016-02-02 09:41:07.584 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.584 sogod[1254] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'valerio' AND c_folder_type = 'Appointment'; 2016-02-02 09:41:07.584 sogod[1256] SQL: SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'valerio' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2016-02-02 09:41:07.584 sogod[1254] query has results, entering fetch-mode. 2016-02-02 09:41:07.584 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.585 sogod[1256] 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 sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1454799599)) AND ((c_enddate IS NULL) OR (c_enddate >= 1454194800)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:41:07.585 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.585 sogod[1254] MySQL4 connection established 0x0x7f483489d920 2016-02-02 09:41:07.585 sogod[1254] MySQL4 channel 0x0x7f4834b7a8d8 opened (connection=0x0x7f483489d920,sogo) 2016-02-02 09:41:07.585 sogod[1254] SQL: SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'valerio' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2016-02-02 09:41:07.585 sogod[1254] query has results, entering fetch-mode. 2016-02-02 09:41:07.585 sogod[1256] 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 sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1454799599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1454194800)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:41:07.586 sogod[1254] SQL: SELECT b.c_name,a.c_nextalarm,a.c_iscycle FROM sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE (((c_nextalarm <= 1454575269) AND (c_nextalarm >= 1454402469)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1454402469) AND (c_enddate > 1454402469))) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:41:07.586 sogod[1254] query has results, entering fetch-mode. 2016-02-02 09:41:07.586 sogod[1256] query has results, entering fetch-mode. Feb 02 09:41:07 sogod [1254]: |SOGo| request took 0.003132 seconds to execute Feb 02 09:41:07 sogod [1254]: 172.17.10.86 "GET /SOGo/so/valerio/Calendar/alarmslist?browserTime=1454402469 HTTP/1.1" 200 63/0 0.004 - - 0 Feb 02 09:41:07 sogod [1256]: |SOGo| request took 0.011196 seconds to execute Feb 02 09:41:07 sogod [1256]: 172.17.10.86 "GET /SOGo/so/valerio/Calendar/eventsblocks?ed=20160206&sd=20160131&view=weekview HTTP/1.1" 200 448/0 0.013 - - 256K Feb 02 09:41:07 sogod [1256]: |SOGo| starting method 'GET' on uri '/SOGo/so/valerio/Calendar/eventslist?asc=1&day=20160202&filterpopup=view_next7&search=title_Category_Location&sort=start&value=' 2016-02-02 09:41:07.608 sogod[1256] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'valerio' AND c_folder_type = 'Appointment'; 2016-02-02 09:41:07.608 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.609 sogod[1256] SQL: BEGIN; 2016-02-02 09:41:07.610 sogod[1256] query has no results. 2016-02-02 09:41:07.610 sogod[1256] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"]}, "Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"FreeBusyExclusions": {"valerio:Calendar\\/personal": 0}, "NotifyOnExternalModifications": {"valerio:Calendar\\/personal": 0}, "TasksSortingState": ["status", "1"], "TasksFilterState": "view_incomplete", "EventsFilterState": "view_next7", "FolderColors": {"valerio:Calendar\\/personal": "#AAAAAA"}, "PreventInvitationsWhitelist": {}, "View": "weekview", "NotifyUserOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "SelectedList": "eventsListView", "NotifyOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "FolderSynchronize": {"valerio:Calendar\\/personal": 1}, "EventsSortingState": ["start", "1"]}, "ShowCompletedTasks": "0"}' WHERE c_uid = 'valerio'; 2016-02-02 09:41:07.620 sogod[1256] query has no results. 2016-02-02 09:41:07.620 sogod[1256] SQL: COMMIT; 2016-02-02 09:41:07.624 sogod[1256] query has no results. 2016-02-02 09:41:07.625 sogod[1256] SQL: BEGIN; 2016-02-02 09:41:07.626 sogod[1256] query has no results. 2016-02-02 09:41:07.626 sogod[1256] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"]}, "Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"FreeBusyExclusions": {"valerio:Calendar\\/personal": 0}, "NotifyOnExternalModifications": {"valerio:Calendar\\/personal": 0}, "TasksSortingState": ["status", "1"], "TasksFilterState": "view_incomplete", "EventsFilterState": "view_next7", "FolderColors": {"valerio:Calendar\\/personal": "#AAAAAA"}, "PreventInvitationsWhitelist": {}, "View": "weekview", "NotifyUserOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "SelectedList": "eventsListView", "NotifyOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "FolderSynchronize": {"valerio:Calendar\\/personal": 1}, "EventsSortingState": ["start", "1"]}, "ShowCompletedTasks": "0"}' WHERE c_uid = 'valerio'; 2016-02-02 09:41:07.627 sogod[1256] query has no results. 2016-02-02 09:41:07.627 sogod[1256] SQL: COMMIT; 2016-02-02 09:41:07.628 sogod[1256] query has no results. 2016-02-02 09:41:07.628 sogod[1256] SQL: SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'valerio' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2016-02-02 09:41:07.628 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.629 sogod[1256] 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 sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1454972399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1454367600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:41:07.629 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:41:07.629 sogod[1256] 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 sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1454972399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1454367600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:41:07.630 sogod[1256] query has results, entering fetch-mode. Feb 02 09:41:07 sogod [1256]: |SOGo| request took 0.029934 seconds to execute Feb 02 09:41:07 sogod [1256]: 172.17.10.86 "GET /SOGo/so/valerio/Calendar/eventslist?asc=1&day=20160202&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 398/0 0.031 - - 0 Feb 02 09:51:15 sogod [1256]: |SOGo| starting method 'GET' on uri '/SOGo/so/valerio/Calendar/eventslist?asc=1&day=20160202&filterpopup=view_next7&search=title_Category_Location&sort=start&value=' 2016-02-02 09:51:15.410 sogod[1256] MySQL4 connection established 0x0x7f48349b9030 2016-02-02 09:51:15.410 sogod[1256] MySQL4 channel 0x0x7f4834a975d8 opened (connection=0x0x7f48349b9030,sogo) 2016-02-02 09:51:15.410 sogod[1256] SQL: BEGIN; 2016-02-02 09:51:15.411 sogod[1256] query has no results. 2016-02-02 09:51:15.411 sogod[1256] SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='QwC6K4KShR9fsB492T/w5g=='; 2016-02-02 09:51:15.411 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.411 sogod[1256] SQL: ROLLBACK; 2016-02-02 09:51:15.411 sogod[1256] query has no results. 2016-02-02 09:51:15.412 sogod[1256] MySQL4 connection established 0x0x7f48349a7560 2016-02-02 09:51:15.412 sogod[1256] MySQL4 channel 0x0x7f48349d1a38 opened (connection=0x0x7f48349a7560,sogo) 2016-02-02 09:51:15.412 sogod[1256] SQL: BEGIN; 2016-02-02 09:51:15.412 sogod[1256] query has no results. 2016-02-02 09:51:15.412 sogod[1256] SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='QwC6K4KShR9fsB492T/w5g=='; 2016-02-02 09:51:15.412 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.412 sogod[1256] SQL: ROLLBACK; 2016-02-02 09:51:15.412 sogod[1256] query has no results. 2016-02-02 09:51:15.412 sogod[1256] SQL: BEGIN; 2016-02-02 09:51:15.412 sogod[1256] query has no results. 2016-02-02 09:51:15.412 sogod[1256] SQL: UPDATE sogo_sessions_folder SET c_value = 'JJJFYPJFtrQbTxfaYy5PQFFjPcUKlFUldSh+keI4eTwhaQ1hCD0dYuvsS63ePgzF+NX1brGGoiAWFHnqWMKA1JfzNG/zG/uNjALVCy4a/gcAqm9eb8bHjntn3vDUZiqO7YIHA+OsJ/j/ZiZtdnDSnoPllvyPC+Vg3jscUCv2icgzvywcqMfSwSUMviHnf5A6REPXxIugMIWnVRA+y2ixYw==', c_lastseen = 1454403075, c_creationdate = 1454402134, c_id = 'QwC6K4KShR9fsB492T/w5g==' WHERE c_id='QwC6K4KShR9fsB492T/w5g=='; 2016-02-02 09:51:15.415 sogod[1256] query has no results. 2016-02-02 09:51:15.415 sogod[1256] SQL: COMMIT; 2016-02-02 09:51:15.433 sogod[1256] query has no results. 2016-02-02 09:51:15.435 sogod[1256] MySQL4 connection established 0x0x7f48349b9870 2016-02-02 09:51:15.435 sogod[1256] MySQL4 channel 0x0x7f4834a0a528 opened (connection=0x0x7f48349b9870,sogo) 2016-02-02 09:51:15.435 sogod[1256] SQL: SELECT c_password FROM sogo_view WHERE c_uid = 'valerio'; 2016-02-02 09:51:15.435 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.435 sogod[1256] SQL: SELECT * FROM sogo_view WHERE (c_uid = 'valerio') OR (mail = 'valerio'); 2016-02-02 09:51:15.436 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.437 sogod[1256] SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'valerio'; 2016-02-02 09:51:15.437 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.437 sogod[1256] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'valerio' AND c_folder_type = 'Appointment'; 2016-02-02 09:51:15.438 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.438 sogod[1256] SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'valerio'; 2016-02-02 09:51:15.438 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.439 sogod[1256] SQL: BEGIN; 2016-02-02 09:51:15.439 sogod[1256] query has no results. 2016-02-02 09:51:15.439 sogod[1256] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"]}, "Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"FreeBusyExclusions": {"valerio:Calendar\\/personal": 0}, "NotifyOnExternalModifications": {"valerio:Calendar\\/personal": 0}, "TasksSortingState": ["status", "1"], "TasksFilterState": "view_incomplete", "EventsFilterState": "view_next7", "FolderColors": {"valerio:Calendar\\/personal": "#AAAAAA"}, "PreventInvitationsWhitelist": {}, "View": "weekview", "NotifyUserOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "SelectedList": "eventsListView", "NotifyOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "FolderSynchronize": {"valerio:Calendar\\/personal": 1}, "EventsSortingState": ["start", "1"]}, "ShowCompletedTasks": "0"}' WHERE c_uid = 'valerio'; 2016-02-02 09:51:15.440 sogod[1256] query has no results. 2016-02-02 09:51:15.440 sogod[1256] SQL: COMMIT; 2016-02-02 09:51:15.442 sogod[1256] query has no results. 2016-02-02 09:51:15.443 sogod[1256] SQL: BEGIN; 2016-02-02 09:51:15.443 sogod[1256] query has no results. 2016-02-02 09:51:15.443 sogod[1256] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"]}, "Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"FreeBusyExclusions": {"valerio:Calendar\\/personal": 0}, "NotifyOnExternalModifications": {"valerio:Calendar\\/personal": 0}, "TasksSortingState": ["status", "1"], "TasksFilterState": "view_incomplete", "EventsFilterState": "view_next7", "FolderColors": {"valerio:Calendar\\/personal": "#AAAAAA"}, "PreventInvitationsWhitelist": {}, "View": "weekview", "NotifyUserOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "SelectedList": "eventsListView", "NotifyOnPersonalModifications": {"valerio:Calendar\\/personal": 0}, "FolderSynchronize": {"valerio:Calendar\\/personal": 1}, "EventsSortingState": ["start", "1"]}, "ShowCompletedTasks": "0"}' WHERE c_uid = 'valerio'; 2016-02-02 09:51:15.444 sogod[1256] query has no results. 2016-02-02 09:51:15.444 sogod[1256] SQL: COMMIT; 2016-02-02 09:51:15.448 sogod[1256] query has no results. 2016-02-02 09:51:15.448 sogod[1256] SQL: SELECT c_folder_id, c_path, c_location, c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'valerio' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2016-02-02 09:51:15.449 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.449 sogod[1256] 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 sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1454972399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1454367600)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:51:15.449 sogod[1256] query has results, entering fetch-mode. 2016-02-02 09:51:15.449 sogod[1256] 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 sogovalerio001061d620b_quick a, sogovalerio001061d620b b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1454972399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1454367600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2016-02-02 09:51:15.450 sogod[1256] query has results, entering fetch-mode. Feb 02 09:51:15 sogod [1256]: |SOGo| request took 0.045630 seconds to execute Feb 02 09:51:15 sogod [1256]: 172.17.10.86 "GET /SOGo/so/valerio/Calendar/eventslist?asc=1&day=20160202&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 398/0 0.047 - - 4K