SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'value' at row 1

Archived Paul E. ● ago

We are getting this error by changing notifications for categories in the profilesettings after adding a new category.

Best Answer

Guest ●

Hello, Paul.

We have identified the issue. Table row ur_user_configs.value lenght is too short for serialized data, therefore data type should be changed to text instead of varchar(255).

Please execute the following SQL:

ALTER TABLE `ur_user_configs` CHANGE `value` `value` TEXT CHARSET utf8 COLLATE utf8_general_ci NOT NULL;

Note: change the table prefix ur_ to proper if it differs from the default.

This fix will be also available in 2.3.11 within two hours.

Replies (1)

Guest ● ●

Hello, Paul.

We have identified the issue. Table row ur_user_configs.value lenght is too short for serialized data, therefore data type should be changed to text instead of varchar(255).

Please execute the following SQL:

ALTER TABLE `ur_user_configs` CHANGE `value` `value` TEXT CHARSET utf8 COLLATE utf8_general_ci NOT NULL;

Note: change the table prefix ur_ to proper if it differs from the default.

This fix will be also available in 2.3.11 within two hours.