View Issue Details

IDProjectCategoryView StatusLast Update
0004465SOGoBackend Address Bookpublic2018-05-16 09:10
ReporterLukas Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status newResolutionopen 
Platform[Server] LinuxOSUbuntuOS Version16.04 LTS
Product Version4.0.0 
Summary0004465: SOGoContactsCategories does not work
Description

Parameter "SOGoContactsCategories" does not work.

Steps To Reproduce

1.
Cleanup all SQL Tables except sogo_view. Login with user. Restart sogo service and/or reboot server.

2.
Go to Address Book. Create a new address book card. Field "Category" is blank.

3.
Go to Preferences > Address Book. No Contact Categories are available. If i add one, then i see this category by creating a new address book card.

Tested with followed configuration (sogo.conf):

a.
SOGoContactsCategories = ("Familie", "Freunde");

b.
SOGoContactsCategories = (Familie, Freunde);

TagsNo tags attached.

Activities

Christian Mack

Christian Mack

2018-05-16 07:20

developer   ~0012880

Those will only be set, when the user account gets created in SOGo.
Did you login with that user before setting those categories in sogo.conf?
If yes, then you have to remove that user first and relogin, or set those individually for existing accounts.

Lukas

Lukas

2018-05-16 08:45

reporter   ~0012881

I know. First when i log in, my account will be created and all settings gets created in the table "sogo_user_profile".

I deleted all tables like sogo<user>..._acl/quick and cleaned up all tables:

  • sogo_alarms_folder
  • sogo_folder_info
  • sogo_sessions_folder
  • sogo_user_profile

Wenn i log in, all settings gets created new. Just contact categories do not bee created. I use sql authentification. I think, it doesn't matter, when i delete my user in sql and create it new.

When i change settings in sogo.conf, which services should be restarted?
I do allways: systemctl restart sogo memcached

Lukas

Lukas

2018-05-16 09:02

reporter   ~0012882

Last edited: 2018-05-16 09:10

