i’ve installed the iCloud Binding which really works like a charm. BUT: i persist all my data into a mysql database installed at the same system. All values for all items get persisted properly but not the “lastLocationUpdate” of the iCloud binding.
It seems that the corresponding mysql-table for those items does not get created. OpenHab2 tries to store new incoming values to the database but there is an error message showing up in the log:
2019-08-09 12:50:12.204 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!! java.sql.SQLException: Table 'OpenHAB.item0077' doesn't exist Query: INSERT INTO item0077 (TIME, VALUE) VALUES( NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? Parameters: [2019-08-09 12:47:39.383, 2019-08-09 12:47:39.383]
With some searching i could find another error message at the log where openHab seems to have a problem generating the items-table for this item:
2019-08-08 10:58:05.026 [ERROR] [org.knowm.yank.Yank ] - Error in SQL query!!! java.sql.SQLException: Invalid default value for 'value' Query: CREATE TABLE IF NOT EXISTS item0077 (time TIMESTAMP(3) NOT NULL, value TIMESTAMP(3), PRIMARY KEY(time)) Parameters: 
I can reproduce this for all items of this thing-channel.
Any idea where to look or why this might happen?