#106727sys_file_reference crop column not large enough
Description
In a TYPO3 installation with 10 crop variants I get sometimes the issue, that the length of generated JSON exceeds 4000 chars.
This can quickly happen, with such contents:
"cropArea":{"x":0.0008649521393150031052521331531579562579281628131866455078125,"y":0,"width":0.99827009572137004322911479903268627822399139404296875,"height":0.81109445277361313930697406249237246811389923095703125},"selectedRatio":"120:65","focusArea":{"x":0.333333333333333314829616256247390992939472198486328125,"y":0.33333333,
However, because of the limit the JSON is getting cut and becomes invalid.
In TYPO3 backend this error occures and previously added croppings are gone:
clipboard-202505191337-ipthb.png
In EXT:core’s ext_tables.sql the crop column has this definition:
crop varchar(4000) DEFAULT '' NOT NULL,
To fix the issue in my project I’ve updated the column definition to:
crop text DEFAULT '',
Maybe it is a good idea, to increase the limit generally.
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.
Files 1
History 2
-
Armin Vieweg commented 05/19/25, 11:41
-
Chris Müller commented and changed status
NewClosed 05/19/25, 15:25As v13 already has a longtext for the crop field, I close this issue.
Oh, I’ve seen in TYPO3 v13 this field has been changed to longtext.
So I’m going to adapt this for my v12 installation.