Trouble with Aeotec sensor and persistence

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:
https://community.openhab.org/t/mysql-could-not-store-item/3485
So what gives?

They don’t have to be, if they are members of Groups that get persisted.

Thanks for the reply, but none of these sensors are in a group.

So, you don’t want to persist this Item at all? The persistence services are essentially OH1 legacy; they will not pick up in-flight changes. If you have been editing xxx.persist files or Group memberships that are persisted, you will have to restart to effect the changes.

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.