SQL error 1406 when updating issue

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
ErikA
Posts: 4
Joined: 22 Jul 2014, 14:09

SQL error 1406 when updating issue

Post 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
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: SQL error 1406 when updating issue

Post 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
Please use Search before posting and read the Manual
ErikA
Posts: 4
Joined: 22 Jul 2014, 14:09

Re: SQL error 1406 when updating issue

Post by ErikA »

I see, thanks.
Post Reply