- OS: Ubuntu
- openHAB version: 3.0.2
- mysql Ver 14.14 Distrib 5.7.33, for Linux (x86_64) using EditLine wrapper
Item: DateTime Last_Motion_GWC "Gäste WC [%1$ta, %1$td.%1$tm. %1$tH:%1$tM]"
I recently installed OH 3.0.2. I added configuration elemnts from OH 2.5 piece by piece. In my openhab log I get this error message regulary if the item changes:
java.sql.SQLException: Table 'openhab3.item0200' doesn't exist Query: INSERT INTO item0200 (TIME, VALUE) VALUES( NOW(3), ? ) ON DUPLICATE KEY UPDATE VALUE= ? Parameters: [2021-06-08 13:00:04.367, 2021-06-08 13:00:04.367]
at org.apache.commons.dbutils.AbstractQueryRunner.rethrow(AbstractQueryRunner.java:392) ~[bundleFile:?]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:491) ~[bundleFile:?]
at org.apache.commons.dbutils.QueryRunner.update(QueryRunner.java:457) ~[bundleFile:?]
at org.knowm.yank.Yank.execute(Yank.java:194) [bundleFile:?]
at org.knowm.yank.Yank.execute(Yank.java:177) [bundleFile:?]
at org.openhab.persistence.jdbc.db.JdbcBaseDAO.doStoreItemValue(JdbcBaseDAO.java:329) [bundleFile:?]
at org.openhab.persistence.jdbc.internal.JdbcMapper.storeItemValue(JdbcMapper.java:156) [bundleFile:?]
at org.openhab.persistence.jdbc.internal.JdbcPersistenceService.store(JdbcPersistenceService.java:143) [bundleFile:?]
at org.openhab.core.persistence.internal.PersistenceManagerImpl.handleStateEvent(PersistenceManagerImpl.java:152) [bundleFile:?]
at org.openhab.core.persistence.internal.PersistenceManagerImpl.stateChanged(PersistenceManagerImpl.java:473) [bundleFile:?]
at org.openhab.core.items.GenericItem.lambda$1(GenericItem.java:259) [bundleFile:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
I checked the items table, item0200 is listed as Last_Motion_GWC, yet the table item0200 does not exist. This happens for all my items of that type. I did not configure anything then login data for the JDBC mySQL binding. So all items are getting persisted.
Why has the table not been created? What can I do to get rid of these error messages?