Data truncation: Out of range value for column 'positionid' at row 1

Macan 3 years ago

Hello,

I have this warn in the logs :

  WARN: Failed to update device -
com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column 'positionid' at row 1

but I changed the value of column "positionid" in the table tc_events from INT to BIGINT (also in the table tc_positions, I changed column "id" from INT to BIGINT) in the mysql but the warn is still there and can not store position, anyone can help?

Anton Tananaev 3 years ago

The error is about tc_devices table. Have you updated it as well?

Macan 3 years ago

ah , I didnt updated tc_devices table, I will try it now. and let you know.

Thank you Anton

Macan 3 years ago

thank you Anton, you are the man!

I changed ti BIGINT In the tc_devices column positionid and now it is fine, the warn is gone.