Bug #56498
closed
TCA setting for input field allows one character too much.
0%
Description
If you use input (text) fields for plugins with db fields tinytext or varchar it is possible to insert 256 characters but both kind of db fields have only 255 characters and this will cause the error "102: These fields are not properly updated in database: (title) Probably value mismatch with fieldtype.".
So if you insert very long text to the input field it will be cut by the field setting (maxlength="256") and if you remove on char now (256 - 1 = 255) every thing works fine without error.
You can reproduce this error e.g. in EXT News title field or in normal cType header.
Tested versions 6.0.7 and 6.2-dev.
As a note: The title field of pages is correctly set to maxlength="255".
Updated by Felix Kopp over 9 years ago
- Status changed from New to Needs Feedback
Hi Erik,
do you have the limit in TCA also.
The underlying DB field is not evaluated at that stage but the limit is taken from TCA.
TCA input field definition should have a maxLength setting:
http://docs.typo3.org/typo3cms/TCAReference/Reference/Columns/Input/Index.html#max
Please post info if this solves your use case.
Updated by Alexander Opitz almost 9 years ago
- Status changed from Needs Feedback to Closed
No feedback within the last 90 days => closing this issue.
If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.