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

Macan2 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 Tananaev2 years ago

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

Macan2 years ago

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

Thank you Anton

Macan2 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.