Contao 5 Installation nach Contao 4.13 Installation migrieren

**esther** · 11.11.2022, 14:22

Hallo zusammen

Ich habe auf Contao 5 eine Webseite erstellt und merke erst jetzt dass gewisse Erweiterungen, welche ich in Contao 4 Installationen verwendet habe und auch in Contao 5 verwenden möchte, nicht kompatibel sind. Wie gehe ich am besten vor, wenn ich die Contao 5 Installation auf eine Contao 4.13 migrieren möchte? Ich habe es bereits probiert, contao-Backend läuft, theme geladen, templates rüberkopiert, aber ich bekomme im Frontend bei allen Seiten eine 404.
https://contao413.alterszentrum-wiesengrund.ch/home

Ist das überhaupt möglich, was ich da möchte?

Grüesse
Esther

**Spooky** · 11.11.2022, 14:37

Downgrades können von der Datenbank her problematisch sein, aber zwischen 5.0 und 4.13 ist es vermutlich machbar. Dein Problem ist vermutlich anderer Natur.

**esther** · 12.11.2022, 21:28

Unbenannt.PNG

Wenn ich hier "anzeigen" wähle, sehe ich den Seiteninhalt, aber im Navigationsmenü sind die Seiten nicht aufgelistet.

**tab** · 12.11.2022, 22:03

Zitat von esther

Unbenannt.PNG

Wenn ich hier "anzeigen" wähle, sehe ich den Seiteninhalt, aber im Navigationsmenü sind die Seiten nicht aufgelistet.

Schon mal geschaut, ob in den Einstellungen der Seiten diese auch als veröffentlicht angezeigt werden (also der entsprechende Haken noch gesetzt ist)? Falls ja, eventuell die Einstellungen der Seiten nochmal speichern. Ansonsten eventuell mal die Artikel und Inhaltselemente auf veröffentlicht kontrollieren. Keine Ahnung ob es hilft, ein Downgrade habe ich bisher auch noch nie gemacht.

Der Artikel war als leeres <div> ja im Seitenquelltext zu sehen

**esther** · 12.11.2022, 23:06

Danke Tab, die Sichtbarkeit der Seiten / Artikel ist i.O.

Bei Klick auf "Seiten" oder "Artikel" kommt ein Internal Server Error:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'guests' in 'field list'

Bei Klick auf "Theme" kommt ein Internal Server Error:
An exception occurred while executing a query: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'azwiesen_contao413.tl_style_sheet' doesn't exist

Und Contao Manager möchte folgende Datenbank-Änderungen machen:

