#110178EXT:form Wrong order of single select items after saving
Description
That issue existed before: https://forge.typo3.org/issues/85416
Steps to reproduce:
Create a blank form with a single select element and add the three options aaa“aaa”, bb“bb” and c“c”
Screenshot%202026-07-09%20at%2010.39.23.png
After saving the form, the options appear to be ordered but once you reload the page the order is:
c“c”, bb“bb”, aaa“aaa”
Screenshot%202026-07-09%20at%2010.39.42.png
This seems to be an issue with MySQL and the JSON data type.
When changing the column type to “longtext” and the TCA type to “text”, the options are ordered properly in the database:
CREATE TABLE form_definition (
configuration longtext DEFAULT NULL
)
$GLOBALS['TCA']['form_definition']['columns']['configuration']['config']['type'] = 'text';Reviews 2
Related issues 2
Files 2
History 48
-
Georg Ringer changed Related to #85416 <span data-processor="relativetime" data-value="2026-07-09T20:30:11+00:00" > 07/09/26, 20:30 </span>
-
Josua Vogel changed Related to #110239 <span data-processor="relativetime" data-value="2026-07-20T16:33:09+00:00" > 07/20/26, 16:33 </span>
-
Gerrit Code Review pushed patch set 2 for main to change 94847 status
NewUnder Review <span data-processor="relativetime" data-value="2026-07-20T16:33:37+00:00" > 07/20/26, 16:33 </span> -
Gerrit Code Review pushed patch set 3 for main to change 94847 <span data-processor="relativetime" data-value="2026-07-21T20:19:19+00:00" > 07/21/26, 20:19 </span>
-
Gerrit Code Review pushed patch set 4 for main to change 94847 <span data-processor="relativetime" data-value="2026-07-22T00:54:10+00:00" > 07/22/26, 00:54 </span>
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 94878 <span data-processor="relativetime" data-value="2026-07-22T08:50:17+00:00" > 07/22/26, 08:50 </span>
-
Oliver Bartsch commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-07-22T08:55:09+00:00" > 07/22/26, 08:55 </span> -
Benni Mack changed status
ResolvedClosed <span data-processor="relativetime" data-value="2026-08-11T08:51:04+00:00" > 08/11/26, 08:51 </span>
Applied in changeset commit:40aacd262f028b1906f0e9551d6f6b45971b82b3.