2018-09-25 09:01:35.288 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact';
2018-09-25 09:01:35.289 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has results, entering fetch-mode.
2018-09-25 09:01:35.289 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact';
2018-09-25 09:01:35.290 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has results, entering fetch-mode.
2018-09-25 09:01:35.291 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/nico/Contacts/collected';
2018-09-25 09:01:35.292 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has results, entering fetch-mode.
2018-09-25 09:01:35.292 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/nico/Contacts/personal';
2018-09-25 09:01:35.293 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has results, entering fetch-mode.
2018-09-25 09:01:35.294 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'nico' AND c_path3 = 'Contacts' AND c_path4 = '2C34-5BA9DD80-1-7AFF9C80';
2018-09-25 09:01:35.295 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has results, entering fetch-mode.
2018-09-25 09:01:35.296 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: BEGIN;
2018-09-25 09:01:35.296 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has no results.
2018-09-25 09:01:35.296 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> 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/2C34-5BA9DD80-1-7AFF9C80', 'Users', 'nico', 'Contacts', '2C34-5BA9DD80-1-7AFF9C80', 'Test', 'mysql://sogo:<PASSWORD>@<SERVER>:3306/sogo/sogonico0015b07c5df',         'mysql://sogo:<PASSWORD>@<SERVER>:3306/sogo/sogonico0015b07c5df_quick', 'mysql://sogo:<PASSWORD>@<SERVER>:3306/sogo/sogonico0015b07c5df_acl', 'Contact');
2018-09-25 09:01:35.297 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has no results.
2018-09-25 09:01:35.298 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: CREATE TABLE sogonico0015b07c5df (
  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 09:01:35.765 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has no results.
2018-09-25 09:01:35.765 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: CREATE TABLE sogonico0015b07c5df_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 09:01:36.297 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has no results.
2018-09-25 09:01:36.297 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: CREATE TABLE sogonico0015b07c5df_acl (
  c_uid VARCHAR (255) NOT NULL,
  c_object VARCHAR (255) NOT NULL,
  c_role VARCHAR (80) NOT NULL
);
2018-09-25 09:01:37.101 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has no results.
2018-09-25 09:01:37.101 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40> SQL: COMMIT;
2018-09-25 09:01:37.102 sogod[11316] <MySQL4Channel[0x0x7fd254940a98] connection=0x0x7fd255127b40>   query has no results.
(null) env=REMOTE_HOST "POST /SOGo/so/nico/Contacts/createFolder HTTP/1.1" 201 34/15 1.820 - - 12K
(null) env=REMOTE_HOST "POST /SOGo/Microsoft-Server-ActiveSync?Cmd=Ping&User=<EMAILADDRESS>&DeviceId=androidc775797237&DeviceType=Android HTTP/1.1" 200 19/194 10.636 - - 0
2018-09-25 09:01:38.279 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500> SQL: SELECT count(*) FROM sogo_cache_folder_nico;
2018-09-25 09:01:38.281 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500>   query has results, entering fetch-mode.
2018-09-25 09:01:38.282 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500> SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237';
2018-09-25 09:01:38.282 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500>   query has results, entering fetch-mode.
2018-09-25 09:01:38.283 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390> SQL: UPDATE sogo_cache_folder_nico  SET c_lastmodified = 1537858898, c_deleted = 0,      c_version = 4106064, c_content = 'awIAABBTeW5jUmVxdWVzdCttYWlsLzBmMmRhNTE1ODcwNTcxNTI4MTBjMDAwMDA2NmYxNGRj
ADQsAAAQUGluZ0hlYXJ0YmVhdEludGVydmFsAAoAAAAQU3luY1JlcXVlc3QrdmV2ZW50L3Bl
cnNvbmFsAIAOAAAQU3luY1JlcXVlc3QrbWFpbC9kYThmZWYyMDY5ODU1MTUwYzQxYzAwMDAw
NjZmMTRkYwD2VwAAEFN5bmNSZXF1ZXN0K21haWwvNjNkMzcxMGM2MjVmNDQ1MDA1MTYwMDAw
MDY2ZjE0ZGMA904AAARQaW5nQ2FjaGVkRm9sZGVycwCUAAAAAjAAEgAAAHZldmVudCUyRnBl
cnNvbmFsAAIxABEAAAB2Y2FyZCUyRnBlcnNvbmFsAAIyACgAAABtYWlsJTJGMGYyZGE1MTU4
NzA1NzE1MjgxMGMwMDAwMDY2ZjE0ZGMAAjMAKAAAAG1haWwlMkY2NGQzNzEwYzYyNWY0NDUw
MDUxNjAwMDAwNjZmMTRkYwAAAkZvbGRlclN5bmNLZXkAFQAAAG1haWxfNjMxY18yMTQ4NDRi
NF8wABBTeW5jUmVxdWVzdCttYWlsL2RhNzE4MzJmNjU1NTRkNTFkZDI0MDAwMDA2NmYxNGRj
AGw+AAAQU3luY1JlcXVlc3QA0typWxBTeW5jUmVxdWVzdCttYWlsLzY0ZDM3MTBjNjI1ZjQ0
NTAwNTE2MDAwMDA2NmYxNGRjANw4AAACUGluZ1JlcXVlc3QABgAAADIzNTA5ABBTeW5jUmVx
dWVzdCt2Y2FyZC9wZXJzb25hbACkIwAAAA==' WHERE c_path = '/androidc775797237';
2018-09-25 09:01:38.301 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390>   query has no results.
2018-09-25 09:01:38.302 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390> SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vevent/personal';
2018-09-25 09:01:38.304 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390>   query has results, entering fetch-mode.
2018-09-25 09:01:38.306 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Appointment';
2018-09-25 09:01:38.307 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500>   query has results, entering fetch-mode.
2018-09-25 09:01:38.308 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390> SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00130c60c38 ORDER BY c_lastmodified DESC;
2018-09-25 09:01:38.309 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390>   query has results, entering fetch-mode.
2018-09-25 09:01:38.310 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390> SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+vcard/personal';
2018-09-25 09:01:38.311 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390>   query has results, entering fetch-mode.
2018-09-25 09:01:38.312 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact';
2018-09-25 09:01:38.313 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500>   query has results, entering fetch-mode.
2018-09-25 09:01:38.314 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'nico' AND c_folder_type = 'Contact';
2018-09-25 09:01:38.314 sogod[23509] <MySQL4Channel[0x0x7fd254e6f6f8] connection=0x0x7fd25510e390>   query has results, entering fetch-mode.
2018-09-25 09:01:38.315 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500> SQL: SELECT c_lastmodified, c_lastmodified FROM sogonico00251821f30 ORDER BY c_lastmodified DESC;
2018-09-25 09:01:38.316 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500>   query has results, entering fetch-mode.
2018-09-25 09:01:38.725 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500> SQL: SELECT * FROM sogo_cache_folder_nico WHERE c_path = '/androidc775797237+folder0f2da51587057152810c0000066f14dc';
2018-09-25 09:01:38.727 sogod[23509] <MySQL4Channel[0x0x7fd254ed1ba8] connection=0x0x7fd255e4b500>   query has results, entering fetch-mode.