I keep seeing this error in the log:
Could not store item 'aeotec_front_closet_sensor' in database with statement 'INSERT INTO Item512 (TIME, VALUE) VALUES(?,?) ON DUPLICATE KEY UPDATE VALUE=?;': Data truncation: Data too long for column 'Value' at row 1
I have two other Aeotec door sensors and neither of them show this error. None of these devices has an entry in may persistence file (mysql.persist).
I’ve read a post here that suggests it may be data format issue:
So what gives?