Issue Bug New Stale

#110091Database schema is changed once an extension regfisters a page tsconfig file via ExtensionManagementUtility::registerPageTSConfigFile()

Benjamin Franzke 06/24/26, 07:21 updated 06/24/26, 19:53

Description

The database schema for tsconfig_includes changes from StringType (e.g. varchar(255)) to TextType, when at least one
item has been added to the select list via ExtensionManagementUtility::registerPageTSConfigFile().

That means the installations of extension like bootstrap_package that configure select items as in https://github.com/benjaminkott/bootstrap_package/blob/15.0.4/Configuration/TCA/Overrides/100_pages.php#L15 trigger a column change.

This is unfortunate, especially in sqlite environments, as it requires the entire table to be recreated via the sqlite table recreation pattern: https://github.com/doctrine/dbal/blob/73653de42d9836e4a00350afc697c5e7e31706f2/src/Platforms/SQLitePlatform.php#L693-L709

Ideally we should try to enforce a stable schema for core fields, where we know upfront, that the column type shall be TEXT.

See screenshot:

.clipboard-202606240920-z0rmg.png

For sake of completeness, this is the full SQL that is presented to the integrator:

CREATE TEMPORARY TABLE __temp__pages AS SELECT uid, pid, tstamp, crdate, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, l10n_diffsource, t3ver_oid, t3ver_wsid, t3ver_state, t3ver_stage, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, SYS_LASTCHANGED, shortcut, content_from_pid, mount_pid, tx_impexp_origuid, sitemap_priority, doktype, title, slug, TSconfig, php_tree_stop, categories, layout, extendToSubpages, nav_title, nav_hide, subtitle, target, url, lastUpdated, newUntil, cache_timeout, cache_tags, no_search, shortcut_mode, keywords, description, abstract, author, author_email, media, is_siteroot, mount_pid_ol, module, l18n_cfg, backend_layout, backend_layout_next_level, tsconfig_includes, seo_title, no_index, no_follow, sitemap_changefreq, canonical_link, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, twitter_card FROM "pages"
Current value: "tsconfig_includes" VARCHAR(255) DEFAULT ''

DROP TABLE "pages"
Current value: "tsconfig_includes" VARCHAR(255) DEFAULT ''

CREATE TABLE "pages" (uid INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tstamp INTEGER UNSIGNED DEFAULT 0 NOT NULL, crdate INTEGER UNSIGNED DEFAULT 0 NOT NULL, deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL, hidden SMALLINT UNSIGNED DEFAULT 0 NOT NULL, starttime INTEGER UNSIGNED DEFAULT 0 NOT NULL, endtime INTEGER UNSIGNED DEFAULT 0 NOT NULL, fe_group VARCHAR(255) DEFAULT '0' NOT NULL, sorting INTEGER DEFAULT 0 NOT NULL, rowDescription CLOB DEFAULT NULL, editlock SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sys_language_uid INTEGER DEFAULT 0 NOT NULL, l10n_parent INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_source INTEGER UNSIGNED DEFAULT 0 NOT NULL, l10n_state CLOB DEFAULT NULL, l10n_diffsource BLOB DEFAULT NULL, t3ver_oid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_wsid INTEGER UNSIGNED DEFAULT 0 NOT NULL, t3ver_state SMALLINT DEFAULT 0 NOT NULL, t3ver_stage INTEGER DEFAULT 0 NOT NULL, perms_userid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_groupid INTEGER UNSIGNED DEFAULT 0 NOT NULL, perms_user SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_group SMALLINT UNSIGNED DEFAULT 0 NOT NULL, perms_everybody SMALLINT UNSIGNED DEFAULT 0 NOT NULL, SYS_LASTCHANGED INTEGER UNSIGNED DEFAULT 0 NOT NULL, shortcut INTEGER UNSIGNED DEFAULT 0 NOT NULL, content_from_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, mount_pid INTEGER UNSIGNED DEFAULT 0 NOT NULL, tx_impexp_origuid INTEGER DEFAULT 0 NOT NULL, sitemap_priority NUMERIC(2, 1) DEFAULT '0.5' NOT NULL, doktype INTEGER UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, slug CLOB DEFAULT NULL, TSconfig CLOB DEFAULT NULL, php_tree_stop SMALLINT UNSIGNED DEFAULT 0 NOT NULL, categories INTEGER UNSIGNED DEFAULT 0 NOT NULL, layout INTEGER UNSIGNED DEFAULT 0 NOT NULL, extendToSubpages SMALLINT UNSIGNED DEFAULT 0 NOT NULL, nav_title VARCHAR(255) DEFAULT '' NOT NULL, nav_hide SMALLINT UNSIGNED DEFAULT 0 NOT NULL, subtitle VARCHAR(255) DEFAULT '' NOT NULL, target VARCHAR(80) DEFAULT '' NOT NULL, url VARCHAR(255) DEFAULT '' NOT NULL, lastUpdated BIGINT DEFAULT 0 NOT NULL, newUntil BIGINT DEFAULT 0 NOT NULL, cache_timeout INTEGER UNSIGNED DEFAULT 0 NOT NULL, cache_tags VARCHAR(255) DEFAULT '' NOT NULL, no_search SMALLINT UNSIGNED DEFAULT 0 NOT NULL, shortcut_mode INTEGER UNSIGNED DEFAULT 0 NOT NULL, keywords CLOB DEFAULT NULL, description CLOB DEFAULT NULL, abstract CLOB DEFAULT NULL, author VARCHAR(255) DEFAULT '' NOT NULL, author_email VARCHAR(255) DEFAULT '' NOT NULL, media INTEGER UNSIGNED DEFAULT 0 NOT NULL, is_siteroot SMALLINT UNSIGNED DEFAULT 0 NOT NULL, mount_pid_ol SMALLINT DEFAULT 0 NOT NULL, module VARCHAR(255) DEFAULT '' NOT NULL, l18n_cfg SMALLINT UNSIGNED DEFAULT 0 NOT NULL, backend_layout VARCHAR(64) DEFAULT '' NOT NULL, backend_layout_next_level VARCHAR(64) DEFAULT '' NOT NULL, "tsconfig_includes" CLOB DEFAULT NULL, seo_title VARCHAR(255) DEFAULT '' NOT NULL, no_index SMALLINT UNSIGNED DEFAULT 0 NOT NULL, no_follow SMALLINT UNSIGNED DEFAULT 0 NOT NULL, sitemap_changefreq VARCHAR(10) DEFAULT '' NOT NULL, canonical_link CLOB DEFAULT '' NOT NULL, og_title VARCHAR(255) DEFAULT '' NOT NULL, og_description CLOB DEFAULT NULL, og_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_title VARCHAR(255) DEFAULT '' NOT NULL, twitter_description CLOB DEFAULT NULL, twitter_image INTEGER UNSIGNED DEFAULT 0 NOT NULL, twitter_card VARCHAR(255) DEFAULT '' NOT NULL)
Current value: "tsconfig_includes" VARCHAR(255) DEFAULT ''

