Page 1 of 1

SQL error 1406 when updating issue

Posted: 29 Mar 2018, 14:17
by ErikA
Since the introduction of multiline text fields, we were getting errors when updating an issue that has such a field. This is caused by the fact that Mantis stores its history in mantis_bug_history_table, and the fields old_value and new_value are limited to 255 characters.
'Data too long for column 'new_value' at row 1'

The workaround for now is that I substr the values in history_api.php

Re: SQL error 1406 when updating issue

Posted: 29 Mar 2018, 14:43
by atrol
I fixed this some days ago.
The fix will be part of next version 2.13.0 https://mantisbt.org/bugs/view.php?id=24056

Re: SQL error 1406 when updating issue

Posted: 30 Mar 2018, 11:17
by ErikA
I see, thanks.