View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0025002 | mantisbt | custom fields | public | 2018-11-22 05:59 | 2023-04-12 13:25 |
Reporter | rschmidt_333 | Assigned To | atrol | ||
Priority | normal | Severity | major | Reproducibility | always |
Status | closed | Resolution | fixed | ||
Product Version | 2.17.1 | ||||
Target Version | 2.19.0 | Fixed in Version | 2.19.0 | ||
Summary | 0025002: Error when updating content in a custom field of type "Text Area" ("Textbereich"): History cannot be stored | ||||
Description | While updating the text within a custom field of type "Text Area", we get the error Message: Column 'old_value' in table mantis_bug_history_table is 'varchar 255', but should be 'longtext'? Same for column 'new_value'? | ||||
Steps To Reproduce | Write a long text (more then 255 characters) into a custom field of type Text Area. Store the entry. Then edit that entry, do some change to the text. Store that entry. The error does not occure when using only short text. | ||||
Tags | No tags attached. | ||||
related to | 0024056 | closed | atrol | Custom Fields of type "Textarea" cannot contain more than 255 chars due to bug_history table |
related to | 0032365 | closed | dregad | APPLICATION ERROR 401 when writing Custom Fields with more than 255 characters |
related to | 0032385 | closed | dregad | Incorrect use of mb_strimwidth() to truncate old/new values in history API |
This should be fixed since version 2.13.0 see 0024056. |
|
Forget my previous note, I think I understand now what happened. I was not able to reproduce because MySQL on my test system was running in some kind of auto truncate mode. |
|
MantisBT: master 4609e811 2018-11-22 11:16 Details Diff |
Truncate values before writing to database history table TEXTAREA custom fields can contain more than 255 characters. Changing such fields fails, as the old value can't be stored in history table. This change fixes the issue by truncating the string. Fixes 0025002 |
Affected Issues 0025002 |
|
mod - core/history_api.php | Diff File |