Issue Bug Closed

#106727sys_file_reference crop column not large enough

Armin Vieweg 05/19/25, 11:39 updated 05/19/25, 15:25

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

  1. Armin Vieweg commented 05/19/25, 11:41

    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.

  2. Chris Müller commented and changed status New Closed 05/19/25, 15:25

    As v13 already has a longtext for the crop field, I close this issue.