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

**MarkIII** · 24.06.2025, 07:24

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.

**Spooky** · 24.06.2025, 07:32

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

**MarkIII** · 24.06.2025, 07:44

Es wird nur

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

**Spooky** · 24.06.2025, 07:51

In der Konsolenausgabe müsste noch mehr stehen, inkl. Fehler.

**MarkIII** · 24.06.2025, 08:10

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

**Spooky** · 24.06.2025, 08:27

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

**zoglo** · 24.06.2025, 08:27

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

**MarkIII** · 24.06.2025, 08:46

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 `('
('

**MarkIII** · 24.06.2025, 08:48

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"
        ]
    }
}

**Spooky** · 24.06.2025, 08:54

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).

**MarkIII** · 24.06.2025, 08:58

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

Ausgabe jeweils:

Code:

#1305 - FUNCTION dbs13295735.LEN existiert nicht

**Spooky** · 24.06.2025, 09:05

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

**MarkIII** · 24.06.2025, 09:09

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

bei beiden Abfragen

**MarkIII** · 24.06.2025, 09:14

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.

**Spooky** · 24.06.2025, 09:15

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.

**MarkIII** · 24.06.2025, 09:28

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

**Spooky** · 24.06.2025, 09:40

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.

**zoglo** · 24.06.2025, 09:40

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.

**MarkIII** · 24.06.2025, 17:16

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!

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

Themen-Optionen

Thema durchsuchen

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

Aktive Benutzer

Aktive Benutzer

Berechtigungen