#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';