Issue with Adding Attributes - "Data too long for column 'attributes'" Error

Urdanegui Castillo 5 months ago

Hi everyone,

I am encountering an issue when trying to add attributes related to our Privacy Policy and Terms of Service in Traccar. When I attempt to save these attributes, I receive the following error message:

Data truncation: Data too long for column 'attributes' at row 1 - MysqlDataTruncation
(... < QueryBuilder:469 < DatabaseStorage:115 < ServerResource:109 < ...)

From what I understand, this error indicates that the data I am trying to store in the 'attributes' column exceeds the allowed size for this column in the MySQL database.

Here are the steps I followed:

  1. Accessed the Traccar web interface.
  2. Navigated to the section where attributes can be added.
  3. Attempted to input the text for our Privacy Policy and Terms of Service.
  4. Tried to save the changes, and the error appeared.

My current column definition for 'attributes' seems to be too small to handle the amount of data I'm trying to input.

Before making any direct changes to the database schema, I wanted to ask for advice on the best and safest approach to resolve this issue. Specifically:

  1. What is the recommended way to increase the column size for 'attributes' to accommodate larger text data?
  2. Are there any potential side effects or considerations I should be aware of when making this change?
  3. Is there an alternative method to store larger text data within Traccar that you would suggest?

Thank you for your assistance. I have attached a screenshot of the error message for reference.

Best regards,

1000057571.png

Anton Tananaev5 months ago

It should be fine to modify the column size.