Hi Forum
from time to time I’m getting the following error in my logfile. What’s wrong there and how can I resolve it?
2015-10-10 17:12:03.788 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Could not store item 'gDGZi1HueDimm' in database with statement 'INSERT INTO Item3 (TIME, VALUE) VALUES(NOW(),?) ON DUPLICATE KEY UPDATE VALUE=?;': Incorrect integer value: 'OFF' for column 'Value' at row 1
2015-10-10 17:12:03.792 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Error count exceeded 1. Disconnecting database.
2015-10-10 17:12:03.844 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Could not store item 'gDGZi1HueColTemp' in database with statement 'INSERT INTO Item15 (TIME, VALUE) VALUES(NOW(),?) ON DUPLICATE KEY UPDATE VALUE=?;': Incorrect integer value: 'OFF' for column 'Value' at row 1
2015-10-10 17:12:03.854 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Error count exceeded 1. Disconnecting database.
Thx & Regards
John