INSERT INTO "pages" (uid, pid, tstamp, crdate, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, l10n_diffsource, t3ver_oid, t3ver_wsid, t3ver_state, t3ver_stage, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, SYS_LASTCHANGED, shortcut, content_from_pid, mount_pid, tx_impexp_origuid, sitemap_priority, doktype, title, slug, TSconfig, php_tree_stop, categories, layout, extendToSubpages, nav_title, nav_hide, subtitle, target, url, lastUpdated, newUntil, cache_timeout, cache_tags, no_search, shortcut_mode, keywords, description, abstract, author, author_email, media, is_siteroot, mount_pid_ol, module, l18n_cfg, backend_layout, backend_layout_next_level, "tsconfig_includes", seo_title, no_index, no_follow, sitemap_changefreq, canonical_link, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, twitter_card) SELECT uid, pid, tstamp, crdate, deleted, hidden, starttime, endtime, fe_group, sorting, rowDescription, editlock, sys_language_uid, l10n_parent, l10n_source, l10n_state, l10n_diffsource, t3ver_oid, t3ver_wsid, t3ver_state, t3ver_stage, perms_userid, perms_groupid, perms_user, perms_group, perms_everybody, SYS_LASTCHANGED, shortcut, content_from_pid, mount_pid, tx_impexp_origuid, sitemap_priority, doktype, title, slug, TSconfig, php_tree_stop, categories, layout, extendToSubpages, nav_title, nav_hide, subtitle, target, url, lastUpdated, newUntil, cache_timeout, cache_tags, no_search, shortcut_mode, keywords, description, abstract, author, author_email, media, is_siteroot, mount_pid_ol, module, l18n_cfg, backend_layout, backend_layout_next_level, tsconfig_includes, seo_title, no_index, no_follow, sitemap_changefreq, canonical_link, og_title, og_description, og_image, twitter_title, twitter_description, twitter_image, twitter_card FROM __temp__pages
Current value: "tsconfig_includes" VARCHAR(255) DEFAULT ''

Reviews 3

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch

Commit message
[BUGFIX] Database schema is changed once an extension regfisters a page tsconfig file via ExtensionManagementUtility::registerPageTSConfigFile() Resolves: #110091 Releases: main

Files 1

History 3

  1. Garvin Hicking commented <span data-processor="relativetime" data-value="2026-06-24T19:53:01+00:00" > 06/24/26, 19:53 </span>

    What would speak against using ext_tables.sql for it then?

    Otherwise, respecting a TCA “dbType” option that we set in the core for that column might help. But since I believe phasing out ext_tables will cause headaches I feel that would be the way of least resistance.