#110722Remove duplicate column from EXT:form storage fixtures
Description
Two CSV database fixtures of the form extension list the column
@configuration@ twice in the header row of the sys_file_storage table:
- typo3/sysext/form/Tests/Functional/Controller/Fixtures/DatabaseImports/sys_file_storage.csv
- typo3/sysext/form/Tests/Functional/Mvc/Persistence/Fixtures/DatabaseImports/sys_file_storage.csv
bc. ,uid,pid,name,driver,configuration,is_browsable,is_public,is_writable,is_online,configuration
The first configuration column is empty, the last one holds the storage
FlexForm. The typo3/testing-framework data set import currently inserts row by
row using the parsed element keys, where the duplicate column collapses and the
last value wins, so the mistake goes unnoticed.
Importing data sets with a single bulk insert per table (testing-framework
pull requests 744 and 752) renders the column twice into the INSERT statement,
which MySQL, MariaDB and PostgreSQL reject:
bc. SQLSTATE42000: Syntax error or access violation: 1110 Column ‘configuration’ specified twice
SQLSTATE42701: Duplicate column: 7 ERROR: column “configuration” specified more than once
The empty duplicate column is removed from both fixtures.
Only TYPO3 v14.3 is affected: the fixtures have been removed from main along
with the deprecated form file-based storage, and TYPO3 v13.4 never contained
them. No other CSV fixture on main, 14.3 or 13.4 lists a column twice.
Reviews 1
History 12
-
Gerrit Code Review pushed patch set 1 for 14.3 to change 95875 status
NewUnder Review <span data-processor="relativetime" data-value="2026-09-16T13:13:16+00:00" > 09/16/26, 13:13 </span> -
Stefan Bürk commented and changed status
Under ReviewResolved done0 %100 % <span data-processor="relativetime" data-value="2026-09-16T14:00:10+00:00" > 09/16/26, 14:00 </span>
Applied in changeset commit:15393642f35d4c1d46f8babd23502e164f7abfb3.