Nach Update von 4.13 auf 5.3 Fehler bei Datenbankaktualisierung - gelöst

Druckbare Version

24.06.2025, 07:24
MarkIII

Nach Update von 4.13 auf 5.3 Fehler bei Datenbankaktualisierung - gelöst

Folgende Änderungen können nicht angewendet werden:

Code:

Schema-Änderungen Tabelle tl_bs_grid löschen Tabelle tl_style löschen Tabelle tl_style_sheet löschen Feld tl_article.keywords löschen Feld tl_article.guests löschen Feld tl_article.showTeaser ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_article.protected ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_article.cssID ändernVARCHAR(255) DEFAULT '' NOT NULL Feld tl_article.published ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.closeSections hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.com_moderate hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.com_bbcode hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.com_disableCaptcha hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.com_requireLogin hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.mateTeaserBoxPlus hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.sectionHeadline hinzufügenVARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL Feld tl_content.unfilteredHtml hinzufügenMEDIUMTEXT DEFAULT NULL Feld tl_content.com_order hinzufügenVARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin` Feld tl_content.com_perPage hinzufügenSMALLINT UNSIGNED DEFAULT 0 NOT NULL Feld tl_content.com_template hinzufügenVARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin` Feld tl_content.subline hinzufügenTEXT DEFAULT NULL Feld tl_content.headline_inline hinzufügenCHAR(1) DEFAULT '' NOT NULL Feld tl_content.subheadline hinzufügenCHAR(1) DEFAULT '' NOT NULL Feld tl_content.ct_contentBox_page hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_contentBox_pageText hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_contentBox_pageTitle hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_featureIcon hinzufügenVARCHAR(64) DEFAULT '' NOT NULL Feld tl_content.ct_iconLink hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_featureElement_customTpl hinzufügenVARCHAR(64) DEFAULT '' NOT NULL Feld tl_content.ct_price hinzufügenVARCHAR(20) DEFAULT '' NOT NULL Feld tl_content.ct_priceLabel hinzufügenVARCHAR(50) DEFAULT '' NOT NULL Feld tl_content.ct_priceBox_link1 hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_priceBox_linkText1 hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_priceBox_link2 hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_priceBox_linkText2 hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_popularPriceBox hinzufügenVARCHAR(50) DEFAULT '' NOT NULL Feld tl_content.ct_priceBox_customTpl hinzufügenVARCHAR(64) DEFAULT '' NOT NULL Feld tl_content.ct_teaserBox_page hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_teaserBox_pageText hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_teaserBox_pageTitle hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_teaserBox_customTpl hinzufügenVARCHAR(64) DEFAULT '' NOT NULL Feld tl_content.ct_wrapper_name hinzufügenTEXT DEFAULT NULL Feld tl_content.ct_sliderElement_page hinzufügenVARCHAR(255) DEFAULT '' NOT NULL Feld tl_content.ct_sliderElement_linkText hinzufügenVARCHAR(255) DEFAULT '' NOT NULL Feld tl_content.ct_sliderElement_target hinzufügenCHAR(1) DEFAULT '' NOT NULL Feld tl_content.ct_sliderElement_subHeadline hinzufügenVARCHAR(255) DEFAULT '' NOT NULL Feld tl_content.mateTeaserBoxPlus_bg hinzufügenTEXT DEFAULT NULL Feld tl_content.mateTeaserBoxPlus_bgHover hinzufügenTEXT DEFAULT NULL Feld tl_content.mateTeaserBoxPlus_text hinzufügenTEXT DEFAULT NULL Feld tl_content.mateTeaserBoxPlus_color hinzufügenTEXT DEFAULT NULL Feld tl_content.mateTeaserBoxPlus_colorHover hinzufügenTEXT DEFAULT NULL Feld tl_content.mateTeaserBoxPlus_size hinzufügenVARCHAR(64) DEFAULT 'normal' NOT NULL Feld tl_content.imagemargin löschen Feld tl_content.guests löschen Feld tl_content.bs_grid_parent löschen Feld tl_content.bs_grid löschen Feld tl_content.ptable ändernVARCHAR(64) CHARACTER SET ascii DEFAULT 'tl_article' NOT NULL COLLATE `ascii_bin` Feld tl_content.addImage ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.showPreview ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.inline ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.overwriteMeta ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.fullsize ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.thead ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.tfoot ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.tleft ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.sortable ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.target ändernCHAR(1) DEFAULT '' NOT NULL Feld tl_content.overwriteLink ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.useImage ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.useHomeDir ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.metaIgnore ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.playerStart ändernVARCHAR(16) DEFAULT '' NOT NULL Feld tl_content.playerStop ändernVARCHAR(16) DEFAULT '' NOT NULL Feld tl_content.splashImage ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.sliderContinuous ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.protected ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.cssID ändernVARCHAR(255) DEFAULT '' NOT NULL Feld tl_content.invisible ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_content.ct_contentBox_customTpl hinzufügenVARCHAR(64) DEFAULT '' NOT NULL Feld tl_content.bs_grid_name löschen Feld tl_content.ct_sliderElement_playerSRC hinzufügenBLOB DEFAULT NULL Feld tl_content.bs_image_sizes löschen Feld tl_form.advancedCss löschen Feld tl_form_field.advancedCss hinzufügenVARCHAR(255) DEFAULT '' NOT NULL Feld tl_form_field.tabindex löschen Feld tl_form_field.bs_grid_parent löschen Feld tl_form_field.bs_grid_name löschen Feld tl_form_field.bs_grid löschen Feld tl_form_field.mandatory ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_form_field.multiple ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_form_field.storeFile ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_form_field.useHomeDir ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_form_field.doNotOverwrite ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_form_field.class ändernVARCHAR(255) DEFAULT '' NOT NULL Feld tl_form_field.imageSubmit ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_form_field.invisible ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_layout.stylesheet löschen Feld tl_layout.loadingOrder löschen Feld tl_layout.layoutType löschen Feld tl_member.loginAttempts löschen Feld tl_member.locked löschen Feld tl_module.url löschen Feld tl_module.guests löschen Feld tl_module.bs_gridModules löschen Feld tl_module.bs_grid löschen Feld tl_page.enableCsp hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.csp hinzufügenLONGTEXT DEFAULT NULL Feld tl_page.cspReportOnly hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.cspReportLog hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.ac_defaultColumnWidth hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.ac_disableCSS hinzufügenTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.enable_high_contrast hinzufügenTINYINT(1) DEFAULT 1 NOT NULL Feld tl_page.enable_font_size hinzufügenTINYINT(1) DEFAULT 1 NOT NULL Feld tl_page.enable_font_size_switcher hinzufügenTINYINT(1) DEFAULT 1 NOT NULL Feld tl_page.newsArchives hinzufügenBLOB DEFAULT NULL Feld tl_page.feedFormat hinzufügenVARCHAR(32) CHARACTER SET ascii DEFAULT 'rss' NOT NULL COLLATE `ascii_bin` Feld tl_page.feedSource hinzufügenVARCHAR(32) CHARACTER SET ascii DEFAULT 'source_teaser' NOT NULL COLLATE `ascii_bin` Feld tl_page.maxFeedItems hinzufügenSMALLINT UNSIGNED DEFAULT 25 NOT NULL Feld tl_page.feedFeatured hinzufügenVARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin` Feld tl_page.feedDescription hinzufügenTEXT DEFAULT NULL Feld tl_page.imgSize hinzufügenVARCHAR(255) DEFAULT '' NOT NULL Feld tl_page.ac_set hinzufügenVARCHAR(255) DEFAULT '' NOT NULL Feld tl_page.font_size_comment_page hinzufügenINT UNSIGNED DEFAULT 0 NOT NULL Feld tl_page.tabindex löschen Feld tl_page.requireItem ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.redirectBack ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.target ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.fallback ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.disableLanguageRedirect ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.maintenanceMode ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.enableCanonical ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.useFolderUrl ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.useSSL ändernTINYINT(1) DEFAULT 1 NOT NULL Feld tl_page.autoforward ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.protected ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.includeLayout ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.includeCache ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.alwaysLoadFromCache ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.includeChmod ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.noSearch ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.cssClass ändernVARCHAR(64) DEFAULT '' NOT NULL Feld tl_page.hide ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.guests ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.published ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.enforceTwoFactor ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_page.alwaysForward ändernTINYINT(1) DEFAULT 0 NOT NULL Feld tl_theme.vars löschen Feld tl_theme.bs_grid_default_size löschen Feld tl_theme.bs_grid_sizes löschen Feld tl_theme.bs_grid_columns löschen Feld tl_user.fullscreen löschen Feld tl_user.loginAttempts löschen Feld tl_user.locked löschen

Die Löschungen habe ich absichtlich nicht ausführen lassen.
24.06.2025, 07:32
Spooky

Was genau passiert, wenn du versuchst die Änderungen anwenden zu lassen? Wenn es zu Fehlern kommt musst du diese posten.
24.06.2025, 07:44
MarkIII

Es wird nur

Zitat:

Die Änderungen konnten nicht angewendet werden. Möglicherweise wurde die Datenbank geändert, bitte prüfe nochmals und versuche es erneut.

angezeigt.

Ich könnte nur noch mit der Konsolenausgabe dienen, z.B.

Code:

ALTER TABLE tl_article DROP keywords, DROP guests, CHANGE showTeaser showTeaser TINYINT(1) DEFAULT 0 NOT NULL, CHANGE protected protected TINYINT(1) DEFAULT 0 NOT NULL, CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL, CHANGE published published TINYINT(1) DEFAULT 0 NOT NULL
24.06.2025, 07:51
Spooky

In der Konsolenausgabe müsste noch mehr stehen, inkl. Fehler.
24.06.2025, 08:10
MarkIII

Das ist die Ausgabe nach Eingabe von contao:migrate

Code:

09:08:17 WARNING [php] Warning: Undefined array key "deleteConfirm" ["exception" => ErrorException { …}] 09:08:17 WARNING [php] Warning: Undefined array key "deleteConfirm" ["exception" => ErrorException { …}] 09:08:17 WARNING [php] Warning: Undefined array key "deleteConfirm" ["exception" => ErrorException { …}] 09:08:17 WARNING [php] Warning: Undefined array key "admin" ["exception" => ErrorException { …}] 09:08:17 WARNING [php] Warning: Undefined array key "admin" ["exception" => ErrorException { …}] 09:08:17 WARNING [php] Warning: Undefined array key "admin" ["exception" => ErrorException { …}] 09:08:17 WARNING [php] Warning: Undefined array key "admin" ["exception" => ErrorException { …}] 09:08:17 WARNING [php] Warning: Undefined array key "admin" ["exception" => ErrorException { …}] [INFO] Creating a database dump to "backup__20250624070818.sql.gz" with the default options. Use --no-backup to disable this feature. Pending database migrations (fc4d8a5d1b610f5c8f667e2d14eb3b5211f3126f81c76973ca61b4983368358e) ---------------------------------------------------------------------------------------------- * DROP TABLE tl_bs_grid * DROP TABLE tl_style * DROP TABLE tl_style_sheet * ALTER TABLE tl_article DROP keywords, DROP guests, CHANGE showTeaser showTeaser TINYINT(1) DEFAULT 0 NOT NULL, CHANGE protected protected TINYINT(1) DEFAULT 0 NOT NULL, CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL, CHANGE published published TINYINT(1) DEFAULT 0 NOT NULL * ALTER TABLE tl_content ADD closeSections TINYINT(1) DEFAULT 0 NOT NULL, ADD com_moderate TINYINT(1) DEFAULT 0 NOT NULL, ADD com_bbcode TINYINT(1) DEFAULT 0 NOT NULL, ADD com_disableCaptcha TINYINT(1) DEFAULT 0 NOT NULL, ADD com_requireLogin TINYINT(1) DEFAULT 0 NOT NULL, ADD mateTeaserBoxPlus TINYINT(1) DEFAULT 0 NOT NULL, ADD sectionHeadline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL, ADD unfilteredHtml MEDIUMTEXT DEFAULT NULL, ADD com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`, ADD com_perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, ADD com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, ADD subline TEXT DEFAULT NULL, ADD headline_inline CHAR(1) DEFAULT '' NOT NULL, ADD subheadline CHAR(1) DEFAULT '' NOT NULL, ADD ct_contentBox_page TEXT DEFAULT NULL, ADD ct_contentBox_pageText TEXT DEFAULT NULL, ADD ct_contentBox_pageTitle TEXT DEFAULT NULL, ADD ct_featureIcon VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_iconLink TEXT DEFAULT NULL, ADD ct_featureElement_customTpl VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_price VARCHAR(20) DEFAULT '' NOT NULL, ADD ct_priceLabel VARCHAR(50) DEFAULT '' NOT NULL, ADD ct_priceBox_link1 TEXT DEFAULT NULL, ADD ct_priceBox_linkText1 TEXT DEFAULT NULL, ADD ct_priceBox_link2 TEXT DEFAULT NULL, ADD ct_priceBox_linkText2 TEXT DEFAULT NULL, ADD ct_popularPriceBox VARCHAR(50) DEFAULT '' NOT NULL, ADD ct_priceBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_teaserBox_page TEXT DEFAULT NULL, ADD ct_teaserBox_pageText TEXT DEFAULT NULL, ADD ct_teaserBox_pageTitle TEXT DEFAULT NULL, ADD ct_teaserBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_wrapper_name TEXT DEFAULT NULL, ADD ct_sliderElement_page VARCHAR(255) DEFAULT '' NOT NULL, ADD ct_sliderElement_linkText VARCHAR(255) DEFAULT '' NOT NULL, ADD ct_sliderElement_target CHAR(1) DEFAULT '' NOT NULL, ADD ct_sliderElement_subHeadline VARCHAR(255) DEFAULT '' NOT NULL, ADD mateTeaserBoxPlus_bg TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_bgHover TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_text TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_color TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_colorHover TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_size VARCHAR(64) DEFAULT 'normal' NOT NULL, DROP imagemargin, DROP guests, DROP bs_grid_parent, DROP bs_grid, CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT 'tl_article' NOT NULL COLLATE `ascii_bin`, CHANGE addImage addImage TINYINT(1) DEFAULT 0 NOT NULL, CHANGE showPreview showPreview TINYINT(1) DEFAULT 0 NOT NULL, CHANGE inline inline TINYINT(1) DEFAULT 0 NOT NULL, CHANGE overwriteMeta overwriteMeta TINYINT(1) DEFAULT 0 NOT NULL, CHANGE fullsize fullsize TINYINT(1) DEFAULT 0 NOT NULL, CHANGE thead thead TINYINT(1) DEFAULT 0 NOT NULL, CHANGE tfoot tfoot TINYINT(1) DEFAULT 0 NOT NULL, CHANGE tleft tleft TINYINT(1) DEFAULT 0 NOT NULL, CHANGE sortable sortable TINYINT(1) DEFAULT 0 NOT NULL, CHANGE target target CHAR(1) DEFAULT '' NOT NULL, CHANGE overwriteLink overwriteLink TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useImage useImage TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useHomeDir useHomeDir TINYINT(1) DEFAULT 0 NOT NULL, CHANGE metaIgnore metaIgnore TINYINT(1) DEFAULT 0 NOT NULL, CHANGE playerStart playerStart VARCHAR(16) DEFAULT '' NOT NULL, CHANGE playerStop playerStop VARCHAR(16) DEFAULT '' NOT NULL, CHANGE splashImage splashImage TINYINT(1) DEFAULT 0 NOT NULL, CHANGE sliderContinuous sliderContinuous TINYINT(1) DEFAULT 0 NOT NULL, CHANGE protected protected TINYINT(1) DEFAULT 0 NOT NULL, CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL, CHANGE invisible invisible TINYINT(1) DEFAULT 0 NOT NULL * ALTER TABLE tl_content ADD ct_contentBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL, DROP bs_grid_name * ALTER TABLE tl_content ADD ct_sliderElement_playerSRC BLOB DEFAULT NULL, DROP bs_image_sizes * ALTER TABLE tl_form DROP advancedCss * ALTER TABLE tl_form_field ADD advancedCss VARCHAR(255) DEFAULT '' NOT NULL, DROP tabindex, DROP bs_grid_parent, DROP bs_grid_name, DROP bs_grid, CHANGE mandatory mandatory TINYINT(1) DEFAULT 0 NOT NULL, CHANGE multiple multiple TINYINT(1) DEFAULT 0 NOT NULL, CHANGE storeFile storeFile TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useHomeDir useHomeDir TINYINT(1) DEFAULT 0 NOT NULL, CHANGE doNotOverwrite doNotOverwrite TINYINT(1) DEFAULT 0 NOT NULL, CHANGE class class VARCHAR(255) DEFAULT '' NOT NULL, CHANGE imageSubmit imageSubmit TINYINT(1) DEFAULT 0 NOT NULL, CHANGE invisible invisible TINYINT(1) DEFAULT 0 NOT NULL * ALTER TABLE tl_layout DROP stylesheet, DROP loadingOrder, DROP layoutType * ALTER TABLE tl_member DROP loginAttempts, DROP locked * ALTER TABLE tl_module DROP url, DROP guests, DROP bs_gridModules, DROP bs_grid * ALTER TABLE tl_page ADD enableCsp TINYINT(1) DEFAULT 0 NOT NULL, ADD csp LONGTEXT DEFAULT NULL, ADD cspReportOnly TINYINT(1) DEFAULT 0 NOT NULL, ADD cspReportLog TINYINT(1) DEFAULT 0 NOT NULL, ADD ac_defaultColumnWidth TINYINT(1) DEFAULT 0 NOT NULL, ADD ac_disableCSS TINYINT(1) DEFAULT 0 NOT NULL, ADD enable_high_contrast TINYINT(1) DEFAULT 1 NOT NULL, ADD enable_font_size TINYINT(1) DEFAULT 1 NOT NULL, ADD enable_font_size_switcher TINYINT(1) DEFAULT 1 NOT NULL, ADD newsArchives BLOB DEFAULT NULL, ADD feedFormat VARCHAR(32) CHARACTER SET ascii DEFAULT 'rss' NOT NULL COLLATE `ascii_bin`, ADD feedSource VARCHAR(32) CHARACTER SET ascii DEFAULT 'source_teaser' NOT NULL COLLATE `ascii_bin`, ADD maxFeedItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL, ADD feedFeatured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`, ADD feedDescription TEXT DEFAULT NULL, ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL, ADD ac_set VARCHAR(255) DEFAULT '' NOT NULL, ADD font_size_comment_page INT UNSIGNED DEFAULT 0 NOT NULL, DROP tabindex, CHANGE requireItem requireItem TINYINT(1) DEFAULT 0 NOT NULL, CHANGE redirectBack redirectBack TINYINT(1) DEFAULT 0 NOT NULL, CHANGE target target TINYINT(1) DEFAULT 0 NOT NULL, CHANGE fallback fallback TINYINT(1) DEFAULT 0 NOT NULL, CHANGE disableLanguageRedirect disableLanguageRedirect TINYINT(1) DEFAULT 0 NOT NULL, CHANGE maintenanceMode maintenanceMode TINYINT(1) DEFAULT 0 NOT NULL, CHANGE enableCanonical enableCanonical TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useFolderUrl useFolderUrl TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useSSL useSSL TINYINT(1) DEFAULT 1 NOT NULL, CHANGE autoforward autoforward TINYINT(1) DEFAULT 0 NOT NULL, CHANGE protected protected TINYINT(1) DEFAULT 0 NOT NULL, CHANGE includeLayout includeLayout TINYINT(1) DEFAULT 0 NOT NULL, CHANGE includeCache includeCache TINYINT(1) DEFAULT 0 NOT NULL, CHANGE alwaysLoadFromCache alwaysLoadFromCache TINYINT(1) DEFAULT 0 NOT NULL, CHANGE includeChmod includeChmod TINYINT(1) DEFAULT 0 NOT NULL, CHANGE noSearch noSearch TINYINT(1) DEFAULT 0 NOT NULL, CHANGE cssClass cssClass VARCHAR(64) DEFAULT '' NOT NULL, CHANGE hide hide TINYINT(1) DEFAULT 0 NOT NULL, CHANGE guests guests TINYINT(1) DEFAULT 0 NOT NULL, CHANGE published published TINYINT(1) DEFAULT 0 NOT NULL, CHANGE enforceTwoFactor enforceTwoFactor TINYINT(1) DEFAULT 0 NOT NULL, CHANGE alwaysForward alwaysForward TINYINT(1) DEFAULT 0 NOT NULL * ALTER TABLE tl_theme DROP vars, DROP bs_grid_default_size, DROP bs_grid_sizes, DROP bs_grid_columns * ALTER TABLE tl_user DROP fullscreen, DROP loginAttempts, DROP locked Execute the listed database updates? [yes]: [0] yes [1] yes, with deletes [2] no > 0 Execute database migrations --------------------------- * ALTER TABLE tl_article CHANGE showTeaser showTeaser TINYINT(1) DEFAULT 0 NOT NULL, CHANGE protected protected TINYINT(1) DEFAULT 0 NOT NULL, CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL, CHANGE published published TINYINT(1) DEFAULT 0 NOT NULL......FAILED * ALTER TABLE tl_content ADD closeSections TINYINT(1) DEFAULT 0 NOT NULL, ADD com_moderate TINYINT(1) DEFAULT 0 NOT NULL, ADD com_bbcode TINYINT(1) DEFAULT 0 NOT NULL, ADD com_disableCaptcha TINYINT(1) DEFAULT 0 NOT NULL, ADD com_requireLogin TINYINT(1) DEFAULT 0 NOT NULL, ADD mateTeaserBoxPlus TINYINT(1) DEFAULT 0 NOT NULL, ADD sectionHeadline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL, ADD unfilteredHtml MEDIUMTEXT DEFAULT NULL, ADD com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`, ADD com_perPage SMALLINT UNSIGNED DEFAULT 0 NOT NULL, ADD com_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, ADD subline TEXT DEFAULT NULL, ADD headline_inline CHAR(1) DEFAULT '' NOT NULL, ADD subheadline CHAR(1) DEFAULT '' NOT NULL, ADD ct_contentBox_page TEXT DEFAULT NULL, ADD ct_contentBox_pageText TEXT DEFAULT NULL, ADD ct_contentBox_pageTitle TEXT DEFAULT NULL, ADD ct_contentBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_featureIcon VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_iconLink TEXT DEFAULT NULL, ADD ct_featureElement_customTpl VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_price VARCHAR(20) DEFAULT '' NOT NULL, ADD ct_priceLabel VARCHAR(50) DEFAULT '' NOT NULL, ADD ct_priceBox_link1 TEXT DEFAULT NULL, ADD ct_priceBox_linkText1 TEXT DEFAULT NULL, ADD ct_priceBox_link2 TEXT DEFAULT NULL, ADD ct_priceBox_linkText2 TEXT DEFAULT NULL, ADD ct_popularPriceBox VARCHAR(50) DEFAULT '' NOT NULL, ADD ct_priceBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_teaserBox_page TEXT DEFAULT NULL, ADD ct_teaserBox_pageText TEXT DEFAULT NULL, ADD ct_teaserBox_pageTitle TEXT DEFAULT NULL, ADD ct_teaserBox_customTpl VARCHAR(64) DEFAULT '' NOT NULL, ADD ct_wrapper_name TEXT DEFAULT NULL, ADD ct_sliderElement_page VARCHAR(255) DEFAULT '' NOT NULL, ADD ct_sliderElement_linkText VARCHAR(255) DEFAULT '' NOT NULL, ADD ct_sliderElement_target CHAR(1) DEFAULT '' NOT NULL, ADD ct_sliderElement_subHeadline VARCHAR(255) DEFAULT '' NOT NULL, ADD ct_sliderElement_playerSRC BLOB DEFAULT NULL, ADD mateTeaserBoxPlus_bg TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_bgHover TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_text TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_color TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_colorHover TEXT DEFAULT NULL, ADD mateTeaserBoxPlus_size VARCHAR(64) DEFAULT 'normal' NOT NULL, CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT 'tl_article' NOT NULL COLLATE `ascii_bin`, CHANGE addImage addImage TINYINT(1) DEFAULT 0 NOT NULL, CHANGE showPreview showPreview TINYINT(1) DEFAULT 0 NOT NULL, CHANGE inline inline TINYINT(1) DEFAULT 0 NOT NULL, CHANGE overwriteMeta overwriteMeta TINYINT(1) DEFAULT 0 NOT NULL, CHANGE fullsize fullsize TINYINT(1) DEFAULT 0 NOT NULL, CHANGE thead thead TINYINT(1) DEFAULT 0 NOT NULL, CHANGE tfoot tfoot TINYINT(1) DEFAULT 0 NOT NULL, CHANGE tleft tleft TINYINT(1) DEFAULT 0 NOT NULL, CHANGE sortable sortable TINYINT(1) DEFAULT 0 NOT NULL, CHANGE target target CHAR(1) DEFAULT '' NOT NULL, CHANGE overwriteLink overwriteLink TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useImage useImage TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useHomeDir useHomeDir TINYINT(1) DEFAULT 0 NOT NULL, CHANGE metaIgnore metaIgnore TINYINT(1) DEFAULT 0 NOT NULL, CHANGE playerStart playerStart VARCHAR(16) DEFAULT '' NOT NULL, CHANGE playerStop playerStop VARCHAR(16) DEFAULT '' NOT NULL, CHANGE splashImage splashImage TINYINT(1) DEFAULT 0 NOT NULL, CHANGE sliderContinuous sliderContinuous TINYINT(1) DEFAULT 0 NOT NULL, CHANGE protected protected TINYINT(1) DEFAULT 0 NOT NULL, CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL, CHANGE invisible invisible TINYINT(1) DEFAULT 0 NOT NULL......FAILED * ALTER TABLE tl_form_field ADD advancedCss VARCHAR(255) DEFAULT '' NOT NULL, CHANGE mandatory mandatory TINYINT(1) DEFAULT 0 NOT NULL, CHANGE multiple multiple TINYINT(1) DEFAULT 0 NOT NULL, CHANGE storeFile storeFile TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useHomeDir useHomeDir TINYINT(1) DEFAULT 0 NOT NULL, CHANGE doNotOverwrite doNotOverwrite TINYINT(1) DEFAULT 0 NOT NULL, CHANGE class class VARCHAR(255) DEFAULT '' NOT NULL, CHANGE imageSubmit imageSubmit TINYINT(1) DEFAULT 0 NOT NULL, CHANGE invisible invisible TINYINT(1) DEFAULT 0 NOT NULL......FAILED * ALTER TABLE tl_page ADD enableCsp TINYINT(1) DEFAULT 0 NOT NULL, ADD csp LONGTEXT DEFAULT NULL, ADD cspReportOnly TINYINT(1) DEFAULT 0 NOT NULL, ADD cspReportLog TINYINT(1) DEFAULT 0 NOT NULL, ADD ac_defaultColumnWidth TINYINT(1) DEFAULT 0 NOT NULL, ADD ac_disableCSS TINYINT(1) DEFAULT 0 NOT NULL, ADD enable_high_contrast TINYINT(1) DEFAULT 1 NOT NULL, ADD enable_font_size TINYINT(1) DEFAULT 1 NOT NULL, ADD enable_font_size_switcher TINYINT(1) DEFAULT 1 NOT NULL, ADD newsArchives BLOB DEFAULT NULL, ADD feedFormat VARCHAR(32) CHARACTER SET ascii DEFAULT 'rss' NOT NULL COLLATE `ascii_bin`, ADD feedSource VARCHAR(32) CHARACTER SET ascii DEFAULT 'source_teaser' NOT NULL COLLATE `ascii_bin`, ADD maxFeedItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL, ADD feedFeatured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`, ADD feedDescription TEXT DEFAULT NULL, ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL, ADD ac_set VARCHAR(255) DEFAULT '' NOT NULL, ADD font_size_comment_page INT UNSIGNED DEFAULT 0 NOT NULL, CHANGE requireItem requireItem TINYINT(1) DEFAULT 0 NOT NULL, CHANGE redirectBack redirectBack TINYINT(1) DEFAULT 0 NOT NULL, CHANGE target target TINYINT(1) DEFAULT 0 NOT NULL, CHANGE fallback fallback TINYINT(1) DEFAULT 0 NOT NULL, CHANGE disableLanguageRedirect disableLanguageRedirect TINYINT(1) DEFAULT 0 NOT NULL, CHANGE maintenanceMode maintenanceMode TINYINT(1) DEFAULT 0 NOT NULL, CHANGE enableCanonical enableCanonical TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useFolderUrl useFolderUrl TINYINT(1) DEFAULT 0 NOT NULL, CHANGE useSSL useSSL TINYINT(1) DEFAULT 1 NOT NULL, CHANGE autoforward autoforward TINYINT(1) DEFAULT 0 NOT NULL, CHANGE protected protected TINYINT(1) DEFAULT 0 NOT NULL, CHANGE includeLayout includeLayout TINYINT(1) DEFAULT 0 NOT NULL, CHANGE includeCache includeCache TINYINT(1) DEFAULT 0 NOT NULL, CHANGE alwaysLoadFromCache alwaysLoadFromCache TINYINT(1) DEFAULT 0 NOT NULL, CHANGE includeChmod includeChmod TINYINT(1) DEFAULT 0 NOT NULL, CHANGE noSearch noSearch TINYINT(1) DEFAULT 0 NOT NULL, CHANGE cssClass cssClass VARCHAR(64) DEFAULT '' NOT NULL, CHANGE hide hide TINYINT(1) DEFAULT 0 NOT NULL, CHANGE guests guests TINYINT(1) DEFAULT 0 NOT NULL, CHANGE published published TINYINT(1) DEFAULT 0 NOT NULL, CHANGE enforceTwoFactor enforceTwoFactor TINYINT(1) DEFAULT 0 NOT NULL, CHANGE alwaysForward alwaysForward TINYINT(1) DEFAULT 0 NOT NULL......FAILED [OK] Executed 0 SQL queries. [ERROR] An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'cssID' at row 441 [ERROR] An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'cssID' at row 1720 [ERROR] An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'class' at row 14 [ERROR] An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'cssClass' at row 62
24.06.2025, 08:27
Spooky

In Zukunft immer gleich die Konsolenausgabe posten, damit die Fehler von Anfang an sichtbar sind ;)

Poste mal die Ausgabe von

Code:

SELECT cssID FROM tl_article WHERE CHAR_LENGTH(cssID) > 255

und

Code:

SELECT cssID FROM tl_content WHERE CHAR_LENGTH(cssID) > 255
24.06.2025, 08:27
zoglo

Poste deine composer.json

Der Fehler deutet daraufhin, dass du Plugins genutzt hast, welche die Spalte cssID vergrößert haben.
Nun hast du in diesem "CSS-Feld" Daten drin, welche länger sind als die laut der Migration zu lesenden erlaubten 255 Zeichen.

CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL
24.06.2025, 08:46
MarkIII

Zitat:

Zitat von Spooky

In Zukunft immer gleich die Konsolenausgabe posten, damit die Fehler von Anfang an sichtbar sind ;)

Poste mal die Ausgabe von

Code:

SELECT cssID FROM tl_article WHERE LEN(cssID) > 255

und

Code:

SELECT cssID FROM tl_content WHERE LEN(cssID) > 255

wenn ich das in der Konsole eingebe kommt ein syntax error

Code:

/usr/bin/php8.3-cli vendor/bin/contao-console SELECT cssID FROM tl_content WHERE LEN(cssID) > 255 -bash: syntax error near unexpected token `(' ('
24.06.2025, 08:48
MarkIII

Zitat:

Zitat von zoglo

Poste deine composer.json

Der Fehler deutet daraufhin, dass du Plugins genutzt hast, welche die Spalte cssID vergrößert haben.
Nun hast du in diesem "CSS-Feld" Daten drin, welche länger sind als die laut der Migration zu lesenden erlaubten 255 Zeichen.

CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL

Code:

{ "type": "project", "require": { "christianbarkowsky/contao-tiny-compress-images": "^2.2", "con4gis/maps": "^10.1", "contao-themes-net/mate-theme-bundle": "^3.5", "contao/calendar-bundle": "5.3.*", "contao/comments-bundle": "5.3.*", "contao/conflicts": "*@dev", "contao/faq-bundle": "5.3.*", "contao/listing-bundle": "5.3.*", "contao/manager-bundle": "5.3.*", "contao/news-bundle": "5.3.*", "contao/newsletter-bundle": "5.3.*", "dklemmt/contao_dk_masonry": "^2.0", "do-while/contao-backupdb-bundle": "^2.1", "inspiredminds/contao-glightbox": "^1.0", "inspiredminds/contao-mailer-command": "^1.0", "jonnysp/pannorama": "^1.0", "madeyourday/contao-rocksolid-antispam": "^2.1", "madeyourday/contao-rocksolid-frontend-helper": "^2.2", "oveleon/contao-company-bundle": "^1.5", "oveleon/contao-cookiebar": "^2.2", "oveleon/contao-google-recommendation-bundle": "^1.3", "oveleon/contao-recommendation-bundle": "^1.7", "pdir/contao-seo-plugin": "^1.0", "terminal42/notification_center": "^2.4", "trilobit-gmbh/contao-tiles-bundle": "^2.0" }, "extra": { "public-dir": "public", "contao-component-dir": "assets" }, "scripts": { "post-install-cmd": [ "@php vendor/bin/contao-setup" ], "post-update-cmd": [ "@php vendor/bin/contao-setup" ] } }
24.06.2025, 08:54
Spooky

Zitat:

Zitat von MarkIII

wenn ich das in der Konsole eingebe kommt ein syntax error

Code:

/usr/bin/php8.3-cli vendor/bin/contao-console SELECT cssID FROM tl_content WHERE LEN(cssID) > 255 -bash: syntax error near unexpected token `(' ('

Das ist ein SQL Query, dazu musst du dich vorher mit der Datenbank verbinden, mit einem Tool deiner Wahl (oder über die Konsole).
24.06.2025, 08:58
MarkIII

Zitat:

Zitat von Spooky

Das ist ein SQL Query, dazu musst du dich vorher mit der Datenbank verbinden, mit einem Tool deiner Wahl (oder über die Konsole).

Hab ich mittlerweile auch kapiert :o

Ausgabe jeweils:

Code:

#1305 - FUNCTION dbs13295735.LEN existiert nicht
24.06.2025, 09:05
Spooky

Ah, CHAR_LENGTH muss es natürlich sein, nicht LEN (oben ausgebessert).
24.06.2025, 09:09
MarkIII

Zitat:

MySQL lieferte ein leeres Resultat zurück (d.h. null Datensätze).

bei beiden Abfragen
24.06.2025, 09:14
MarkIII

Ich denke, dass ich das ganze Update nochmal machen muss.
Ich hatte es in einer kopierten 4.13 Installation, also Testumgebung, ausgeführt.
Dazu die Tabellen der ursprünglichen Datenbank exportiert und in die neue importiert, dabei muss was schief gegangen sein, die Datenbank ist nur 0,05 GB groß, die originale jedoch 0,36 GB.
Ist mir leider jetzt erst aufgefallen.
24.06.2025, 09:15
Spooky

Poste die Ausgaben von

Code:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'database-name' AND TABLE_NAME IN ('tl_content', 'tl_article') AND COLUMN_NAME = 'cssID';

Ersetze database-name mit dem Namen der Datenbank.
24.06.2025, 09:28
MarkIII

Code:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = 'dbs13295735' AND TABLE_NAME IN ('tl_content', 'tl_article') AND COLUMN_NAME = 'cssID' TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT IS_GENERATED GENERATION_EXPRESSION def dbs13295735 tl_article cssID 18 NULL YES text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_unicode_ci text select,insert,update,references NEVER NULL def dbs13295735 tl_content cssID 84 NULL YES text 65535 65535 NULL NULL NULL utf8mb4 utf8mb4_unicode_ci text select,insert,update,references NEVER NULL
24.06.2025, 09:40
Spooky

Du scheinst eine DCA Anpassung für diese Spalten gemacht zu haben - diese musst du auch in Contao 5.3 wieder einfügen. Also bspw.:

PHP-Code:

// contao/dca/tl_content.php use Doctrine\DBAL\Platforms\MySQLPlatform; $GLOBALS['TL_DCA']['tl_content']['fields']['cssID']['sql'] = ['type' => 'text', 'length' => MySQLPlatform::LENGTH_LIMIT_TEXT, 'notnull' => false];

PHP-Code:

// contao/dca/tl_article.php use Doctrine\DBAL\Platforms\MySQLPlatform; $GLOBALS['TL_DCA']['tl_article']['fields']['cssID']['sql'] = ['type' => 'text', 'length' => MySQLPlatform::LENGTH_LIMIT_TEXT, 'notnull' => false];

PHP-Code:

// contao/dca/tl_form_field.php use Doctrine\DBAL\Platforms\MySQLPlatform; $GLOBALS['TL_DCA']['tl_form_field']['fields']['class']['sql'] = ['type' => 'text', 'length' => MySQLPlatform::LENGTH_LIMIT_TEXT, 'notnull' => false];

PHP-Code:

// contao/dca/tl_page.php use Doctrine\DBAL\Platforms\MySQLPlatform; $GLOBALS['TL_DCA']['tl_page']['fields']['cssClass']['sql'] = ['type' => 'text', 'length' => MySQLPlatform::LENGTH_LIMIT_TEXT, 'notnull' => false];

Oder du implementierst dir eine eigene Migration, wo du dir die Daten wieder auf die kleine Größe migrieren lässt.
24.06.2025, 09:40
zoglo

Blick in Blackbox:

- advancedCss
- tl_bs_grid

Hier wurden mal irgendwelche Erweiterungen für Styles installiert und deinstalliert.
Eine Erweiterung die mal installiert war hat das Feld cssID von varchar 255 auf text geändert... z.B. macht es der contao-component-style-manager so.
24.06.2025, 17:16
MarkIII

Das Problem lag an der ursprünglichen Datenbank. Im alten Contao 4.13 war tatsächlich mal eine Erweiterung installiert, die 4 Tabellenfelder von VARCHAR (255) auf TEXT geändert hatte. Mit der Datenbankaktualisierung im Contao-Manager ließ sich das nie rückgängig machen und gab immer diesen "truncate"-Fehler aus. Hatte aber auch keine Auswirkung auf das Frontend.

Lösung: In der alten Datenbank habe ich mittels phpMyAdmin den Befehl

Code:

CHANGE cssID cssID VARCHAR(255) DEFAULT '' NOT NULL

in den entsprechenden Tabellen direkt eingegeben. Zuerst kam wieder der "truncate"-Fehler, beim zweiten Mal hat es dann funktioniert.

Anschließend hat die Migration der Datenbank in die neue Installation geklappt und das Update auf 5.3 auch :)

Danke für's in die richtige Richtung schubsen!