root@sogo:/etc/sogo# tail -f /var/log/sogo/sogo.log
2018-05-16 10:55:36.974 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:55:36.974 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT count() FROM sogo_alarms_folder;
2018-05-16 10:55:36.974 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:55:36.974 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:55:36.975 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT count(
) FROM sogo_sessions_folder;
May 16 10:55:36 sogod [5273]: <0x0x55a855fac540[WOHttpAdaptor]> notified the watchdog that we are ready
2018-05-16 10:55:36.975 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:55:36.975 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT count(*) FROM sogo_alarms_folder;
2018-05-16 10:55:36.976 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
May 16 10:55:36 sogod [5272]: <0x0x55a855fac540[WOHttpAdaptor]> notified the watchdog that we are ready
May 16 10:56:02 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/'
May 16 10:56:02 sogod [5272]: <0x0x55a855c749a0[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
May 16 10:56:02 sogod [5272]: <0x0x55a855c749a0[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
May 16 10:56:02 sogod [5272]: [WARN] <0x0x7f0a9e2b1cc0[WOxElemBuilder]> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
2018-05-16 10:56:02.591 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'anonymous';
2018-05-16 10:56:02.591 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
May 16 10:56:02 sogod [5272]: |SOGo| constructed root-url: /SOGo/
May 16 10:56:02 sogod [5272]: |SOGo| setting root-url in context: /SOGo/so/
May 16 10:56:02 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:02 sogod [5272]: |SOGo| request took 0.022233 seconds to execute
May 16 10:56:02 sogod [5272]: 141.3.81.20 "GET /SOGo/so/ HTTP/1.1" 200 22762/0 0.026 - - 4M
2018-05-16 10:56:15.037 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT * FROM sogo_view WHERE (c_uid = 'login') OR (mail = 'login');
2018-05-16 10:56:15.037 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
May 16 10:56:15 sogod [5272]: |SOGo| request took 0.010676 seconds to execute
May 16 10:56:15 sogod [5272]: 141.3.81.20 "GET /SOGo/so/login?language=German HTTP/1.1" 200 22765/0 0.012 - - 212K
May 16 10:56:21 sogod [5272]: |SOGo| starting method 'POST' on uri '/SOGo/connect'
2018-05-16 10:56:21.418 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT c_password FROM sogo_view WHERE c_uid = 'lukas';
2018-05-16 10:56:21.418 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
May 16 10:56:21 sogod [5272]: SOGoRootPage successful login from '141.3.81.20' for user 'lukas' - expire = -1 grace = -1
2018-05-16 10:56:21.419 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT * FROM sogo_view WHERE (c_uid = 'lukas') OR (mail = 'lukas');
2018-05-16 10:56:21.420 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:56:21.422 sogod[5272] MySQL4 connection established 0x0x55a8563bf010
2018-05-16 10:56:21.422 sogod[5272] MySQL4 channel 0x0x55a8561f8500 opened (connection=0x0x55a8563bf010,sogo)
2018-05-16 10:56:21.422 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: BEGIN;
2018-05-16 10:56:21.422 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:21.422 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT t1.c_creationdate, t1.c_id, t1.c_lastseen, t1.c_value FROM sogo_sessions_folder t1 WHERE t1.c_id='Wt5syBL9kjsFq5ZK3KHPlw==';
2018-05-16 10:56:21.423 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:21.423 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: ROLLBACK;
2018-05-16 10:56:21.423 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:21.423 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: BEGIN;
2018-05-16 10:56:21.423 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:21.423 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: INSERT INTO sogo_sessions_folder (c_lastseen, c_creationdate, c_value, c_id) VALUES (1526460981, 1526460981, 'qEDuS8JzPa11466m9PDnLGi0MNZCEh92tge7Ky+iDrzARD9SjsBWq/Kt0XS0h+okVsBdbYKu8yGXPNIFO0gz4f6EgFo+1TwPukHdo/gqc7GzQnl7MHMBYE0HEL4XZMHu399CVkzCAqqLJH1XeWJnUMo1Z9umqgFmh1ngV1WY93pnGfIbP2hkUy40u4236qPFOVciZj+GSPf2NUf/hHN46A==', 'Wt5syBL9kjsFq5ZK3KHPlw==');
2018-05-16 10:56:21.424 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:21.424 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: COMMIT;
2018-05-16 10:56:21.428 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:21.429 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_defaults FROM sogo_user_profile WHERE c_uid = 'lukas';
2018-05-16 10:56:21.429 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:21.429 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: BEGIN;
2018-05-16 10:56:21.430 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:21.430 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: INSERT INTO sogo_user_profile (c_uid, c_defaults) VALUES ('lukas', '{"SOGoLanguage": "German"}');
2018-05-16 10:56:21.430 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:21.430 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: COMMIT;
2018-05-16 10:56:21.434 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
May 16 10:56:21 sogod [5272]: [WARN] <0x0x55a85637aae0[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
May 16 10:56:21 sogod [5272]: [WARN] <0x0x55a85637aae0[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
May 16 10:56:21 sogod [5272]: [WARN] <0x0x55a85637aae0[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
2018-05-16 10:56:21.436 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'lukas';
2018-05-16 10:56:21.436 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
May 16 10:56:21 sogod [5272]: |SOGo| request took 0.019643 seconds to execute
May 16 10:56:21 sogod [5272]: 141.3.81.20 "POST /SOGo/connect HTTP/1.1" 200 50/77 0.021 - - 0
May 16 10:56:22 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas'
May 16 10:56:22 sogod [5272]: |SOGo| request took 0.000916 seconds to execute
May 16 10:56:22 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas HTTP/1.1" 302 0/0 0.002 - - 0
May 16 10:56:22 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas/view'
May 16 10:56:22 sogod [5272]: |SOGo| constructed root-url: /SOGo/
May 16 10:56:22 sogod [5272]: |SOGo| setting root-url in context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| request took 0.002378 seconds to execute
May 16 10:56:22 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas/view HTTP/1.1" 302 0/0 0.003 - - 612K
May 16 10:56:22 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas/Calendar'
2018-05-16 10:56:22.593 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'lukas' AND c_folder_type = 'Appointment';
2018-05-16 10:56:22.594 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:56:22.595 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_path FROM sogo_folder_info WHERE c_path1 = 'Users' AND c_path2 = 'lukas' AND c_path3 = 'Calendar' AND c_path4 = 'personal';
2018-05-16 10:56:22.595 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:22.595 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: BEGIN;
2018-05-16 10:56:22.595 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.595 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> 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/lukas/Calendar/personal', 'Users', 'lukas', 'Calendar', 'personal', 'Persönlicher Kalender', 'mysql://sogo:6AmUhnCr21EqSVA3tL11@127.0.0.1:3306/sogo/sogolukas0016712ae7e', 'mysql://sogo:6AmUhnCr21EqSVA3tL11@127.0.0.1:3306/sogo/sogolukas0016712ae7e_quick', 'mysql://sogo:6AmUhnCr21EqSVA3tL11@127.0.0.1:3306/sogo/sogolukas0016712ae7e_acl', 'Appointment');
2018-05-16 10:56:22.596 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.596 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: CREATE TABLE sogolukas0016712ae7e (
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-05-16 10:56:22.621 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.621 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: CREATE TABLE sogolukas0016712ae7e_quick (c_name VARCHAR(255) NOT NULL PRIMARY KEY, c_uid VARCHAR(255) NOT NULL, c_startdate INT NULL, c_enddate INT NULL, c_cycleenddate INT NULL, c_title VARCHAR(1000) NOT NULL, c_participants TEXT NULL, c_isallday INT NULL, c_iscycle INT NULL, c_cycleinfo TEXT NULL, c_classification INT NOT NULL, c_isopaque INT NOT NULL, c_status INT NOT NULL, c_priority INT NULL, c_location VARCHAR(255) NULL, c_orgmail VARCHAR(255) NULL, c_partmails TEXT NULL, c_partstates TEXT NULL, c_category VARCHAR(255) NULL, c_sequence INT NULL, c_component VARCHAR(10) NOT NULL, c_nextalarm INT NULL, c_description TEXT NULL);
2018-05-16 10:56:22.648 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.648 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: CREATE TABLE sogolukas0016712ae7e_acl (
c_uid VARCHAR (255) NOT NULL,
c_object VARCHAR (255) NOT NULL,
c_role VARCHAR (80) NOT NULL
);
2018-05-16 10:56:22.672 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.672 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: COMMIT;
2018-05-16 10:56:22.673 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.673 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_settings FROM sogo_user_profile WHERE c_uid = 'lukas';
2018-05-16 10:56:22.673 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:22.673 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: BEGIN;
2018-05-16 10:56:22.673 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.674 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar": {}}' WHERE c_uid = 'lukas';
2018-05-16 10:56:22.674 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.674 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: COMMIT;
2018-05-16 10:56:22.678 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
May 16 10:56:22 sogod [5272]: |SOGo| request took 0.086930 seconds to execute
May 16 10:56:22 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas/Calendar HTTP/1.1" 302 0/0 0.088 - - 0
May 16 10:56:22 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas/Calendar/view'
2018-05-16 10:56:22.721 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'lukas' AND c_folder_type = 'Appointment';
2018-05-16 10:56:22.722 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:22.735 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: BEGIN;
2018-05-16 10:56:22.735 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:22.735 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar": {"FoldersOrder": ["personal"]}}' WHERE c_uid = 'lukas';
2018-05-16 10:56:22.736 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:22.736 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: COMMIT;
2018-05-16 10:56:22.740 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:22.740 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_foldername FROM sogo_folder_info WHERE c_path = '/Users/lukas/Calendar/personal';
2018-05-16 10:56:22.741 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:22.742 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> 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 = 'lukas' AND c_path3 = 'Calendar' AND c_path4 = 'personal';
2018-05-16 10:56:22.742 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:56:22.743 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_component, c_status FROM sogolukas0016712ae7e_quick WHERE ((c_component = 'vtodo') AND (c_status != 1) AND (c_status != 3));
2018-05-16 10:56:22.744 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
May 16 10:56:22 sogod [5272]: |SOGo| constructed root-url: /SOGo/
May 16 10:56:22 sogod [5272]: |SOGo| setting root-url in context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: <0x55a85626eac0[SOGoAppointmentFolders]:Calendar> baseURL: name=Calendar (container=SOGoUserFolder)
container: /SOGo/so/lukas/
own: /SOGo/so/lukas/Calendar
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: <0x55a85626eac0[SOGoAppointmentFolders]:Calendar> baseURL: name=Calendar (container=SOGoUserFolder)
container: /SOGo/so/lukas/
own: /SOGo/so/lukas/Calendar
May 16 10:56:22 sogod [5272]: <0x55a85621d9a0[SOGoAppointmentFolder]:personal> baseURL: name=personal (container=SOGoAppointmentFolders)
container: /SOGo/so/lukas/Calendar/
own: /SOGo/so/lukas/Calendar/personal
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: <0x55a85626eac0[SOGoAppointmentFolders]:Calendar> baseURL: name=Calendar (container=SOGoUserFolder)
container: /SOGo/so/lukas/
own: /SOGo/so/lukas/Calendar
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
2018-05-16 10:56:22.756 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT * FROM sogo_view WHERE (c_uid = 'lukas') OR (mail = 'lukas');
2018-05-16 10:56:22.756 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| using root-url from context: /SOGo/so/
May 16 10:56:22 sogod [5272]: |SOGo| ROOT baseURL(no container, name=(null)):
own: /SOGo/so/
2018-05-16 10:56:22.773 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: BEGIN;
2018-05-16 10:56:22.774 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.774 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: UPDATE sogo_user_profile SET c_defaults = '{"SOGoMailLabelsColors": {"$label5": ["Später", "#993399"], "$label2": ["Geschäftlich", "#FF9900"], "$label4": ["To-Do", "#3333FF"], "$label1": ["Wichtig", "#FF0000"], "$label3": ["Persönlich", "#009900"]}, "SOGoMailAutoSave": "5", "SOGoTimeFormat": "%H:%M", "SOGoMailAddOutgoingAddresses": 0, "SOGoCalendarCategories": ["Fragen", "Feiertag", "Geburtstag", "Klienten", "Jubiläum", "Kunde", "Besprechung", "Anrufe", "Verschiedenes", "Urlaub", "Persönlich", "Status", "Geschenke", "Ferien", "Konkurrenz", "Favoriten", "Ideen", "Lieferanten", "Reise", "Fortsetzung", "Geschäft", "Projekte"], "SOGoCalendarDefaultReminder": "NONE", "SOGoCalendarCategoriesColors": {"Lieferanten": "#CCCCCC", "Geschäft": "#CCCCCC", "Ideen": "#CCCCCC", "Persönlich": "#CCCCCC", "Ferien": "#CCCCCC", "Projekte": "#CCCCCC", "Geburtstag": "#CCCCCC", "Urlaub": "#CCCCCC", "Fragen": "#CCCCCC", "Jubiläum": "#CCCCCC", "Konkurrenz": "#CCCCCC", "Status": "#CCCCCC", "Feiertag": "#FFCC33", "Klienten": "#CCCCCC", "Fortsetzung": "#CCCCCC", "Anrufe": "#CCCCCC", "Verschiedenes": "#CCCCCC", "Reise": "#CCCCCC", "Besprechung": "#CCCCCC", "Geschenke": "#CCCCCC", "Kunde": "#CCCCCC", "Favoriten": "#CCCCCC"}, "SOGoLoginModule": "Calendar", "SOGoDayStartTime": "08:00", "SOGoCalendarWeekdays": ["SU", "MO", "TU", "WE", "TH", "FR", "SA"], "SOGoCalendarTasksDefaultClassification": "PRIVATE", "SOGoTimeZone": "Europe\/Berlin", "SOGoRefreshViewCheck": "every_5_minutes", "SOGoLanguage": "German", "SOGoAnimationMode": "normal", "SOGoMailSignaturePlacement": "above", "SOGoSelectedAddressBook": "collected", "SOGoShortDateFormat": "%d.%m.%Y", "SOGoFirstWeekOfYear": "First4DayWeek", "SOGoDefaultCalendar": "personal", "SOGoFirstDayOfWeek": 1, "SOGoAlternateAvatar": "none", "SOGoCalendarEventsDefaultClassification": "PUBLIC", "SOGoMailComposeMessageType": "html", "SOGoGravatarEnabled": 0, "SOGoLongDateFormat": "%A, %e. %B %Y", "SOGoMailDisplayRemoteInlineImages": "never", "SOGoMailComposeFontSize": "0", "SOGoMailMessageForwarding": "inline", "SOGoDayEndTime": "17:00", "SOGoMailReplyPlacement": "above"}' WHERE c_uid = 'lukas';
2018-05-16 10:56:22.774 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:22.774 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: COMMIT;
2018-05-16 10:56:22.778 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
May 16 10:56:22 sogod [5272]: |SOGo| request took 0.061533 seconds to execute
May 16 10:56:22 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas/Calendar/view HTTP/1.1" 200 77887/0 0.068 - - 3M
May 16 10:56:23 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas/Calendar/alarmslist?browserTime=1526460983'
2018-05-16 10:56:23.203 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'lukas' AND c_folder_type = 'Appointment';
2018-05-16 10:56:23.203 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:56:23.205 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_name, c_nextalarm, c_iscycle FROM sogolukas0016712ae7e_quick WHERE (((c_nextalarm <= 1526633783) AND (c_nextalarm >= 1526460983)) OR ((c_nextalarm > 0) AND (c_nextalarm <= 1526460983) AND (c_enddate > 1526460983)));
2018-05-16 10:56:23.205 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
May 16 10:56:23 sogod [5272]: |SOGo| request took 0.003091 seconds to execute
May 16 10:56:23 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas/Calendar/alarmslist?browserTime=1526460983 HTTP/1.1" 200 63/0 0.004 - - 0
May 16 10:56:23 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas/Calendar/eventsblocks?ed=20180520&sd=20180514&view=weekview'
2018-05-16 10:56:23.265 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'lukas' AND c_folder_type = 'Appointment';
2018-05-16 10:56:23.266 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:56:23.266 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogolukas0016712ae7e_quick a, sogolukas0016712ae7e b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1526853599)) AND ((c_enddate IS NULL) OR (c_enddate >= 1526248800)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL);
2018-05-16 10:56:23.267 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:23.267 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogolukas0016712ae7e_quick a, sogolukas0016712ae7e b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1526853599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1526248800)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL);
2018-05-16 10:56:23.268 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
May 16 10:56:23 sogod [5272]: |SOGo| request took 0.004280 seconds to execute
May 16 10:56:23 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas/Calendar/eventsblocks?ed=20180520&sd=20180514&view=weekview HTTP/1.1" 200 744/0 0.005 - - 0
May 16 10:56:23 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas/Calendar/weekview?day=20180516'
2018-05-16 10:56:23.313 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'lukas' AND c_folder_type = 'Appointment';
2018-05-16 10:56:23.314 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:23.316 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: BEGIN;
2018-05-16 10:56:23.316 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:23.316 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar": {"FoldersOrder": ["personal"], "View": "weekview"}}' WHERE c_uid = 'lukas';
2018-05-16 10:56:23.319 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:23.319 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: COMMIT;
2018-05-16 10:56:23.322 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
May 16 10:56:23 sogod [5272]: |SOGo| request took 0.019470 seconds to execute
May 16 10:56:23 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas/Calendar/weekview?day=20180516 HTTP/1.1" 200 74856/0 0.021 - - 92K
May 16 10:56:23 sogod [5272]: |SOGo| starting method 'GET' on uri '/SOGo/so/lukas/Calendar/eventslist?asc=1&day=20180516&filterpopup=view_next7&search=title_Category_Location&sort=start&value='
2018-05-16 10:56:23.613 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'lukas' AND c_folder_type = 'Appointment';
2018-05-16 10:56:23.613 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
2018-05-16 10:56:23.614 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: BEGIN;
2018-05-16 10:56:23.614 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:23.614 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar": {"FoldersOrder": ["personal"], "EventsFilterState": "view_next7", "View": "weekview"}}' WHERE c_uid = 'lukas';
2018-05-16 10:56:23.614 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:23.615 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: COMMIT;
May 16 10:56:23 sogod [5273]: |SOGo| starting method 'POST' on uri '/SOGo/so/lukas/Calendar/saveSelectedList'
May 16 10:56:23 sogod [5273]: <0x0x55a855c67c90[SOGoCache]> Cache cleanup interval set every 300.000000 seconds
May 16 10:56:23 sogod [5273]: <0x0x55a855c67c90[SOGoCache]> Using host(s) '127.0.0.1' as server(s)
2018-05-16 10:56:23.618 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
May 16 10:56:23 sogod [5273]: [WARN] <0x0x55a856228440[SOGoWebDAVAclManager]> entry '{DAV:}write' already exists in DAV permissions table
May 16 10:56:23 sogod [5273]: [WARN] <0x0x55a856228440[SOGoWebDAVAclManager]> entry '{DAV:}write-properties' already exists in DAV permissions table
May 16 10:56:23 sogod [5273]: [WARN] <0x0x55a856228440[SOGoWebDAVAclManager]> entry '{DAV:}write-content' already exists in DAV permissions table
2018-05-16 10:56:23.619 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: BEGIN;
2018-05-16 10:56:23.619 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:23.619 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar": {"FoldersOrder": ["personal"], "EventsFilterState": "view_next7", "EventsSortingState": ["start", "1"], "View": "weekview"}}' WHERE c_uid = 'lukas';
2018-05-16 10:56:23.619 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT c_path4 FROM sogo_folder_info WHERE c_path2 = 'lukas' AND c_folder_type = 'Appointment';
2018-05-16 10:56:23.619 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:56:23.619 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:23.619 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: COMMIT;
2018-05-16 10:56:23.624 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has no results.
2018-05-16 10:56:23.625 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogolukas0016712ae7e_quick a, sogolukas0016712ae7e b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1527026399)) AND ((c_enddate IS NULL) OR (c_enddate >= 1526460983)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL);
2018-05-16 10:56:23.625 sogod[5272] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has results, entering fetch-mode.
2018-05-16 10:56:23.625 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> SQL: SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogolukas0016712ae7e_quick a, sogolukas0016712ae7e b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1527026399)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1526460983)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL);
2018-05-16 10:56:23.625 sogod[5272] <MySQL4Channel[0x0x55a8561f8500] connection=0x0x55a8563bf010> query has results, entering fetch-mode.
May 16 10:56:23 sogod [5272]: |SOGo| request took 0.014083 seconds to execute
May 16 10:56:23 sogod [5272]: 141.3.81.20 "GET /SOGo/so/lukas/Calendar/eventslist?asc=1&day=20180516&filterpopup=view_next7&search=title_Category_Location&sort=start&value= HTTP/1.1" 200 452/0 0.015 - - 0
May 16 10:56:23 sogod [5273]: [WARN] <0x0x7f0a9e2b1cc0[WOxElemBuilder]> could not locate builders: WOxExtElemBuilder,WOxExtElemBuilder
2018-05-16 10:56:23.637 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: BEGIN;
2018-05-16 10:56:23.637 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:23.637 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: UPDATE sogo_user_profile SET c_settings = '{"Calendar": {"SelectedList": "eventsListView", "FoldersOrder": ["personal"], "EventsFilterState": "view_next7", "View": "weekview"}}' WHERE c_uid = 'lukas';
2018-05-16 10:56:23.638 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
2018-05-16 10:56:23.638 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> SQL: COMMIT;
2018-05-16 10:56:23.642 sogod[5273] <MySQL4Channel[0x0x55a855cbcbd0] connection=0x0x55a855f3d490> query has no results.
May 16 10:56:23 sogod [5273]: |SOGo| request took 0.026347 seconds to execute

Lukas

Lukas

2018-05-16 09:07

reporter   ~0012883

As you see, just calendar categories gets updated:

SQL: UPDATE sogo_user_profile SET c_defaults = '{..., "SOGoCalendarCategories": ["Fragen", ...], ...}'

Issue History

Date Modified Username Field Change
2018-05-15 15:58 Lukas New Issue
2018-05-16 07:20 Christian Mack Note Added: 0012880
2018-05-16 08:45 Lukas Note Added: 0012881
2018-05-16 09:02 Lukas Note Added: 0012882
2018-05-16 09:07 Lukas Note Added: 0012883
2018-05-16 09:10 Lukas Note Edited: 0012882