Actual Snapshot openhab2 build 1674, but never worked since installed openhab2
I got Network-Bindung and check some Devices on LAN if available.
There is a DateTime-Item named id_ITEM_lastseen with jdbc-Rules to save onchange.
Every Change of value from lastseen (Example: 2019-09-15 22:45:04.657) shows an error in openhab2.log:
2019-09-15 22:45:11.698 [ERROR] [org.knowm.yank.Yank] - Error in SQL query!!!
java.sql.SQLException: Table’openhab2.id_ITEM_lastseen_0024’ doesn’t exist Query: INSERT INTO id_ITEM_lastseen_0024 (TIME, VALUE) VALUES (NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? Parameters: [2019-09-15 22:45:04.657, 2019-09-15 22:45:04.657]
Can anybody explain or reproduce?
All other Items openhab2 created Table and they are working. But DateTime Items don’t Work.
Update: In openhab2.items there is an Entry for that item. But the table for the data isn’t created and no values are stored