CREATE TABLE tl_news_feed (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title VARCHAR(255) DEFAULT '' NOT NULL, alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`, language VARCHAR(32) DEFAULT '' NOT NULL, archives BLOB DEFAULT NULL, format VARCHAR(32) DEFAULT 'rss' NOT NULL, source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL, maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL, feedBase VARCHAR(255) DEFAULT '' NOT NULL, description TEXT DEFAULT NULL, imgSize VARCHAR(255) DEFAULT '' NOT NULL, INDEX alias (alias), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC

CREATE TABLE tl_style (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, sorting INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, selector VARCHAR(1022) DEFAULT '' NOT NULL, category VARCHAR(32) DEFAULT '' NOT NULL, comment VARCHAR(255) DEFAULT '' NOT NULL, size CHAR(1) DEFAULT '' NOT NULL, width VARCHAR(64) DEFAULT '' NOT NULL, height VARCHAR(64) DEFAULT '' NOT NULL, minwidth VARCHAR(64) DEFAULT '' NOT NULL, minheight VARCHAR(64) DEFAULT '' NOT NULL, maxwidth VARCHAR(64) DEFAULT '' NOT NULL, maxheight VARCHAR(64) DEFAULT '' NOT NULL, positioning CHAR(1) DEFAULT '' NOT NULL, trbl VARCHAR(128) DEFAULT '' NOT NULL, position VARCHAR(32) DEFAULT '' NOT NULL, floating VARCHAR(32) DEFAULT '' NOT NULL, clear VARCHAR(32) DEFAULT '' NOT NULL, overflow VARCHAR(32) DEFAULT '' NOT NULL, display VARCHAR(32) DEFAULT '' NOT NULL, alignment CHAR(1) DEFAULT '' NOT NULL, margin VARCHAR(128) DEFAULT '' NOT NULL, padding VARCHAR(128) DEFAULT '' NOT NULL, align VARCHAR(32) DEFAULT '' NOT NULL, verticalalign VARCHAR(32) DEFAULT '' NOT NULL, textalign VARCHAR(32) DEFAULT '' NOT NULL, whitespace VARCHAR(8) DEFAULT '' NOT NULL, background CHAR(1) DEFAULT '' NOT NULL, bgcolor VARCHAR(64) DEFAULT '' NOT NULL, bgimage VARCHAR(255) DEFAULT '' NOT NULL, bgposition VARCHAR(32) DEFAULT '' NOT NULL, bgrepeat VARCHAR(32) DEFAULT '' NOT NULL, shadowsize VARCHAR(128) DEFAULT '' NOT NULL, shadowcolor VARCHAR(64) DEFAULT '' NOT NULL, gradientAngle VARCHAR(32) DEFAULT '' NOT NULL, gradientColors VARCHAR(128) DEFAULT '' NOT NULL, border CHAR(1) DEFAULT '' NOT NULL, borderwidth VARCHAR(128) DEFAULT '' NOT NULL, borderstyle VARCHAR(32) DEFAULT '' NOT NULL, bordercolor VARCHAR(64) DEFAULT '' NOT NULL, borderradius VARCHAR(128) DEFAULT '' NOT NULL, bordercollapse VARCHAR(32) DEFAULT '' NOT NULL, borderspacing VARCHAR(64) DEFAULT '' NOT NULL, font CHAR(1) DEFAULT '' NOT NULL, fontfamily VARCHAR(255) DEFAULT '' NOT NULL, fontsize VARCHAR(64) DEFAULT '' NOT NULL, fontcolor VARCHAR(64) DEFAULT '' NOT NULL, lineheight VARCHAR(64) DEFAULT '' NOT NULL, fontstyle VARCHAR(255) DEFAULT '' NOT NULL, texttransform VARCHAR(32) DEFAULT '' NOT NULL, textindent VARCHAR(64) DEFAULT '' NOT NULL, letterspacing VARCHAR(64) DEFAULT '' NOT NULL, wordspacing VARCHAR(64) DEFAULT '' NOT NULL, list CHAR(1) DEFAULT '' NOT NULL, liststyletype VARCHAR(32) DEFAULT '' NOT NULL, liststyleimage VARCHAR(255) DEFAULT '' NOT NULL, own TEXT DEFAULT NULL, invisible CHAR(1) DEFAULT '' NOT NULL, INDEX pid (pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC

CREATE TABLE tl_style_sheet (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, name VARCHAR(64) DEFAULT NULL, embedImages INT UNSIGNED DEFAULT 0 NOT NULL, cc VARCHAR(32) DEFAULT '' NOT NULL, media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL, mediaQuery TEXT DEFAULT NULL, vars TEXT DEFAULT NULL, UNIQUE INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC

ALTER TABLE tl_remember_me CHANGE series series BINARY(32) NOT NULL COMMENT '(DC2Type:binary_string)'
ALTER TABLE tl_remember_me ADD expires DATETIME DEFAULT NULL
ALTER TABLE tl_remember_me DROP userIdentifier
ALTER TABLE tl_remember_me ADD username VARCHAR(200) NOT NULL
ALTER TABLE tl_article CHANGE published published CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_article CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_article CHANGE showTeaser showTeaser CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_article ADD guests CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_article ADD keywords TEXT DEFAULT NULL
ALTER TABLE tl_calendar CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE published published CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE target target CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE recurring recurring CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE addTime addTime CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events CHANGE featured featured CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_calendar_events DROP linkText
ALTER TABLE tl_calendar_events ADD imagemargin VARCHAR(128) DEFAULT '' NOT NULL
ALTER TABLE tl_comments CHANGE notifiedReply notifiedReply CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_comments CHANGE notified notified CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_comments CHANGE published published CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_comments CHANGE addReply addReply CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_comments_notify CHANGE active active CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE invisible invisible CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sliderContinuous sliderContinuous CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE splashImage splashImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE metaIgnore metaIgnore CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE useHomeDir useHomeDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE useImage useImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE overwriteLink overwriteLink CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE target target CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE sortable sortable CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE tleft tleft CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE tfoot tfoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE thead thead CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE overwriteMeta overwriteMeta CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE inline inline CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE showPreview showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content CHANGE addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content DROP playerTracksDefault
ALTER TABLE tl_content DROP unfilteredHtml
ALTER TABLE tl_content ADD guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content ADD imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_content DROP playerTracks
ALTER TABLE tl_content ADD orderSRC BLOB DEFAULT NULL
ALTER TABLE tl_faq CHANGE published published CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq ADD imagemargin VARCHAR(128) DEFAULT '' NOT NULL
ALTER TABLE tl_faq_category CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq_category CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq_category CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq_category CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_faq_category CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_files CHANGE found found CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_form CHANGE allowTags allowTags CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form CHANGE novalidate novalidate CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form CHANGE storeValues storeValues CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form CHANGE skipEmpty skipEmpty CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form CHANGE sendViaEmail sendViaEmail CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE imageSubmit imageSubmit CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE accesskey accesskey CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE doNotOverwrite doNotOverwrite CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE useHomeDir useHomeDir CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE storeFile storeFile CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE multiple multiple CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field CHANGE mandatory mandatory CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_form_field ADD tabindex SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_image_size CHANGE lazyLoading lazyLoading CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size CHANGE skipIfDimensionsMatch skipIfDimensionsMatch CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_image_size_item CHANGE invisible invisible CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_layout CHANGE static static CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_layout CHANGE addMooTools addMooTools CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_layout CHANGE addJQuery addJQuery CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_layout CHANGE minifyMarkup minifyMarkup CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout CHANGE combineScripts combineScripts CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_layout ADD loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL
ALTER TABLE tl_layout ADD stylesheet BLOB DEFAULT NULL
ALTER TABLE tl_member CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE assignDir assignDir CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_member CHANGE login login CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_member_group CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_member_group CHANGE redirect redirect CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_module CHANGE nl_hideChannels nl_hideChannels CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE cal_showQuantity cal_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE cal_ignoreDynamic cal_ignoreDynamic CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE cal_hideRunning cal_hideRunning CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE cal_noSpan cal_noSpan CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE com_disableCaptcha com_disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE com_requireLogin com_requireLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE com_bbcode com_bbcode CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE com_moderate com_moderate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE protected protected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_activate reg_activate CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_assignDir reg_assignDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_deleteDir reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_skipName reg_skipName CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE reg_allowLogin reg_allowLogin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE disableCaptcha disableCaptcha CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE fullsize fullsize CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE useCaption useCaption CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE fuzzy fuzzy CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE redirectBack redirectBack CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE autologin autologin CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE showHidden showHidden CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE defineRoot defineRoot CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE showProtected showProtected CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module CHANGE hardLimit hardLimit CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module DROP unfilteredHtml
ALTER TABLE tl_module ADD news_metaFields VARCHAR(255) CHARACTER SET ascii DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD guests CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD orderSRC BLOB DEFAULT NULL
ALTER TABLE tl_module ADD url TEXT DEFAULT NULL
ALTER TABLE tl_news CHANGE published published CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news CHANGE noComments noComments CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news CHANGE target target CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news CHANGE addEnclosure addEnclosure CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news CHANGE fullsize fullsize CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news CHANGE overwriteMeta overwriteMeta CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news CHANGE addImage addImage CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news CHANGE featured featured CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news DROP linkText
ALTER TABLE tl_news ADD imagemargin VARCHAR(128) DEFAULT '' NOT NULL
ALTER TABLE tl_news_archive CHANGE disableCaptcha disableCaptcha CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news_archive CHANGE requireLogin requireLogin CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news_archive CHANGE bbcode bbcode CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news_archive CHANGE moderate moderate CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news_archive CHANGE allowComments allowComments CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_news_archive CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_newsletter CHANGE sent sent CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_newsletter CHANGE externalImages externalImages CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_newsletter CHANGE sendText sendText CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_newsletter CHANGE addFile addFile CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_newsletter_recipients CHANGE active active CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE enforceTwoFactor enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE published published CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE accesskey accesskey CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE hide hide CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE noSearch noSearch CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE includeChmod includeChmod CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE alwaysLoadFromCache alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE includeCache includeCache CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE includeLayout includeLayout CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE autoforward autoforward CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_page CHANGE useFolderUrl useFolderUrl CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE enableCanonical enableCanonical CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE maintenanceMode maintenanceMode CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE disableLanguageRedirect disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE fallback fallback CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE target target CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE redirectBack redirectBack CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page CHANGE requireItem requireItem CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_page DROP imgSize
ALTER TABLE tl_page DROP feedDescription
ALTER TABLE tl_page DROP feedFeatured
ALTER TABLE tl_page DROP maxFeedItems
ALTER TABLE tl_page DROP feedSource
ALTER TABLE tl_page DROP feedFormat
ALTER TABLE tl_page DROP newsArchives
ALTER TABLE tl_page ADD tabindex SMALLINT UNSIGNED DEFAULT 0 NOT NULL
ALTER TABLE tl_page ADD guests CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_preview_link CHANGE published published CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_preview_link CHANGE showUnpublished showUnpublished CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_search CHANGE protected protected CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_theme ADD vars TEXT DEFAULT NULL
ALTER TABLE tl_user CHANGE useTwoFactor useTwoFactor CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE admin admin CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE pwChange pwChange CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user CHANGE useCE useCE CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE useRTE useRTE CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE thumbnails thumbnails CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user CHANGE showHelp showHelp CHAR(1) DEFAULT '1' NOT NULL
ALTER TABLE tl_user ADD newsfeedp BLOB DEFAULT NULL
ALTER TABLE tl_user ADD newsfeeds BLOB DEFAULT NULL
ALTER TABLE tl_user ADD fullscreen CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user_group CHANGE disable disable CHAR(1) DEFAULT '' NOT NULL
ALTER TABLE tl_user_group ADD newsfeedp BLOB DEFAULT NULL
ALTER TABLE tl_user_group ADD newsfeeds BLOB DEFAULT NULL
ALTER TABLE tl_version CHANGE active active CHAR(1) DEFAULT '' NOT NULL

**esther** · 12.11.2022, 23:46

Vor der Datenbank-Anpassung - muss ich noch sagen - hab ich die Datenbank nochmals von der Contao 5 Installation kopiert und in die Contao 4.12 Installation migriert (da kamen die obigen Internal Server Errors bei Klick auf "Seiten", "Artikel" und "Theme"), sah aber die Seiten im Frontend wieder und sah sie auch in der Navigation.

Nun hab ich zuerst die "CREATE TABLE" und "ADD" Änderungen durchgeführt. Dann kam ich wieder auf die "Seiten", "Artikel" und "Theme", aber konnte zb. keine Module speichern (DB-Fehler beim "Zugriffsschutz" bezüglich einer Mitgliedergruppe "Gäste" die da sein sollte, ich aber gar nie erstellt hatte). So hab ich dann den Rest der Datenbank-Änderungen auch noch durchgeführt. Aber nun seh ich im Frontend die Seiten wieder nicht mehr (und auch nicht in der Navigation) - ausser ich bin im Vorschau-Modus, dann sehe ich die Seiten wieder (aber auch hier sind sie nicht in der Navigation zu sehen).
https://contao413.alterszentrum-wiesengrund.ch/preview.php/home.html