Issue Task Resolved

#110722Remove duplicate column from EXT:form storage fixtures

Stefan Bürk 09/16/26, 13:10 updated 09/16/26, 14:00

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

  1. Stefan Bürk commented and changed status Under Review Resolved done 0 % 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.