mySQL Error after changing dimmer item to a switch item

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?

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.