mySQL: Incorrect integer value?

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

I’m not certain, but it could be that you changed your item definitions for gDGZi1HueDimm and gDGZi1HueColTemp at some point after states had already been persisted for those items, such that the items used to produce numeric states, but now produce switch states.

If you rename those items (in your items, sitemap and rules files), does that change or eliminate the log errors?