Data truncation traccar modern v5.5

smsoousa 3 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 Tananaev 3 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.

smsoousa 3 years ago

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