Issue Bug Closed

#110178EXT:form Wrong order of single select items after saving

Jens Pausewang 07/09/26, 08:46 updated 08/11/26, 08:51

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