mySQL Error after changing dimmer item to a switch item

Add-ons Persistence Services
1

Hey All, I just replaced a dimmer switch in my garage with a standard ON/OFF switch, I thought I could just swap out the item binding information and all would be good, but now I’m getting this error:

2017-10-14 10:19:45.499 [ERROR] [sql.internal.MysqlPersistenceService] - mySQL: Could not store item ‘garageLights’ in database with statement ‘INSERT INTO Item27 (TIME, VALUE) VALUES(?,?) ON DUPLICATE KEY UPDATE VALUE=?;’: Incorrect integer value: ‘ON’ for column ‘Value’ at row 1

I am running OH2.1.0-1 on a RPI2(openhabian)

Anyone know how I can fix this?

2

You have to stop oh and remove the table in MySQL for that item. OH can’t change the type of the state column for the item in MySQL.