Data truncation traccar modern v5.5

smsoousa2 years ago

Hello everybody! I upgraded from version 4.10 to 5.5. So far everything is working normally, however, when I try to save something in Settings >> Preferences, such as Devices (Device Title or Device Details), I get this error:

Data truncation: Data too long for column 'attributes' in row 1 - MysqlDataTruncation(... < QueryBuilder:469 < DatabaseStorage:115 < BaseObjectResource:98 < ...)

I already searched the database for this table and did not find it. If you can help me, I'll be grateful.

Anton Tananaev2 years ago

It means that you already have too much data in the user attributes. Either check and remove unused stuff or increase the limit in the database.

smsoousa2 years ago

I changed the field to blob, and it worked. Thanks