How to fix MySQL data too long error?

Question

MySQL

Hello. how to fix error MYSQL: MySQL RealTime: Failed to update database: Data too long for column?
On the previous version of Asterisk (1.8) everything worked, but here it does not accept after moving to a new server

Thanks in advance

Answer 1

See in which table and which column gives an error and increase its length or change its type to TEXT.

Answer 2

Most likely this is some user who has a long User Agent or Contact. Developers like to insert any garbage there. Try increasing the fullcontact and useragent fields.
My default is like this:

`fullcontact` varchar(35) DEFAULT NULL,

`useragent` varchar(20) DEFAULT NULL,

Put Varchar (100) on both, enough for all cases.