110 views

 

Symptoms


Error:  General Data Exception detected by database (Data too long for column 'user_id' at row 1)

Environment


This is for on-premise instances only.

Cause


This issue can occur after upgrading or cloning over an instance.

Resolution


Using your terminal, go to the file: 
/usr/local/mysql_current/my.cnf 

There is a line: 
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLE 

The STRICT_TRANS_TABLE should be removed: 
sql_mode=NO_ENGINE_SUBSTITUTION 

This allows for the truncation of data too large for field rather than an error to be thrown.

 

Article Information

Last Updated:2018-05-22 15:45:02
Published:2018-05-22