Review 14.3 Merged

94606[BUGFIX] Fix initial EXT:introduction database import on sqlite

Benjamin Franzke CR +2 V +2 Easy +26 −1 updated 06/27/26, 17:50

Commit message

The EXT:introduction distribution failed to import on sqlite,
because the database could not be updated properly, causing
SQL errors due to missing fields and later PHP errors (which
will be handled separately, see #110060) due to missing parent-rows
during the impexp execution.

This happened because the installation of EXT:bootstrap_package will
cause one existing column to be changed and new ones to be added.

When database columns are being changed and added,
the doctrine sqlite platform will create a temporary database
schema (based on the current schema) for the changed
columns, since `ALTER TABLE` does only allow to add new
columns.

Now, if there are columns to be added and columns to be changed,
the `ALTER TABLE … ADD COLUMN` statement was executed first,
while the sqlite table recreation pattern (based on the old scheme)
was applied afterwards, effectively reverting the aformentioned
`ADD COLUMN` instructions.

To overcome this issue, the ordering is adapted to ensure that
`ADD` instructions are executed last. This is now covered by a
functional test.

Note: The change of the existing column (tsconfig_includes) when
installing EXT:bootstrap_package as dependency of EXT:introduction
is actually not intended, but happened because
`ExtensionManagementUtility::registerPageTSConfigFile()`
causes the autogenerated database schema to be changed. This is
the trigger that revealed this error, and will be handled
separately in #110091.

Review

  • Code review CR +2 Done
    • Benjamin Franzke +2
  • Verified V +2 Done
    • Benjamin Franzke +2
    • core-ci +1 CI

Issues 3

Files 3

Review log 34

  1. Benjamin Franzke commented on patch set 1 06/27/26, 10:45

    Cherry Picked from branch main.
  2. Benjamin Franzke voted on patch set 1 CR +2 V +2 06/27/26, 10:46

  3. core-ci voted on patch set 1 V +1 06/27/26, 10:53 Core CI is happy: https://git.typo3.org/typo3/CI/cms/-/pipelines/103976

  4. Garvin Hicking merged patch set 2 06/27/26, 17:50