2018-09-25 15:26:43.705 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:26:43.706 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:43.707 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:26:43.708 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:43.708 sogod[3605] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/nico/Contacts/collected'; 2018-09-25 15:26:43.709 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:43.710 sogod[3605] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/nico/Contacts/personal'; 2018-09-25 15:26:43.712 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:43.713 sogod[3605] SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'nico' AND c_path3 = 'Contacts' AND c_path4 = 'E15-5BAA3780-5-6E17138'; 2018-09-25 15:26:43.714 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:43.714 sogod[3605] SQL: BEGIN; 2018-09-25 15:26:43.715 sogod[3605] query has no results. 2018-09-25 15:26:43.715 sogod[3605] SQL: INSERT INTO sogo_folder_info (c_path, c_path1, c_path2, c_path3, c_path4, c_foldername, c_location, c_quick_location, c_acl_location, c_folder_type) VALUES ('/Users/nico/Contacts/E15-5BAA3780-5-6E17138', 'Users', 'nico', 'Contacts', 'E15-5BAA3780-5-6E17138', 'Test', 'mysql://sogo:@:3306/sogo/sogonico002210e3ef5', 'mysql://sogo:@:3306/sogo/sogonico002210e3ef5_quick', 'mysql://sogo:@:3306/sogo/sogonico002210e3ef5_acl', 'Contact'); 2018-09-25 15:26:43.716 sogod[3605] query has no results. 2018-09-25 15:26:43.716 sogod[3605] SQL: CREATE TABLE sogonico002210e3ef5 ( c_name VARCHAR (255) PRIMARY KEY, c_content MEDIUMTEXT NOT NULL, c_creationdate INT NOT NULL, c_lastmodified INT NOT NULL, c_version INT NOT NULL, c_deleted INT NULL ); 2018-09-25 15:26:44.300 sogod[3605] query has no results. 2018-09-25 15:26:44.300 sogod[3605] SQL: CREATE TABLE sogonico002210e3ef5_quick (c_name VARCHAR(255) NOT NULL PRIMARY KEY, c_givenname VARCHAR(255) NULL, c_cn VARCHAR(255) NULL, c_sn VARCHAR(255) NULL, c_screenname VARCHAR(255) NULL, c_l VARCHAR(255) NULL, c_mail VARCHAR(255) NULL, c_o VARCHAR(255) NULL, c_ou VARCHAR(255) NULL, c_telephonenumber VARCHAR(255) NULL, c_categories VARCHAR(255) NULL, c_component VARCHAR(10) NOT NULL); 2018-09-25 15:26:45.520 sogod[3605] query has no results. 2018-09-25 15:26:45.521 sogod[3605] SQL: CREATE TABLE sogonico002210e3ef5_acl ( c_uid VARCHAR (255) NOT NULL, c_object VARCHAR (255) NOT NULL, c_role VARCHAR (80) NOT NULL ); 2018-09-25 15:26:46.690 sogod[3605] query has no results. 2018-09-25 15:26:46.691 sogod[3605] SQL: COMMIT; 2018-09-25 15:26:46.691 sogod[3605] query has no results. (null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/createFolder HTTP/1.1" 201 32/15 2.994 - - 0 2018-09-25 15:26:47.984 sogod[3605] SQL: BEGIN; 2018-09-25 15:26:47.984 sogod[3605] query has no results. 2018-09-25 15:26:47.984 sogod[3605] SQL: UPDATE sogo_user_profile SET c_defaults = '{"SOGoDefaultCalendar": "selected", "SOGoMailCustomFullName": "Nico Speelman", "SOGoLoginModule": "Contacts", "SOGoMailReceiptOutsideDomainAction": "ignore", "SOGoDayEndTime": "18:00", "SOGoAlternateAvatar": "none", "SOGoAppointmentSendEMailNotifications": 0, "SOGoMailComposeFontSize": 0, "SOGoCalendarDefaultReminder": "NONE", "SOGoLongDateFormat": "%A, %B %d, %Y", "SOGoMailSignaturePlacement": "above", "SOGoMailLabelsColors": {"$label1": ["Important", "#FF0000"], "$label2": ["Work", "#FF9900"], "$label3": ["Personal", "#009900"], "$label4": ["To Do", "#3333FF"], "$label5": ["Later", "#993399"]}, "SOGoMailReceiptNonRecipientAction": "ignore", "LocaleCode": "en", "SOGoDayStartTime": "08:00", "SOGoBusyOffHours": "0", "SOGoSelectedAddressBook": "personal", "SOGoMailSynchronizeOnlyDefaultFolders": "0", "SOGoLanguage": "English", "SOGoCalendarTasksDefaultClassification": "PUBLIC", "SOGoMailAutoSave": 5, "locale": {"days": ["Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday"], "months": ["January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"], "shortDays": ["Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat"], "shortMonths": ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"]}, "SOGoMailShowSubscribedFoldersOnly": "0", "SOGoCalendarCategories": ["Customer", "Calls", "Favorites", "Meeting", "Ideas", "Miscellaneous", "Birthday", "Anniversary", "Vacation", "Travel", "Projects", "Suppliers", "Gifts", "Clients", "Issues", "Business", "Holidays", "Personal", "Status", "Competition", "Follow up", "Public Holiday"], "SOGoRememberLastModule": 1, "SOGoCalendarEventsDefaultClassification": "PUBLIC", "SOGoAnimationMode": "normal", "SOGoCalendarCategoriesColors": {"Customer": "#F0F0F0", "Calls": "#F0F0F0", "Favorites": "#F0F0F0", "Meeting": "#F0F0F0", "Ideas": "#F0F0F0", "Miscellaneous": "#F0F0F0", "Birthday": "#F0F0F0", "Anniversary": "#F0F0F0", "Vacation": "#F0F0F0", "Travel": "#F0F0F0", "Projects": "#F0F0F0", "Suppliers": "#F0F0F0", "Gifts": "#F0F0F0", "Clients": "#F0F0F0", "Issues": "#F0F0F0", "Business": "#F0F0F0", "Holidays": "#F0F0F0", "Personal": "#F0F0F0", "Status": "#F0F0F0", "Competition": "#F0F0F0", "Follow up": "#F0F0F0", "Public Holiday": "#F0F0F0"}, "SOGoMailDisplayRemoteInlineImages": "never", "SOGoContactsCategories": ["Business Partner", "Colleague", "Competitor", "Coworkers", "Customer", "Family", "Friend", "HTC Favorite", "Press", "Provider", "VIP"], "SOGoCalendarWeekdays": ["MO", "TU", "WE", "TH", "FR", "SA", "SU"], "SOGoTimeFormat": "%H:%M", "SOGoMailComposeMessageType": "html", "SOGoMailSignature": "", "SOGoTimeZone": "Europe\\/Amsterdam", "SOGoRefreshViewCheck": "manually", "Forward": {"enabled": 0, "forwardAddress": "", "keepCopy": 0}, "SOGoMailReceiptAnyAction": "ignore", "Vacation": {"alwaysSend": 0, "enabled": 0, "endDate": 0, "startDate": 0, "ignoreLists": 1, "autoReplyEmailAddresses": [""], "autoReplyText": "", "daysBetweenResponse": "7"}, "SOGoShortDateFormat": "%d-%b-%y", "SOGoMailAddOutgoingAddresses": "0", "SOGoMailReplyPlacement": "above", "SOGoMailReceiptAllow": "1", "SOGoFirstDayOfWeek": "1", "SOGoSieveFilters": [{"actions": [{"method": "fileinto", "argument": "Junk"}, {"method": "addflag", "argument": "seen"}], "active": 1, "rules": [{"operator": "contains", "custom_header": "X-Spam-Flag", "field": "subject", "value": "***SPAM***"}], "match": "any", "name": "Spam"}], "SOGoMailMessageForwarding": "inline", "SOGoGravatarEnabled": 0, "SOGoFirstWeekOfYear": "First4DayWeek", "AuxiliaryMailAccounts": [], "SOGoMailSortByThreads": "0"}' WHERE c_uid = 'nico'; 2018-09-25 15:26:47.986 sogod[3605] query has no results. 2018-09-25 15:26:47.987 sogod[3605] SQL: COMMIT; 2018-09-25 15:26:48.039 sogod[3605] query has no results. 2018-09-25 15:26:48.043 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:26:48.044 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:48.045 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:26:48.045 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:48.047 sogod[3605] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/nico/Contacts/collected'; 2018-09-25 15:26:48.048 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:48.050 sogod[3605] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/nico/Contacts/E15-5BAA3780-5-6E17138'; 2018-09-25 15:26:48.051 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:26:48.052 sogod[3605] SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/nico/Contacts/personal'; 2018-09-25 15:26:48.053 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "GET /SOGo/so/nico/Contacts/view HTTP/1.1" 200 16093/0 0.127 70402 77% 0 (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc2043504472&DeviceType=Android HTTP/1.1" 200 13/193 10.551 - - 0 (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 13/193 10.707 - - 0 2018-09-25 15:26:49.612 sogod[3575] SQL: SELECT count(*) FROM sogo_cache_folder_nico; 2018-09-25 15:26:49.614 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.615 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:26:49.615 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.616 sogod[3575] SQL: UPDATE sogo_cache_folder_nico SET c_lastmodified = 1537882009, c_deleted = 0, c_version = 4107990, c_content = 'agIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj APcNAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4 NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj AGw+AAAQU3luY1JlcXVlc3QAmjaqWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0 NTAwNTE2MDAwMDA2NmYxNGRjADQsAAACUGluZ1JlcXVlc3QABQAAADM1NzUAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsAKQjAAAA' WHERE c_path = '/androidc775797237'; 2018-09-25 15:26:49.640 sogod[3575] query has no results. 2018-09-25 15:26:49.641 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal'; 2018-09-25 15:26:49.643 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.646 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:26:49.647 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.648 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC; 2018-09-25 15:26:49.648 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.649 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal'; 2018-09-25 15:26:49.650 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.652 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:26:49.652 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.653 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:26:49.653 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.654 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC; 2018-09-25 15:26:49.655 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:49.793 sogod[3602] SQL: SELECT count(*) FROM sogo_cache_folder_jill; 2018-09-25 15:26:49.794 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:49.795 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:26:49.796 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:49.797 sogod[3602] SQL: UPDATE sogo_cache_folder_jill SET c_lastmodified = 1537882009, c_deleted = 0, c_version = 1453457, c_content = 'agIAABBQaW5nSGVhcnRiZWF0SW50ZXJ2YWwACgAAABBTeW5jUmVxdWVzdCt2ZXZlbnQvcGVy c29uYWwAwi0AABBTeW5jUmVxdWVzdCttYWlsLzliYjFjYzFjN2ZjOWVmNTMwYzBiMDAwMDlj ZmQyNTNjADQ1AAACRm9sZGVyU3luY0tleQAVAAAAbWFpbF8yOWI3XzIxMTQ0YzNkXzAABFBp bmdDYWNoZWRGb2xkZXJzAJQAAAACMAASAAAAdmV2ZW50JTJGcGVyc29uYWwAAjEAEQAAAHZj YXJkJTJGcGVyc29uYWwAAjIAKAAAAG1haWwlMkZhZmEzNDkwMWNkYTU1NTUwZWMxNjAwMDAw NjZmMTRkYwACMwAoAAAAbWFpbCUyRmQ2Y2ZlNjA4NmRhNjU1NTAyNzE3MDAwMDA2NmYxNGRj AAAQU3luY1JlcXVlc3QrbWFpbC9kNmNmZTYwODZkYTY1NTUwMjcxNzAwMDAwNjZmMTRkYwCZ VgAAEFN5bmNSZXF1ZXN0K21haWwvMTJmOWE4MTRlMGM0OGE1MDdkNmUwMDAwMDY2ZjE0ZGMA KToAABBTeW5jUmVxdWVzdAAbNqpbEFN5bmNSZXF1ZXN0K21haWwvYWZhMzQ5MDFjZGE1NTU1 MGVjMTYwMDAwMDY2ZjE0ZGMAmVYAABBTeW5jUmVxdWVzdCttYWlsLzY3N2NmYzI4YmFhNjU1 NTA0MTE3MDAwMDA2NmYxNGRjAK9dAAACUGluZ1JlcXVlc3QABQAAADM2MDIAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsANpKAAAA' WHERE c_path = '/androidc2043504472'; 2018-09-25 15:26:50.020 sogod[3602] query has no results. 2018-09-25 15:26:50.021 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vevent/personal'; 2018-09-25 15:26:50.022 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.024 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Appointment'; 2018-09-25 15:26:50.025 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.026 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0010573755d ORDER BY c_lastmodified DESC; 2018-09-25 15:26:50.027 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.028 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vcard/personal'; 2018-09-25 15:26:50.029 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.033 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:26:50.034 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.035 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:26:50.036 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.037 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0022cb36c94 ORDER BY c_lastmodified DESC; 2018-09-25 15:26:50.038 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.068 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc'; 2018-09-25 15:26:50.069 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:50.151 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder64d3710c625f445005160000066f14dc'; 2018-09-25 15:26:50.153 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:26:50.238 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:26:50.241 sogod[3575] query has results, entering fetch-mode. Sep 25 15:26:50 sogod [3575]: <0x0x7feee7748748[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user nico in Ping... 2018-09-25 15:26:50.371 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderafa34901cda55550ec160000066f14dc'; 2018-09-25 15:26:50.373 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.414 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderd6cfe6086da6555027170000066f14dc'; 2018-09-25 15:26:50.416 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:26:50.505 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:26:50.507 sogod[3602] query has results, entering fetch-mode. Sep 25 15:26:50 sogod [3602]: <0x0x7feee7698738[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user jill in Ping... (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 19/194 10.644 - - 0 2018-09-25 15:27:00.470 sogod[3575] SQL: SELECT count(*) FROM sogo_cache_folder_nico; 2018-09-25 15:27:00.472 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.473 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:00.474 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.475 sogod[3575] SQL: UPDATE sogo_cache_folder_nico SET c_lastmodified = 1537882020, c_deleted = 0, c_version = 4107991, c_content = 'agIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj APcNAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4 NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj AGw+AAAQU3luY1JlcXVlc3QAmjaqWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0 NTAwNTE2MDAwMDA2NmYxNGRjADQsAAACUGluZ1JlcXVlc3QABQAAADM1NzUAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsAKQjAAAA' WHERE c_path = '/androidc775797237'; (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc2043504472&DeviceType=Android HTTP/1.1" 200 19/194 10.725 - - 0 2018-09-25 15:27:00.612 sogod[3575] query has no results. 2018-09-25 15:27:00.613 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal'; 2018-09-25 15:27:00.616 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.618 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:00.619 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.620 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:00.621 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.622 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal'; 2018-09-25 15:27:00.624 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.625 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:00.625 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.626 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:00.626 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.626 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:00.627 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:00.940 sogod[3602] SQL: SELECT count(*) FROM sogo_cache_folder_jill; 2018-09-25 15:27:00.942 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:00.945 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:00.946 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:00.947 sogod[3602] SQL: UPDATE sogo_cache_folder_jill SET c_lastmodified = 1537882020, c_deleted = 0, c_version = 1453458, c_content = 'agIAABBQaW5nSGVhcnRiZWF0SW50ZXJ2YWwACgAAABBTeW5jUmVxdWVzdCt2ZXZlbnQvcGVy c29uYWwAwi0AABBTeW5jUmVxdWVzdCttYWlsLzliYjFjYzFjN2ZjOWVmNTMwYzBiMDAwMDlj ZmQyNTNjADQ1AAACRm9sZGVyU3luY0tleQAVAAAAbWFpbF8yOWI3XzIxMTQ0YzNkXzAABFBp bmdDYWNoZWRGb2xkZXJzAJQAAAACMAASAAAAdmV2ZW50JTJGcGVyc29uYWwAAjEAEQAAAHZj YXJkJTJGcGVyc29uYWwAAjIAKAAAAG1haWwlMkZhZmEzNDkwMWNkYTU1NTUwZWMxNjAwMDAw NjZmMTRkYwACMwAoAAAAbWFpbCUyRmQ2Y2ZlNjA4NmRhNjU1NTAyNzE3MDAwMDA2NmYxNGRj AAAQU3luY1JlcXVlc3QrbWFpbC9kNmNmZTYwODZkYTY1NTUwMjcxNzAwMDAwNjZmMTRkYwCZ VgAAEFN5bmNSZXF1ZXN0K21haWwvMTJmOWE4MTRlMGM0OGE1MDdkNmUwMDAwMDY2ZjE0ZGMA KToAABBTeW5jUmVxdWVzdAAbNqpbEFN5bmNSZXF1ZXN0K21haWwvYWZhMzQ5MDFjZGE1NTU1 MGVjMTYwMDAwMDY2ZjE0ZGMAmVYAABBTeW5jUmVxdWVzdCttYWlsLzY3N2NmYzI4YmFhNjU1 NTA0MTE3MDAwMDA2NmYxNGRjAK9dAAACUGluZ1JlcXVlc3QABQAAADM2MDIAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsANpKAAAA' WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:01.020 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc'; 2018-09-25 15:27:01.021 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:01.028 sogod[3602] query has no results. 2018-09-25 15:27:01.029 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vevent/personal'; 2018-09-25 15:27:01.030 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.032 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:01.033 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.035 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0010573755d ORDER BY c_lastmodified DESC; 2018-09-25 15:27:01.036 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.036 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vcard/personal'; 2018-09-25 15:27:01.037 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.039 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:01.040 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.040 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:01.041 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.042 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0022cb36c94 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:01.042 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.102 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder64d3710c625f445005160000066f14dc'; 2018-09-25 15:27:01.104 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:01.193 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:01.195 sogod[3575] query has results, entering fetch-mode. Sep 25 15:27:01 sogod [3575]: <0x0x7feee7749908[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user nico in Ping... 2018-09-25 15:27:01.362 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderafa34901cda55550ec160000066f14dc'; 2018-09-25 15:27:01.363 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.443 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderd6cfe6086da6555027170000066f14dc'; 2018-09-25 15:27:01.445 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:01.531 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:01.533 sogod[3602] query has results, entering fetch-mode. Sep 25 15:27:01 sogod [3602]: <0x0x7feee766a138[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user jill in Ping... (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 13/193 10.736 - - 0 2018-09-25 15:27:11.368 sogod[3575] SQL: SELECT count(*) FROM sogo_cache_folder_nico; 2018-09-25 15:27:11.369 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.370 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:11.371 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.371 sogod[3575] SQL: UPDATE sogo_cache_folder_nico SET c_lastmodified = 1537882031, c_deleted = 0, c_version = 4107992, c_content = 'agIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj APcNAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4 NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj AGw+AAAQU3luY1JlcXVlc3QAmjaqWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0 NTAwNTE2MDAwMDA2NmYxNGRjADQsAAACUGluZ1JlcXVlc3QABQAAADM1NzUAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsAKQjAAAA' WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:11.511 sogod[3575] query has no results. 2018-09-25 15:27:11.512 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal'; 2018-09-25 15:27:11.514 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.515 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:11.516 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.517 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:11.518 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.519 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal'; 2018-09-25 15:27:11.520 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.522 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:11.523 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.523 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:11.523 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:11.524 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:11.525 sogod[3575] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc2043504472&DeviceType=Android HTTP/1.1" 200 13/193 10.606 - - 0 2018-09-25 15:27:11.931 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc'; 2018-09-25 15:27:11.933 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:12.015 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder64d3710c625f445005160000066f14dc'; 2018-09-25 15:27:12.016 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:12.037 sogod[3602] SQL: SELECT count(*) FROM sogo_cache_folder_jill; 2018-09-25 15:27:12.038 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.039 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:12.040 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.040 sogod[3602] SQL: UPDATE sogo_cache_folder_jill SET c_lastmodified = 1537882032, c_deleted = 0, c_version = 1453459, c_content = 'agIAABBQaW5nSGVhcnRiZWF0SW50ZXJ2YWwACgAAABBTeW5jUmVxdWVzdCt2ZXZlbnQvcGVy c29uYWwAwi0AABBTeW5jUmVxdWVzdCttYWlsLzliYjFjYzFjN2ZjOWVmNTMwYzBiMDAwMDlj ZmQyNTNjADQ1AAACRm9sZGVyU3luY0tleQAVAAAAbWFpbF8yOWI3XzIxMTQ0YzNkXzAABFBp bmdDYWNoZWRGb2xkZXJzAJQAAAACMAASAAAAdmV2ZW50JTJGcGVyc29uYWwAAjEAEQAAAHZj YXJkJTJGcGVyc29uYWwAAjIAKAAAAG1haWwlMkZhZmEzNDkwMWNkYTU1NTUwZWMxNjAwMDAw NjZmMTRkYwACMwAoAAAAbWFpbCUyRmQ2Y2ZlNjA4NmRhNjU1NTAyNzE3MDAwMDA2NmYxNGRj AAAQU3luY1JlcXVlc3QrbWFpbC9kNmNmZTYwODZkYTY1NTUwMjcxNzAwMDAwNjZmMTRkYwCZ VgAAEFN5bmNSZXF1ZXN0K21haWwvMTJmOWE4MTRlMGM0OGE1MDdkNmUwMDAwMDY2ZjE0ZGMA KToAABBTeW5jUmVxdWVzdAAbNqpbEFN5bmNSZXF1ZXN0K21haWwvYWZhMzQ5MDFjZGE1NTU1 MGVjMTYwMDAwMDY2ZjE0ZGMAmVYAABBTeW5jUmVxdWVzdCttYWlsLzY3N2NmYzI4YmFhNjU1 NTA0MTE3MDAwMDA2NmYxNGRjAK9dAAACUGluZ1JlcXVlc3QABQAAADM2MDIAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsANpKAAAA' WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:12.105 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:12.107 sogod[3575] query has results, entering fetch-mode. Sep 25 15:27:12 sogod [3575]: <0x0x7feee7756f18[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user nico in Ping... 2018-09-25 15:27:12.291 sogod[3602] query has no results. 2018-09-25 15:27:12.291 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vevent/personal'; 2018-09-25 15:27:12.293 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.295 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:12.296 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.297 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0010573755d ORDER BY c_lastmodified DESC; 2018-09-25 15:27:12.297 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.298 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vcard/personal'; 2018-09-25 15:27:12.299 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.301 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:12.301 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.302 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:12.302 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.303 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0022cb36c94 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:12.304 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.618 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderafa34901cda55550ec160000066f14dc'; 2018-09-25 15:27:12.619 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.678 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:12.679 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "GET /SOGo/so/nico/Calendar/alarmslist?browserTime=1537882023 HTTP/1.1" 200 63/0 0.012 - - 0 2018-09-25 15:27:12.698 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderd6cfe6086da6555027170000066f14dc'; 2018-09-25 15:27:12.699 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:12.787 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:12.790 sogod[3602] query has results, entering fetch-mode. Sep 25 15:27:12 sogod [3602]: <0x0x7feee78895e8[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user jill in Ping... 2018-09-25 15:27:14.828 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:14.829 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:14.829 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:14.830 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:14.833 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:14.834 sogod[3605] query has no results. 2018-09-25 15:27:14.834 sogod[3605] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"], "ExpandedFolders": ["\\/0", "\\/0\\/folderINBOX"], "DragHandleVertical": "256", "folderForExpunge": "imap:\\/\\/nico@127.0.0.1:143\\/INBOX\\/"}, "Contacts": {"DragHandleVertical": "358"}, "Contact": {"SortingState": ["c_cn", "1"]}, "CalendarDefaultFilter": "view_today", "Calendar": {"EventsSortingState": ["start", "1"], "PreventInvitations": 0, "EventsFilterState": "view_next7", "ListState": "rise", "View": "weekview", "InactiveFolders": ["personal"], "DragHandleVertical": "167", "PreventInvitationsWhitelist": {}, "FoldersOrder": ["personal"], "SelectedList": "eventsListView"}}' WHERE c_uid = 'nico'; 2018-09-25 15:27:14.835 sogod[3605] query has no results. 2018-09-25 15:27:14.835 sogod[3605] SQL: COMMIT; 2018-09-25 15:27:15.022 sogod[3605] query has no results. 2018-09-25 15:27:15.022 sogod[3605] 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 = 'nico' AND c_path3 = 'Contacts' AND c_path4 = 'E15-5BAA3780-5-6E17138'; 2018-09-25 15:27:15.024 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:15.025 sogod[3605] SQL: SELECT c_name, c_cn FROM sogonico002210e3ef5_quick ORDER BY c_cn ASC; 2018-09-25 15:27:15.027 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/E15-5BAA3780-5-6E17138/view HTTP/1.1" 200 170/46 0.206 - - 0 2018-09-25 15:27:16.883 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:16.883 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:16.884 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:16.884 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:16.888 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:16.888 sogod[3605] query has no results. 2018-09-25 15:27:16.889 sogod[3605] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"], "ExpandedFolders": ["\\/0", "\\/0\\/folderINBOX"], "DragHandleVertical": "256", "folderForExpunge": "imap:\\/\\/nico@127.0.0.1:143\\/INBOX\\/"}, "Contacts": {"DragHandleVertical": "358"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"EventsSortingState": ["start", "1"], "ListState": "rise", "EventsFilterState": "view_next7", "PreventInvitations": 0, "InactiveFolders": ["personal"], "View": "weekview", "PreventInvitationsWhitelist": {}, "DragHandleVertical": "167", "FoldersOrder": ["personal"], "SelectedList": "eventsListView"}, "CalendarDefaultFilter": "view_today"}' WHERE c_uid = 'nico'; 2018-09-25 15:27:16.889 sogod[3605] query has no results. 2018-09-25 15:27:16.890 sogod[3605] SQL: COMMIT; 2018-09-25 15:27:17.194 sogod[3605] query has no results. 2018-09-25 15:27:17.195 sogod[3605] SQL: SELECT c_name, c_cn FROM sogonico00251821f30_quick ORDER BY c_cn ASC; 2018-09-25 15:27:17.196 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:17.199 sogod[3605] SQL: SELECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM sogonico00251821f30_quick WHERE ((c_name = '056A5934-20D9C14A-24DA1822.vcf') OR (c_name = 'DE1-59BF9F80-1-63A7F980.vcf') OR (c_name = '3259-59F5BD80-1-56288500') OR (c_name = '76761D16-5B877202-593BBF5B.vcf') OR (c_name = '6EB9CB7E-17283D1A-6E3E8733.vcf') OR (c_name = '2B5E-58F87E80-1-39276640.vcf') OR (c_name = '2D015424-6A629C70-322E79A1.vcf') OR (c_name = '63784EA5-643441CA-16061B5D.vcf') OR (c_name = '5BEA2D8D-4B6A6E42-5A112DCC.vcf') OR (c_name = '6A2F871C-2A1E5301-5B6793C2.vcf') OR (c_name = '2A68EB78-4630459F-298C4ADC.vcf') OR (c_name = '6F61A5E1-5D0BC14D-14EB96E1.vcf') OR (c_name = '32D625D2-0EC58ECA-2F774B3A.vcf') OR (c_name = '53AFE71C-339FA6EC-72C0B675.vcf') OR (c_name = '2F37591F-0CDB6647-782B0FAA.vcf') OR (c_name = '465F9639-7B19ED7A-6EA12CC0.vcf') OR (c_name = '4546-569E0900-1-182898C0.vcf') OR (c_name = '30C232A9-2D48671C-5D5AF83E.vcf') OR (c_name = '14F67474-434E8279-0A5C4C63.vcf') OR (c_name = '2F9C-59F5BE00-3-30F62600') OR (c_name = '6060E2B6-1D5FB046-6DD49B08.vcf') OR (c_name = '0A7F35B7-78C74408-49BEC896.vcf') OR (c_name = '50AF7B57-22538EE4-33EE4FB2.vcf') OR (c_name = '2DBB3CA4-373F25C5-5E573B2A.vcf') OR (c_name = '51C0-563A0880-3-393E5AC0.vcf') OR (c_name = '3C80CB6E-66B670FF-4DB8E10C.vcf') OR (c_name = '7020725A-59772775-008F06DE.vcf') OR (c_name = 'CFA-59417580-3-6D0E0680.vcf') OR (c_name = '7CFBD8A1-51A2371F-543EEDFA.vcf') OR (c_name = '7815C61B-404363DF-03764719.vcf') OR (c_name = '2720-59328300-1-7EDA6E80.vcf') OR (c_name = '255E2D37-1D9E5C1E-49D5DD53.vcf') OR (c_name = '68ACAFB1-27FAA881-7A980FFC.vcf') OR (c_name = '060C5FF7-15CF4389-0F8E8470.vcf') OR (c_name = '5DA6-57F24500-1-53D8C680.vcf') OR (c_name = '2BB7-59DF5800-1-29D7FB80.vcf') OR (c_name = '7ED3A3FF-5F8E0C1F-6FEF6726.vcf') OR (c_name = '7E0-54159F00-1-1598FA20.vcf') OR (c_name = '212732E3-137C5BD1-7A6E9CDE.vcf') OR (c_name = '2F9C-59F5BE00-1-30F62600') OR (c_name = '586658A8-71D396FC-4B1E1835.vcf') OR (c_name = '3F1CC9A8-3F8C7808-78D954D9.vcf') OR (c_name = '7EA-54F82480-1-646B3D80.vcf') OR (c_name = '1893F11D-401B7EE6-355A2047.vcf') OR (c_name = '6A36283C-145A6CE0-257A92A1.vcf') OR (c_name = '2A798C1B-17D0B3FA-22766B42.vcf') OR (c_name = '4817E839-61A6914D-1A8C315D.vcf') OR (c_name = '701290BA-5C3EA149-3FEA5E95.vcf') OR (c_name = '05E1D444-6BCD25BA-28970E46.vcf') OR (c_name = '656FE063-5BBC8CE0-2EA36E3D.vcf') OR (c_name = '78EC3C35-562B29BE-2D77123C.vcf') OR (c_name = '6ABFD331-214941F3-4E9E451F.vcf') OR (c_name = '2A4C4B39-1A2296CC-27049DC7.vcf') OR (c_name = '6A67CA1F-4F7CB713-6621676F.vcf') OR (c_name = '600-599AC700-1-20C78BC0.vcf') OR (c_name = '7EC236FF-74F749B4-7EB5588C.vcf') OR (c_name = '1692EAF9-176DB4F6-68EB80C8.vcf') OR (c_name = '78397C46-31F9E654-13650CE4.vcf') OR (c_name = '7EE-5677AF80-1-FA72960.vcf') OR (c_name = '54781D90-71E444E9-5B7CF51D.vcf') OR (c_name = '4045434A-1A7B532F-4B8F85D8.vcf') OR (c_name = '1C01D02A-491EC16C-51715A1C.vcf') OR (c_name = '722CF9E9-7695D3A8-36E13A7F.vcf') OR (c_name = '13763BDC-453418C7-2FCD76B4.vcf') OR (c_name = '2D98D2A9-6C38B68E-1A8D49E5.vcf') OR (c_name = '108E-59F5BD80-1-3A9FA500') OR (c_name = '7D1589BC-525A1DFE-44D9951E.vcf') OR (c_name = '7E5-54F59D00-3-17421B60.vcf') OR (c_name = '7D6B-55F46700-1-6EB5D800.vcf') OR (c_name = '720CD371-510F768A-2F415F3D.vcf') OR (c_name = '097A8867-39FAF753-2E03963D.vcf') OR (c_name = '3B746EBB-4D600437-44968136.vcf') OR (c_name = '2D58B3A4-28DCF954-3CCFFD7D.vcf') OR (c_name = '47D406D3-746C7F2C-11481B0D.vcf') OR (c_name = '10F2C83F-45DDD948-518D5E57.vcf') OR (c_name = '07889BE7-7CBF13C8-6D8F2E81.vcf') OR (c_name = '2497-59DF5880-3-6A1D5F.vcf') OR (c_name = '51C0-563A0580-1-393E5AC0.vcf') OR (c_name = '4CBCB4AE-2C8C8A7C-5FBC286A.vcf') OR (c_name = '38F56B3D-4719D462-73326447.vcf') OR (c_name = '0B4F893B-0BF36980-20CB36F0.vcf') OR (c_name = '5C5EFFC5-3B34C8BE-1DE0C0AC.vcf') OR (c_name = '1659F718-69385EFB-0FED941D.vcf') OR (c_name = '63B9FB4F-2DCEE031-19681C85.vcf') OR (c_name = '2F9C-59F5BE00-5-30F62600') OR (c_name = '0C96F4A4-6A9EDDAE-54DC8B40.vcf') OR (c_name = '010373D0-7BE6F8BB-02353EE5.vcf') OR (c_name = '46E14D19-4D745712-4A0945B8.vcf') OR (c_name = '2980-54CA6000-B-8BFB1F0.vcf') OR (c_name = '617-594E9400-1-73209A8.vcf') OR (c_name = '43A060E1-3B038594-5AFC0DF8.vcf') OR (c_name = '143A-59F5BE00-1-4E410680') OR (c_name = '702CEB5D-1ABFADFE-6284A9DF.vcf') OR (c_name = '3746BFBF-0DF21245-2F415E8E.vcf') OR (c_name = '433A2940-2EBD4935-6836C9CB.vcf') OR (c_name = '49DDA30F-110F0E7B-7A58F375.vcf') OR (c_name = '7E6EF1FE-4C9E09E2-73865306.vcf') OR (c_name = '67A750F9-5C8B9DFF-4FE552CB.vcf') OR (c_name = '1576312A-75F3BA84-663F49E4.vcf') OR (c_name = '00150ED9-4AD045C5-49F94533.vcf')); 2018-09-25 15:27:17.200 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/personal/view HTTP/1.1" 200 32299/46 0.380 - - 260K 2018-09-25 15:27:17.687 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:17.687 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:17.688 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:17.688 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "GET /SOGo/so/nico/Contacts/E15-5BAA3780-5-6E17138/newguid HTTP/1.1" 200 69/0 0.010 - - -388K (null) env=REMOTE_HOST "GET /SOGo/so/nico/Contacts/UIxContactEditorTemplate HTTP/1.1" 200 3309/0 0.016 21132 84% 0 (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 19/194 10.748 - - 0 2018-09-25 15:27:22.518 sogod[3575] SQL: SELECT count(*) FROM sogo_cache_folder_nico; 2018-09-25 15:27:22.521 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.521 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:22.522 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.523 sogod[3575] SQL: UPDATE sogo_cache_folder_nico SET c_lastmodified = 1537882042, c_deleted = 0, c_version = 4107993, c_content = 'agIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj APcNAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4 NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj AGw+AAAQU3luY1JlcXVlc3QAmjaqWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0 NTAwNTE2MDAwMDA2NmYxNGRjADQsAAACUGluZ1JlcXVlc3QABQAAADM1NzUAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsAKQjAAAA' WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:22.549 sogod[3575] query has no results. 2018-09-25 15:27:22.550 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal'; 2018-09-25 15:27:22.551 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.553 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:22.554 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.555 sogod[3575] 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 = 'nico' AND c_path3 = 'Calendar' AND c_path4 = 'personal'; 2018-09-25 15:27:22.557 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.559 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:22.560 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.561 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal'; 2018-09-25 15:27:22.562 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.563 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:22.564 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.564 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:22.565 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.566 sogod[3575] 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 = 'nico' AND c_path3 = 'Contacts' AND c_path4 = 'personal'; 2018-09-25 15:27:22.567 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:22.569 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:22.569 sogod[3575] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc2043504472&DeviceType=Android HTTP/1.1" 200 19/194 10.761 - - 0 2018-09-25 15:27:22.993 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc'; 2018-09-25 15:27:22.994 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:23.075 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder64d3710c625f445005160000066f14dc'; 2018-09-25 15:27:23.077 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:23.170 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:23.172 sogod[3575] query has results, entering fetch-mode. Sep 25 15:27:23 sogod [3575]: <0x0x7feee77220f8[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user nico in Ping... 2018-09-25 15:27:23.346 sogod[3602] SQL: SELECT count(*) FROM sogo_cache_folder_jill; 2018-09-25 15:27:23.347 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.348 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:23.349 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.350 sogod[3602] SQL: UPDATE sogo_cache_folder_jill SET c_lastmodified = 1537882043, c_deleted = 0, c_version = 1453460, c_content = 'agIAABBQaW5nSGVhcnRiZWF0SW50ZXJ2YWwACgAAABBTeW5jUmVxdWVzdCt2ZXZlbnQvcGVy c29uYWwAwi0AABBTeW5jUmVxdWVzdCttYWlsLzliYjFjYzFjN2ZjOWVmNTMwYzBiMDAwMDlj ZmQyNTNjADQ1AAACRm9sZGVyU3luY0tleQAVAAAAbWFpbF8yOWI3XzIxMTQ0YzNkXzAABFBp bmdDYWNoZWRGb2xkZXJzAJQAAAACMAASAAAAdmV2ZW50JTJGcGVyc29uYWwAAjEAEQAAAHZj YXJkJTJGcGVyc29uYWwAAjIAKAAAAG1haWwlMkZhZmEzNDkwMWNkYTU1NTUwZWMxNjAwMDAw NjZmMTRkYwACMwAoAAAAbWFpbCUyRmQ2Y2ZlNjA4NmRhNjU1NTAyNzE3MDAwMDA2NmYxNGRj AAAQU3luY1JlcXVlc3QrbWFpbC9kNmNmZTYwODZkYTY1NTUwMjcxNzAwMDAwNjZmMTRkYwCZ VgAAEFN5bmNSZXF1ZXN0K21haWwvMTJmOWE4MTRlMGM0OGE1MDdkNmUwMDAwMDY2ZjE0ZGMA KToAABBTeW5jUmVxdWVzdAAbNqpbEFN5bmNSZXF1ZXN0K21haWwvYWZhMzQ5MDFjZGE1NTU1 MGVjMTYwMDAwMDY2ZjE0ZGMAmVYAABBTeW5jUmVxdWVzdCttYWlsLzY3N2NmYzI4YmFhNjU1 NTA0MTE3MDAwMDA2NmYxNGRjAK9dAAACUGluZ1JlcXVlc3QABQAAADM2MDIAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsANpKAAAA' WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:23.395 sogod[3602] query has no results. 2018-09-25 15:27:23.395 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vevent/personal'; 2018-09-25 15:27:23.396 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.397 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:23.398 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.399 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0010573755d ORDER BY c_lastmodified DESC; 2018-09-25 15:27:23.400 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.401 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vcard/personal'; 2018-09-25 15:27:23.403 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.404 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:23.405 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.405 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:23.406 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.406 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0022cb36c94 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:23.407 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.730 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderafa34901cda55550ec160000066f14dc'; 2018-09-25 15:27:23.731 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.771 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderd6cfe6086da6555027170000066f14dc'; 2018-09-25 15:27:23.773 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:23.862 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:23.864 sogod[3602] query has results, entering fetch-mode. Sep 25 15:27:23 sogod [3602]: <0x0x7feee7698b38[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user jill in Ping... (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 13/193 10.671 - - 0 2018-09-25 15:27:33.383 sogod[3575] SQL: SELECT count(*) FROM sogo_cache_folder_nico; 2018-09-25 15:27:33.385 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.386 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:33.387 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.388 sogod[3575] SQL: UPDATE sogo_cache_folder_nico SET c_lastmodified = 1537882053, c_deleted = 0, c_version = 4107994, c_content = 'agIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj APcNAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4 NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj AGw+AAAQU3luY1JlcXVlc3QAmjaqWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0 NTAwNTE2MDAwMDA2NmYxNGRjADQsAAACUGluZ1JlcXVlc3QABQAAADM1NzUAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsAKQjAAAA' WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:33.455 sogod[3575] query has no results. 2018-09-25 15:27:33.456 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal'; 2018-09-25 15:27:33.458 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.460 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:33.461 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.462 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:33.463 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.464 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal'; 2018-09-25 15:27:33.465 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.466 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:33.467 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.467 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:33.467 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.468 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:33.469 sogod[3575] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc2043504472&DeviceType=Android HTTP/1.1" 200 13/193 10.528 - - 0 2018-09-25 15:27:33.875 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc'; 2018-09-25 15:27:33.877 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:33.919 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder64d3710c625f445005160000066f14dc'; 2018-09-25 15:27:33.921 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:34.011 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:34.013 sogod[3575] query has results, entering fetch-mode. Sep 25 15:27:34 sogod [3575]: <0x0x7feee700d888[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user nico in Ping... 2018-09-25 15:27:34.480 sogod[3602] SQL: SELECT count(*) FROM sogo_cache_folder_jill; 2018-09-25 15:27:34.481 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.482 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:34.483 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.483 sogod[3602] SQL: UPDATE sogo_cache_folder_jill SET c_lastmodified = 1537882054, c_deleted = 0, c_version = 1453461, c_content = 'agIAABBQaW5nSGVhcnRiZWF0SW50ZXJ2YWwACgAAABBTeW5jUmVxdWVzdCt2ZXZlbnQvcGVy c29uYWwAwi0AABBTeW5jUmVxdWVzdCttYWlsLzliYjFjYzFjN2ZjOWVmNTMwYzBiMDAwMDlj ZmQyNTNjADQ1AAACRm9sZGVyU3luY0tleQAVAAAAbWFpbF8yOWI3XzIxMTQ0YzNkXzAABFBp bmdDYWNoZWRGb2xkZXJzAJQAAAACMAASAAAAdmV2ZW50JTJGcGVyc29uYWwAAjEAEQAAAHZj YXJkJTJGcGVyc29uYWwAAjIAKAAAAG1haWwlMkZhZmEzNDkwMWNkYTU1NTUwZWMxNjAwMDAw NjZmMTRkYwACMwAoAAAAbWFpbCUyRmQ2Y2ZlNjA4NmRhNjU1NTAyNzE3MDAwMDA2NmYxNGRj AAAQU3luY1JlcXVlc3QrbWFpbC9kNmNmZTYwODZkYTY1NTUwMjcxNzAwMDAwNjZmMTRkYwCZ VgAAEFN5bmNSZXF1ZXN0K21haWwvMTJmOWE4MTRlMGM0OGE1MDdkNmUwMDAwMDY2ZjE0ZGMA KToAABBTeW5jUmVxdWVzdAAbNqpbEFN5bmNSZXF1ZXN0K21haWwvYWZhMzQ5MDFjZGE1NTU1 MGVjMTYwMDAwMDY2ZjE0ZGMAmVYAABBTeW5jUmVxdWVzdCttYWlsLzY3N2NmYzI4YmFhNjU1 NTA0MTE3MDAwMDA2NmYxNGRjAK9dAAACUGluZ1JlcXVlc3QABQAAADM2MDIAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsANpKAAAA' WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:34.660 sogod[3602] query has no results. 2018-09-25 15:27:34.661 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vevent/personal'; 2018-09-25 15:27:34.662 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.664 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:34.665 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.666 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0010573755d ORDER BY c_lastmodified DESC; 2018-09-25 15:27:34.667 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.668 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vcard/personal'; 2018-09-25 15:27:34.669 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.671 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:34.671 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.671 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:34.672 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.673 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0022cb36c94 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:34.674 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:34.992 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderafa34901cda55550ec160000066f14dc'; 2018-09-25 15:27:34.993 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:35.034 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderd6cfe6086da6555027170000066f14dc'; 2018-09-25 15:27:35.036 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:35.123 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:35.126 sogod[3602] query has results, entering fetch-mode. Sep 25 15:27:35 sogod [3602]: <0x0x7feee770d178[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user jill in Ping... 2018-09-25 15:27:38.276 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:38.277 sogod[3605] query has no results. 2018-09-25 15:27:38.277 sogod[3605] SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='54UHbrdmNY1SZuX1yRatNQ=='; 2018-09-25 15:27:38.278 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.278 sogod[3605] SQL: ROLLBACK; 2018-09-25 15:27:38.279 sogod[3605] query has no results. 2018-09-25 15:27:38.286 sogod[3605] MySQL4 connection established 0x0x7feee767f690 2018-09-25 15:27:38.286 sogod[3605] MySQL4 channel 0x0x7feee7a34b28 opened (connection=0x0x7feee767f690,sogo) 2018-09-25 15:27:38.286 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:38.286 sogod[3605] query has no results. 2018-09-25 15:27:38.286 sogod[3605] SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='54UHbrdmNY1SZuX1yRatNQ=='; 2018-09-25 15:27:38.286 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.287 sogod[3605] SQL: ROLLBACK; 2018-09-25 15:27:38.287 sogod[3605] query has no results. 2018-09-25 15:27:38.287 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:38.287 sogod[3605] query has no results. 2018-09-25 15:27:38.288 sogod[3605] SQL: UPDATE sogo_sessions_folder SET c_value = 'IoJgbvtoexzkXQl/4bXlBLR/885A9siH/PNrm/E/R4kVMyhLm6iG0LaqMfKMo7Dndz20H5fWq2oqCEStFEmFkKzpJUm8G8KjrJpCYCT8PfVw8n/nW0Tk5f/V4M2U7igRGi8nmPzivr8fQQMHikgCekGwiSmdnYhttI2WA4K4vpUHO9+rEV17tNTBqnuSiG9x1JPNWiy/NFpbW+WGgAUohQ==', c_lastseen = 1537882058, c_creationdate = 1535955272, c_id = '54UHbrdmNY1SZuX1yRatNQ==' WHERE c_id='54UHbrdmNY1SZuX1yRatNQ=='; 2018-09-25 15:27:38.289 sogod[3605] query has no results. 2018-09-25 15:27:38.290 sogod[3605] SQL: COMMIT; 2018-09-25 15:27:38.376 sogod[3605] query has no results. 2018-09-25 15:27:38.416 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:38.416 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.417 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:38.417 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.418 sogod[3605] SQL: SELECT b.c_name,b.c_version,b.c_creationdate,b.c_lastmodified,a.c_component,b.c_content FROM sogonico002210e3ef5_quick a, sogonico002210e3ef5 b WHERE (a.c_name = 'E15-5BAA3780-7-6E17138.vcf') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL); 2018-09-25 15:27:38.421 sogod[3605] query has results, entering fetch-mode. Sep 25 15:27:38 sogod [3605]: <0x0x7feee7734488[GCSFolder]> should store content: 'E15-5BAA3780-7-6E17138.vcf' BEGIN:VCARD UID:E15-5BAA3780-7-6E17138.vcf VERSION:3.0 CLASS:PUBLIC PROFILE:VCARD N:Ort;Florian TEL;TYPE=cell:+31612076483 END:VCARD 2018-09-25 15:27:38.424 sogod[3605] SQL: SELECT c_version, c_deleted FROM sogonico002210e3ef5 WHERE (c_name = 'E15-5BAA3780-7-6E17138.vcf'); 2018-09-25 15:27:38.425 sogod[3605] query has results, entering fetch-mode. Sep 25 15:27:38 sogod [3605]: <0x0x7feee7734488[GCSFolder]> store quick: {"c_categories" = ""; "c_cn" = ""; "c_component" = vcard; "c_givenName" = Florian; "c_hascertificate" = 0; "c_mail" = ""; "c_name" = "E15-5BAA3780-7-6E17138.vcf"; "c_o" = ""; "c_ou" = ""; "c_screenname" = ""; "c_sn" = Ort; "c_telephonenumber" = "+31612076483"; } 2018-09-25 15:27:38.426 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:38.426 sogod[3605] query has no results. 2018-09-25 15:27:38.426 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:38.426 sogod[3605] query has no results. Sep 25 15:27:38 sogod [3605]: [ERROR] <0x0x7feee7734488[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_hascertificate 2018-09-25 15:27:38.427 sogod[3605] SQL: INSERT INTO sogonico002210e3ef5_quick (c_givenName, c_hascertificate, c_screenname, c_sn, c_name, c_component, c_mail, c_o, c_telephonenumber, c_categories, c_ou, c_cn) VALUES ('Florian', '', 'Ort', 'E15-5BAA3780-7-6E17138.vcf', 'vcard', null, '', '+31612076483', null, '', ''); 2018-09-25 15:27:38.428 sogod[3605] ERROR: Column count doesn't match value count at row 1 2018-09-25 15:27:38.428 sogod[3605] SQL: ROLLBACK; 2018-09-25 15:27:38.428 sogod[3605] query has no results. 2018-09-25 15:27:38.428 sogod[3605] SQL: ROLLBACK; 2018-09-25 15:27:38.429 sogod[3605] query has no results. Sep 25 15:27:38 sogod [3605]: <0x0x7feee7734488[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : NAME:ExecutionFailed REASON:Column count doesn't match value count at row 1 Sep 25 15:27:38 sogod [3605]: [ERROR] <0x7feee77a58d8[SOGoContactGCSEntry]:E15-5BAA3780-7-6E17138.vcf> write failed: NAME:ExecutionFailed REASON:Column count doesn't match value count at row 1 (null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/E15-5BAA3780-5-6E17138/E15-5BAA3780-7-6E17138.vcf/saveAsContact HTTP/1.1" 200 69/273 0.158 - - 0 2018-09-25 15:27:38.613 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:38.614 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.614 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:38.615 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.618 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:38.619 sogod[3605] query has no results. 2018-09-25 15:27:38.619 sogod[3605] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"], "ExpandedFolders": ["\\/0", "\\/0\\/folderINBOX"], "DragHandleVertical": "256", "folderForExpunge": "imap:\\/\\/nico@127.0.0.1:143\\/INBOX\\/"}, "Contacts": {"DragHandleVertical": "358"}, "Contact": {"SortingState": ["c_cn", "1"]}, "CalendarDefaultFilter": "view_today", "Calendar": {"EventsSortingState": ["start", "1"], "PreventInvitations": 0, "EventsFilterState": "view_next7", "ListState": "rise", "View": "weekview", "InactiveFolders": ["personal"], "DragHandleVertical": "167", "PreventInvitationsWhitelist": {}, "FoldersOrder": ["personal"], "SelectedList": "eventsListView"}}' WHERE c_uid = 'nico'; 2018-09-25 15:27:38.620 sogod[3605] query has no results. 2018-09-25 15:27:38.620 sogod[3605] SQL: COMMIT; 2018-09-25 15:27:38.639 sogod[3605] query has no results. 2018-09-25 15:27:38.640 sogod[3605] SQL: SELECT c_name, c_cn FROM sogonico002210e3ef5_quick ORDER BY c_cn ASC; 2018-09-25 15:27:38.641 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/E15-5BAA3780-5-6E17138/view HTTP/1.1" 200 170/46 0.034 - - 0 2018-09-25 15:27:38.771 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:38.772 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.772 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:38.773 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.777 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:38.777 sogod[3605] query has no results. 2018-09-25 15:27:38.778 sogod[3605] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"], "ExpandedFolders": ["\\/0", "\\/0\\/folderINBOX"], "DragHandleVertical": "256", "folderForExpunge": "imap:\\/\\/nico@127.0.0.1:143\\/INBOX\\/"}, "Contacts": {"DragHandleVertical": "358"}, "Contact": {"SortingState": ["c_cn", "1"]}, "Calendar": {"EventsSortingState": ["start", "1"], "ListState": "rise", "EventsFilterState": "view_next7", "PreventInvitations": 0, "InactiveFolders": ["personal"], "View": "weekview", "PreventInvitationsWhitelist": {}, "DragHandleVertical": "167", "FoldersOrder": ["personal"], "SelectedList": "eventsListView"}, "CalendarDefaultFilter": "view_today"}' WHERE c_uid = 'nico'; 2018-09-25 15:27:38.778 sogod[3605] query has no results. 2018-09-25 15:27:38.778 sogod[3605] SQL: COMMIT; 2018-09-25 15:27:38.830 sogod[3605] query has no results. 2018-09-25 15:27:38.831 sogod[3605] SQL: SELECT c_name, c_cn FROM sogonico00251821f30_quick ORDER BY c_cn ASC; 2018-09-25 15:27:38.832 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:38.836 sogod[3605] SQL: SELECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM sogonico00251821f30_quick WHERE ((c_name = '056A5934-20D9C14A-24DA1822.vcf') OR (c_name = 'DE1-59BF9F80-1-63A7F980.vcf') OR (c_name = '3259-59F5BD80-1-56288500') OR (c_name = '76761D16-5B877202-593BBF5B.vcf') OR (c_name = '6EB9CB7E-17283D1A-6E3E8733.vcf') OR (c_name = '2B5E-58F87E80-1-39276640.vcf') OR (c_name = '2D015424-6A629C70-322E79A1.vcf') OR (c_name = '63784EA5-643441CA-16061B5D.vcf') OR (c_name = '5BEA2D8D-4B6A6E42-5A112DCC.vcf') OR (c_name = '6A2F871C-2A1E5301-5B6793C2.vcf') OR (c_name = '2A68EB78-4630459F-298C4ADC.vcf') OR (c_name = '6F61A5E1-5D0BC14D-14EB96E1.vcf') OR (c_name = '32D625D2-0EC58ECA-2F774B3A.vcf') OR (c_name = '53AFE71C-339FA6EC-72C0B675.vcf') OR (c_name = '2F37591F-0CDB6647-782B0FAA.vcf') OR (c_name = '465F9639-7B19ED7A-6EA12CC0.vcf') OR (c_name = '4546-569E0900-1-182898C0.vcf') OR (c_name = '30C232A9-2D48671C-5D5AF83E.vcf') OR (c_name = '14F67474-434E8279-0A5C4C63.vcf') OR (c_name = '2F9C-59F5BE00-3-30F62600') OR (c_name = '6060E2B6-1D5FB046-6DD49B08.vcf') OR (c_name = '0A7F35B7-78C74408-49BEC896.vcf') OR (c_name = '50AF7B57-22538EE4-33EE4FB2.vcf') OR (c_name = '2DBB3CA4-373F25C5-5E573B2A.vcf') OR (c_name = '51C0-563A0880-3-393E5AC0.vcf') OR (c_name = '3C80CB6E-66B670FF-4DB8E10C.vcf') OR (c_name = '7020725A-59772775-008F06DE.vcf') OR (c_name = 'CFA-59417580-3-6D0E0680.vcf') OR (c_name = '7CFBD8A1-51A2371F-543EEDFA.vcf') OR (c_name = '7815C61B-404363DF-03764719.vcf') OR (c_name = '2720-59328300-1-7EDA6E80.vcf') OR (c_name = '255E2D37-1D9E5C1E-49D5DD53.vcf') OR (c_name = '68ACAFB1-27FAA881-7A980FFC.vcf') OR (c_name = '060C5FF7-15CF4389-0F8E8470.vcf') OR (c_name = '5DA6-57F24500-1-53D8C680.vcf') OR (c_name = '2BB7-59DF5800-1-29D7FB80.vcf') OR (c_name = '7ED3A3FF-5F8E0C1F-6FEF6726.vcf') OR (c_name = '7E0-54159F00-1-1598FA20.vcf') OR (c_name = '212732E3-137C5BD1-7A6E9CDE.vcf') OR (c_name = '2F9C-59F5BE00-1-30F62600') OR (c_name = '586658A8-71D396FC-4B1E1835.vcf') OR (c_name = '3F1CC9A8-3F8C7808-78D954D9.vcf') OR (c_name = '7EA-54F82480-1-646B3D80.vcf') OR (c_name = '1893F11D-401B7EE6-355A2047.vcf') OR (c_name = '6A36283C-145A6CE0-257A92A1.vcf') OR (c_name = '2A798C1B-17D0B3FA-22766B42.vcf') OR (c_name = '4817E839-61A6914D-1A8C315D.vcf') OR (c_name = '701290BA-5C3EA149-3FEA5E95.vcf') OR (c_name = '05E1D444-6BCD25BA-28970E46.vcf') OR (c_name = '656FE063-5BBC8CE0-2EA36E3D.vcf') OR (c_name = '78EC3C35-562B29BE-2D77123C.vcf') OR (c_name = '6ABFD331-214941F3-4E9E451F.vcf') OR (c_name = '2A4C4B39-1A2296CC-27049DC7.vcf') OR (c_name = '6A67CA1F-4F7CB713-6621676F.vcf') OR (c_name = '600-599AC700-1-20C78BC0.vcf') OR (c_name = '7EC236FF-74F749B4-7EB5588C.vcf') OR (c_name = '1692EAF9-176DB4F6-68EB80C8.vcf') OR (c_name = '78397C46-31F9E654-13650CE4.vcf') OR (c_name = '7EE-5677AF80-1-FA72960.vcf') OR (c_name = '54781D90-71E444E9-5B7CF51D.vcf') OR (c_name = '4045434A-1A7B532F-4B8F85D8.vcf') OR (c_name = '1C01D02A-491EC16C-51715A1C.vcf') OR (c_name = '722CF9E9-7695D3A8-36E13A7F.vcf') OR (c_name = '13763BDC-453418C7-2FCD76B4.vcf') OR (c_name = '2D98D2A9-6C38B68E-1A8D49E5.vcf') OR (c_name = '108E-59F5BD80-1-3A9FA500') OR (c_name = '7D1589BC-525A1DFE-44D9951E.vcf') OR (c_name = '7E5-54F59D00-3-17421B60.vcf') OR (c_name = '7D6B-55F46700-1-6EB5D800.vcf') OR (c_name = '720CD371-510F768A-2F415F3D.vcf') OR (c_name = '097A8867-39FAF753-2E03963D.vcf') OR (c_name = '3B746EBB-4D600437-44968136.vcf') OR (c_name = '2D58B3A4-28DCF954-3CCFFD7D.vcf') OR (c_name = '47D406D3-746C7F2C-11481B0D.vcf') OR (c_name = '10F2C83F-45DDD948-518D5E57.vcf') OR (c_name = '07889BE7-7CBF13C8-6D8F2E81.vcf') OR (c_name = '2497-59DF5880-3-6A1D5F.vcf') OR (c_name = '51C0-563A0580-1-393E5AC0.vcf') OR (c_name = '4CBCB4AE-2C8C8A7C-5FBC286A.vcf') OR (c_name = '38F56B3D-4719D462-73326447.vcf') OR (c_name = '0B4F893B-0BF36980-20CB36F0.vcf') OR (c_name = '5C5EFFC5-3B34C8BE-1DE0C0AC.vcf') OR (c_name = '1659F718-69385EFB-0FED941D.vcf') OR (c_name = '63B9FB4F-2DCEE031-19681C85.vcf') OR (c_name = '2F9C-59F5BE00-5-30F62600') OR (c_name = '0C96F4A4-6A9EDDAE-54DC8B40.vcf') OR (c_name = '010373D0-7BE6F8BB-02353EE5.vcf') OR (c_name = '46E14D19-4D745712-4A0945B8.vcf') OR (c_name = '2980-54CA6000-B-8BFB1F0.vcf') OR (c_name = '617-594E9400-1-73209A8.vcf') OR (c_name = '43A060E1-3B038594-5AFC0DF8.vcf') OR (c_name = '143A-59F5BE00-1-4E410680') OR (c_name = '702CEB5D-1ABFADFE-6284A9DF.vcf') OR (c_name = '3746BFBF-0DF21245-2F415E8E.vcf') OR (c_name = '433A2940-2EBD4935-6836C9CB.vcf') OR (c_name = '49DDA30F-110F0E7B-7A58F375.vcf') OR (c_name = '7E6EF1FE-4C9E09E2-73865306.vcf') OR (c_name = '67A750F9-5C8B9DFF-4FE552CB.vcf') OR (c_name = '1576312A-75F3BA84-663F49E4.vcf') OR (c_name = '00150ED9-4AD045C5-49F94533.vcf')); 2018-09-25 15:27:38.838 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/personal/view HTTP/1.1" 200 32299/46 0.126 - - 524K (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 19/194 10.685 - - 0 2018-09-25 15:27:44.228 sogod[3575] SQL: SELECT count(*) FROM sogo_cache_folder_nico; 2018-09-25 15:27:44.229 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.230 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:44.231 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.232 sogod[3575] SQL: UPDATE sogo_cache_folder_nico SET c_lastmodified = 1537882064, c_deleted = 0, c_version = 4107995, c_content = 'agIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj APcNAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4 NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj AGw+AAAQU3luY1JlcXVlc3QAmjaqWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0 NTAwNTE2MDAwMDA2NmYxNGRjADQsAAACUGluZ1JlcXVlc3QABQAAADM1NzUAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsAKQjAAAA' WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:44.254 sogod[3575] query has no results. 2018-09-25 15:27:44.254 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal'; 2018-09-25 15:27:44.255 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.257 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:44.258 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.259 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:44.259 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.261 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal'; 2018-09-25 15:27:44.262 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.263 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:44.264 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.264 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:44.265 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.265 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:44.266 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.732 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc'; 2018-09-25 15:27:44.733 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.815 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder64d3710c625f445005160000066f14dc'; 2018-09-25 15:27:44.817 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:44.907 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:44.910 sogod[3575] query has results, entering fetch-mode. Sep 25 15:27:44 sogod [3575]: <0x0x7feee768f008[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user nico in Ping... (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc2043504472&DeviceType=Android HTTP/1.1" 200 19/194 10.661 - - 0 2018-09-25 15:27:45.744 sogod[3602] SQL: SELECT count(*) FROM sogo_cache_folder_jill; 2018-09-25 15:27:45.745 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.746 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:45.747 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.748 sogod[3602] SQL: UPDATE sogo_cache_folder_jill SET c_lastmodified = 1537882065, c_deleted = 0, c_version = 1453462, c_content = 'agIAABBQaW5nSGVhcnRiZWF0SW50ZXJ2YWwACgAAABBTeW5jUmVxdWVzdCt2ZXZlbnQvcGVy c29uYWwAwi0AABBTeW5jUmVxdWVzdCttYWlsLzliYjFjYzFjN2ZjOWVmNTMwYzBiMDAwMDlj ZmQyNTNjADQ1AAACRm9sZGVyU3luY0tleQAVAAAAbWFpbF8yOWI3XzIxMTQ0YzNkXzAABFBp bmdDYWNoZWRGb2xkZXJzAJQAAAACMAASAAAAdmV2ZW50JTJGcGVyc29uYWwAAjEAEQAAAHZj YXJkJTJGcGVyc29uYWwAAjIAKAAAAG1haWwlMkZhZmEzNDkwMWNkYTU1NTUwZWMxNjAwMDAw NjZmMTRkYwACMwAoAAAAbWFpbCUyRmQ2Y2ZlNjA4NmRhNjU1NTAyNzE3MDAwMDA2NmYxNGRj AAAQU3luY1JlcXVlc3QrbWFpbC9kNmNmZTYwODZkYTY1NTUwMjcxNzAwMDAwNjZmMTRkYwCZ VgAAEFN5bmNSZXF1ZXN0K21haWwvMTJmOWE4MTRlMGM0OGE1MDdkNmUwMDAwMDY2ZjE0ZGMA KToAABBTeW5jUmVxdWVzdAAbNqpbEFN5bmNSZXF1ZXN0K21haWwvYWZhMzQ5MDFjZGE1NTU1 MGVjMTYwMDAwMDY2ZjE0ZGMAmVYAABBTeW5jUmVxdWVzdCttYWlsLzY3N2NmYzI4YmFhNjU1 NTA0MTE3MDAwMDA2NmYxNGRjAK9dAAACUGluZ1JlcXVlc3QABQAAADM2MDIAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsANpKAAAA' WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:45.763 sogod[3602] query has no results. 2018-09-25 15:27:45.764 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vevent/personal'; 2018-09-25 15:27:45.766 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.767 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:45.768 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.770 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0010573755d ORDER BY c_lastmodified DESC; 2018-09-25 15:27:45.770 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.771 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vcard/personal'; 2018-09-25 15:27:45.772 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.774 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:45.775 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.775 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:45.775 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:45.776 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0022cb36c94 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:45.777 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:46.097 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderafa34901cda55550ec160000066f14dc'; 2018-09-25 15:27:46.099 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:46.140 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderd6cfe6086da6555027170000066f14dc'; 2018-09-25 15:27:46.142 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:46.232 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:46.235 sogod[3602] query has results, entering fetch-mode. Sep 25 15:27:46 sogod [3602]: <0x0x7feee78922b8[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user jill in Ping... (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 13/193 10.719 - - 0 2018-09-25 15:27:55.185 sogod[3575] SQL: SELECT count(*) FROM sogo_cache_folder_nico; 2018-09-25 15:27:55.187 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.188 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:55.189 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.190 sogod[3575] SQL: UPDATE sogo_cache_folder_nico SET c_lastmodified = 1537882075, c_deleted = 0, c_version = 4107996, c_content = 'agIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj APcNAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4 NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj AGw+AAAQU3luY1JlcXVlc3QAmjaqWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0 NTAwNTE2MDAwMDA2NmYxNGRjADQsAAACUGluZ1JlcXVlc3QABQAAADM1NzUAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsAKQjAAAA' WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:55.235 sogod[3575] query has no results. 2018-09-25 15:27:55.236 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal'; 2018-09-25 15:27:55.238 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.241 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:55.242 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.243 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:55.244 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.245 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal'; 2018-09-25 15:27:55.246 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.248 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:55.248 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.249 sogod[3575] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:55.249 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.250 sogod[3575] SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:55.251 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.654 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc'; 2018-09-25 15:27:55.655 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.740 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder64d3710c625f445005160000066f14dc'; 2018-09-25 15:27:55.742 sogod[3575] query has results, entering fetch-mode. 2018-09-25 15:27:55.832 sogod[3575] SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237'; 2018-09-25 15:27:55.834 sogod[3575] query has results, entering fetch-mode. Sep 25 15:27:55 sogod [3575]: <0x0x7feee7666d98[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user nico in Ping... 2018-09-25 15:27:55.885 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:55.886 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:55.886 sogod[3605] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact'; 2018-09-25 15:27:55.886 sogod[3605] query has results, entering fetch-mode. 2018-09-25 15:27:55.889 sogod[3605] SQL: BEGIN; 2018-09-25 15:27:55.890 sogod[3605] query has no results. 2018-09-25 15:27:55.890 sogod[3605] SQL: UPDATE sogo_user_profile SET c_settings = '{"Mail": {"SortingState": ["date", "0"], "ExpandedFolders": ["\\/0", "\\/0\\/folderINBOX"], "DragHandleVertical": "256", "folderForExpunge": "imap:\\/\\/nico@127.0.0.1:143\\/INBOX\\/"}, "Contacts": {"DragHandleVertical": "358"}, "Contact": {"SortingState": ["c_cn", "1"]}, "CalendarDefaultFilter": "view_today", "Calendar": {"EventsSortingState": ["start", "1"], "PreventInvitations": 0, "EventsFilterState": "view_next7", "ListState": "rise", "View": "weekview", "InactiveFolders": ["personal"], "DragHandleVertical": "167", "PreventInvitationsWhitelist": {}, "FoldersOrder": ["personal"], "SelectedList": "eventsListView"}}' WHERE c_uid = 'nico'; 2018-09-25 15:27:55.891 sogod[3605] query has no results. 2018-09-25 15:27:55.891 sogod[3605] SQL: COMMIT; 2018-09-25 15:27:55.931 sogod[3605] query has no results. 2018-09-25 15:27:55.932 sogod[3605] SQL: SELECT c_name, c_cn FROM sogonico002210e3ef5_quick ORDER BY c_cn ASC; 2018-09-25 15:27:55.932 sogod[3605] query has results, entering fetch-mode. (null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/E15-5BAA3780-5-6E17138/view HTTP/1.1" 200 170/46 0.053 - - -416K (null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=&DeviceId=androidc2043504472&DeviceType=Android HTTP/1.1" 200 13/193 10.508 - - 0 2018-09-25 15:27:56.696 sogod[3602] SQL: SELECT count(*) FROM sogo_cache_folder_jill; 2018-09-25 15:27:56.697 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.698 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:56.700 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.700 sogod[3602] SQL: UPDATE sogo_cache_folder_jill SET c_lastmodified = 1537882076, c_deleted = 0, c_version = 1453463, c_content = 'agIAABBQaW5nSGVhcnRiZWF0SW50ZXJ2YWwACgAAABBTeW5jUmVxdWVzdCt2ZXZlbnQvcGVy c29uYWwAwi0AABBTeW5jUmVxdWVzdCttYWlsLzliYjFjYzFjN2ZjOWVmNTMwYzBiMDAwMDlj ZmQyNTNjADQ1AAACRm9sZGVyU3luY0tleQAVAAAAbWFpbF8yOWI3XzIxMTQ0YzNkXzAABFBp bmdDYWNoZWRGb2xkZXJzAJQAAAACMAASAAAAdmV2ZW50JTJGcGVyc29uYWwAAjEAEQAAAHZj YXJkJTJGcGVyc29uYWwAAjIAKAAAAG1haWwlMkZhZmEzNDkwMWNkYTU1NTUwZWMxNjAwMDAw NjZmMTRkYwACMwAoAAAAbWFpbCUyRmQ2Y2ZlNjA4NmRhNjU1NTAyNzE3MDAwMDA2NmYxNGRj AAAQU3luY1JlcXVlc3QrbWFpbC9kNmNmZTYwODZkYTY1NTUwMjcxNzAwMDAwNjZmMTRkYwCZ VgAAEFN5bmNSZXF1ZXN0K21haWwvMTJmOWE4MTRlMGM0OGE1MDdkNmUwMDAwMDY2ZjE0ZGMA KToAABBTeW5jUmVxdWVzdAAbNqpbEFN5bmNSZXF1ZXN0K21haWwvYWZhMzQ5MDFjZGE1NTU1 MGVjMTYwMDAwMDY2ZjE0ZGMAmVYAABBTeW5jUmVxdWVzdCttYWlsLzY3N2NmYzI4YmFhNjU1 NTA0MTE3MDAwMDA2NmYxNGRjAK9dAAACUGluZ1JlcXVlc3QABQAAADM2MDIAEFN5bmNSZXF1 ZXN0K3ZjYXJkL3BlcnNvbmFsANpKAAAA' WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:56.744 sogod[3602] query has no results. 2018-09-25 15:27:56.745 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vevent/personal'; 2018-09-25 15:27:56.746 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.747 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Appointment'; 2018-09-25 15:27:56.748 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.749 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0010573755d ORDER BY c_lastmodified DESC; 2018-09-25 15:27:56.750 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.751 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+vcard/personal'; 2018-09-25 15:27:56.752 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.754 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:56.754 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.755 sogod[3602] SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'jill' AND c_folder_type = 'Contact'; 2018-09-25 15:27:56.755 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:56.756 sogod[3602] SQL: SELECT c_lastmodified, c_lastmodified FROM sogojill0022cb36c94 ORDER BY c_lastmodified DESC; 2018-09-25 15:27:56.756 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:57.079 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderafa34901cda55550ec160000066f14dc'; 2018-09-25 15:27:57.080 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:57.123 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472+folderd6cfe6086da6555027170000066f14dc'; 2018-09-25 15:27:57.124 sogod[3602] query has results, entering fetch-mode. 2018-09-25 15:27:57.211 sogod[3602] SQL: SELECT * FROM sogo_cache_folder_jill WHERE c_path = '/androidc2043504472'; 2018-09-25 15:27:57.214 sogod[3602] query has results, entering fetch-mode. Sep 25 15:27:57 sogod [3602]: <0x0x7feee704c5c8[SOGoActiveSyncDispatcher]> Sleeping 10 seconds while detecting changes for user jill in Ping...