Ergebnis 1 bis 7 von 7

Thema: 4.8 -> 4.13, Fehler Schema-Änderungen, CM DB prüfen vs. Installtool DB aktualisieren

  1. #1
    Contao-Fan
    Registriert seit
    12.04.2011.
    Ort
    Hamburg
    Beiträge
    540

    Standard 4.8 -> 4.13, Fehler Schema-Änderungen, CM DB prüfen vs. Installtool DB aktualisieren

    Huhu,

    hatte gerade etwas Merkwürdiges.

    Ich habe ein Update von 4.8 auf 4.13 durchgeführt. Bei der Datenbankmigration (über Contao Manager/ "Datenbank prüfen") wurden die ersten Schritte problemlos durchgeführt, bis dann eine lange Liste von Fehlermeldungen folgte.

    Bildschirmfoto 2024-04-12 um 18.00.42.png

    Ich habe abgebrochen und es noch ein paar Mal versucht, es endete auf die gleiche Weise.

    Mein Verdacht fiel dann auf den Umstand, dass die alte Datenbank aus MySQL 5.7 exportiert war und die neue MariaDB 10.4. war.

    Aber ich ging dem nicht weiter nach, weil ich aus irgendwelchen Gründen dann an das "alte" Installtool dachte, was ich dann startete und dort "Datenbank aktualisieren" betätigte. Die Schema-Änderungen liefen ohne Fehler durch.

    Auch "Datenbank prüfen" im Contao Manager direkt zeigte anschließend keine Fehler mehr.

    Ich bin nun verunsichert, was das wohl war - sind "Datenbank prüfen" und "Datenbank aktualisieren" unterschiedliche Scripte?
    Und was bedeuten die Fehlermeldungen?

    Wie gesagt ist das Problem anscheinend ja aus der Welt, aber ich würde gern verstehen, was das war.
    Hat es zu tun mit MySQL -> MariaDB?

    Ist es grundsätzlich sinnvoll, bei solchen Fehlern versuchsweise das Installtool zu benutzen?


    Code:
    CREATE TABLE tl_crawl_queue (id INT UNSIGNED AUTO_INCREMENT NOT NULL, job_id CHAR(128) NOT NULL, uri LONGTEXT NOT NULL, uri_hash CHAR(40) NOT NULL, found_on LONGTEXT DEFAULT NULL, level SMALLINT NOT NULL, processed TINYINT(1) NOT NULL, tags LONGTEXT DEFAULT NULL, INDEX job_id (job_id), INDEX uri_hash (uri_hash), INDEX processed (processed), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_cron_job (id INT UNSIGNED AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, lastRun DATETIME NOT NULL, INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_trusted_device (id INT AUTO_INCREMENT NOT NULL, created DATETIME NOT NULL, userClass VARCHAR(255) DEFAULT NULL, userId INT DEFAULT NULL, user_agent LONGTEXT DEFAULT NULL, ua_family VARCHAR(255) DEFAULT NULL, os_family VARCHAR(255) DEFAULT NULL, device_family VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_preview_link (id INT UNSIGNED AUTO_INCREMENT NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, url VARCHAR(2048) DEFAULT '' NOT NULL, showUnpublished CHAR(1) DEFAULT '' NOT NULL, restrictToUrl CHAR(1) DEFAULT '1' NOT NULL, createdAt INT UNSIGNED DEFAULT 0 NOT NULL, expiresAt INT UNSIGNED DEFAULT 0 NOT NULL, published CHAR(1) DEFAULT '' NOT NULL, createdBy INT UNSIGNED DEFAULT 0 NOT NULL, INDEX id_published_expiresat (id, published, expiresat), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_search (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, title TEXT DEFAULT NULL, url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`, text MEDIUMTEXT DEFAULT NULL, filesize DOUBLE PRECISION DEFAULT '0' NOT NULL, checksum VARCHAR(32) DEFAULT '' NOT NULL, protected CHAR(1) DEFAULT '' NOT NULL, groups BLOB DEFAULT NULL, language VARCHAR(5) DEFAULT '' NOT NULL, vectorLength DOUBLE PRECISION DEFAULT '0' NOT NULL, meta MEDIUMTEXT DEFAULT NULL, UNIQUE INDEX url (url), UNIQUE INDEX checksum_pid (checksum, pid), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_search_index (pid INT UNSIGNED NOT NULL, termId INT UNSIGNED NOT NULL, relevance SMALLINT UNSIGNED NOT NULL, INDEX pid (pid), PRIMARY KEY(termid, pid)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    CREATE TABLE tl_search_term (id INT UNSIGNED AUTO_INCREMENT NOT NULL, term VARCHAR(64) NOT NULL COLLATE `utf8mb4_bin`, documentFrequency INT UNSIGNED NOT NULL, UNIQUE INDEX term (term), INDEX documentfrequency (documentfrequency), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    DROP TABLE tl_cron
    DROP INDEX pid_start_stop_published_sorting ON tl_article
    ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    CREATE INDEX pid_published_incolumn_start_stop ON tl_article (pid, published, incolumn, start, stop)
    DROP INDEX pid_start_stop_published ON tl_calendar_events
    ALTER TABLE tl_calendar_events CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events CHANGE endDate endDate BIGINT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE startDate startDate BIGINT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE endTime endTime BIGINT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE startTime startTime BIGINT DEFAULT NULL
    ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_calendar_events ADD robots VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_calendar_events ADD featured CHAR(1) DEFAULT '' NOT NULL
    CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)
    ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_calendar_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
    DROP INDEX source_parent_active ON tl_comments_notify
    ALTER TABLE tl_comments_notify CHANGE url url VARCHAR(2048) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    CREATE INDEX source_parent_active_email ON tl_comments_notify (source, parent, active, email)
    DROP INDEX pid_ptable_invisible_sorting ON tl_content
    ALTER TABLE tl_content CHANGE rsts_content_type rsts_content_type VARCHAR(16) CHARACTER SET ascii DEFAULT 'rsts_default' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_import_settings rsts_import_settings CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_template rsts_template VARCHAR(32) CHARACTER SET ascii DEFAULT 'rsts_default' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_type rsts_type VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_direction rsts_direction VARCHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_random rsts_random CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_loop rsts_loop CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_centerContent rsts_centerContent VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_skin rsts_skin VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_width rsts_width VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_height rsts_height VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_gapSize rsts_gapSize VARCHAR(32) CHARACTER SET ascii DEFAULT '0%' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_videoAutoplay rsts_videoAutoplay CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_autoplayProgress rsts_autoplayProgress CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_pauseAutoplayOnHover rsts_pauseAutoplayOnHover CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_navType rsts_navType VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_controls rsts_controls CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbControls rsts_thumbControls CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_invertControls rsts_invertControls CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_scaleMode rsts_scaleMode VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_imagePosition rsts_imagePosition VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_keyboard rsts_keyboard CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_captions rsts_captions CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs rsts_thumbs CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_width rsts_thumbs_width VARCHAR(64) CHARACTER SET ascii DEFAULT '100%' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_height rsts_thumbs_height VARCHAR(64) CHARACTER SET ascii DEFAULT '1x1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_gapSize rsts_thumbs_gapSize VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_scaleMode rsts_thumbs_scaleMode VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_imagePosition rsts_thumbs_imagePosition VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_controls rsts_thumbs_controls CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_imgSize rsts_thumbs_imgSize VARCHAR(64) CHARACTER SET ascii DEFAULT 'a:3:{i:0;s:2:"50";i:1;s:2:"50";i:2;s:4:"crop";}' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_thumbs_visibleArea rsts_thumbs_visibleArea DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_content CHANGE rsts_thumbs_visibleAreaMax rsts_thumbs_visibleAreaMax DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_content CHANGE rsts_thumbs_rowSlideRatio rsts_thumbs_rowSlideRatio VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_visibleArea rsts_visibleArea DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_content CHANGE rsts_visibleAreaMax rsts_visibleAreaMax DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_content CHANGE rsts_visibleAreaAlign rsts_visibleAreaAlign DOUBLE PRECISION UNSIGNED DEFAULT '50' NOT NULL
    ALTER TABLE tl_content CHANGE rsts_rowSlideRatio rsts_rowSlideRatio VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_combineNavItems rsts_combineNavItems CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_customSkin rsts_customSkin VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE rsts_cssPrefix rsts_cssPrefix VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE com_template com_template 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 com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE stop stop VARCHAR(10) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE start start VARCHAR(10) 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 guests guests 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 playerColor playerColor VARCHAR(6) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE playerPreload playerPreload VARCHAR(8) 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 playerAspect playerAspect VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE playerSize playerSize VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE vimeo vimeo VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE youtube youtube VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE galleryTpl galleryTpl VARCHAR(64) 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 sortBy sortBy VARCHAR(32) 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 url url TEXT DEFAULT NULL
    ALTER TABLE tl_content CHANGE highlight highlight VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) CHARACTER SET ascii DEFAULT 'ascending' 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 listtype listtype VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) CHARACTER SET ascii DEFAULT 'above' 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 imageUrl imageUrl TEXT DEFAULT NULL
    ALTER TABLE tl_content CHANGE imagemargin imagemargin VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE size size VARCHAR(128) 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 addImage addImage CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'text' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content CHANGE ptable ptable VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD data TEXT DEFAULT NULL
    ALTER TABLE tl_content ADD markdownSource VARCHAR(12) CHARACTER SET ascii DEFAULT 'sourceText' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_content ADD showPreview CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    CREATE INDEX pid_ptable_invisible_start_stop ON tl_content (pid, ptable, invisible, start, stop)
    CREATE INDEX type ON tl_content (type)
    DROP INDEX pid_published_sorting ON tl_faq
    ALTER TABLE tl_faq CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_faq ADD description TEXT DEFAULT NULL
    ALTER TABLE tl_faq ADD robots VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_faq ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
    CREATE INDEX pid_published ON tl_faq (pid, published)
    DROP INDEX path ON tl_files
    ALTER TABLE tl_files CHANGE name name VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_files CHANGE extension extension VARCHAR(16) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_files CHANGE path path VARCHAR(1022) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_files ADD lastModified INT UNSIGNED DEFAULT NULL
    CREATE INDEX path ON tl_files (path(768))
    ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_form ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    DROP INDEX pid ON tl_form_field
    ALTER TABLE tl_form_field ADD step VARCHAR(10) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field ADD maxImageHeight INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_form_field ADD maxImageWidth INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_form_field ADD errorMsg VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_form_field ADD customRgxp VARCHAR(255) DEFAULT '' NOT NULL
    CREATE INDEX pid_invisible ON tl_form_field (pid, invisible)
    ALTER TABLE tl_image_size CHANGE formats formats VARCHAR(1024) DEFAULT '' NOT NULL
    ALTER TABLE tl_image_size ADD lazyLoading CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_layout DROP mooSource
    ALTER TABLE tl_layout DROP jSource
    ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_member CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_member DROP loginCount
    ALTER TABLE tl_member ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_member ADD backupCodes TEXT DEFAULT NULL
    ALTER TABLE tl_member ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
    CREATE INDEX login_disable_start_stop ON tl_member (login, disable, start, stop)
    CREATE INDEX disable_start_stop ON tl_member_group (disable, start, stop)
    ALTER TABLE tl_module CHANGE rsts_content_type rsts_content_type VARCHAR(16) CHARACTER SET ascii DEFAULT 'rsts_default' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_import_settings rsts_import_settings CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_template rsts_template VARCHAR(32) CHARACTER SET ascii DEFAULT 'rsts_default' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_type rsts_type VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_direction rsts_direction VARCHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_random rsts_random CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_loop rsts_loop CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_centerContent rsts_centerContent VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_skin rsts_skin VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_width rsts_width VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_height rsts_height VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_gapSize rsts_gapSize VARCHAR(32) CHARACTER SET ascii DEFAULT '0%' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_videoAutoplay rsts_videoAutoplay CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_autoplayProgress rsts_autoplayProgress CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_pauseAutoplayOnHover rsts_pauseAutoplayOnHover CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_navType rsts_navType VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_controls rsts_controls CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbControls rsts_thumbControls CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_invertControls rsts_invertControls CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_scaleMode rsts_scaleMode VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_imagePosition rsts_imagePosition VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_keyboard rsts_keyboard CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_captions rsts_captions CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs rsts_thumbs CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_width rsts_thumbs_width VARCHAR(64) CHARACTER SET ascii DEFAULT '100%' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_height rsts_thumbs_height VARCHAR(64) CHARACTER SET ascii DEFAULT '1x1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_gapSize rsts_thumbs_gapSize VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_scaleMode rsts_thumbs_scaleMode VARCHAR(8) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_imagePosition rsts_thumbs_imagePosition VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_controls rsts_thumbs_controls CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_imgSize rsts_thumbs_imgSize VARCHAR(64) CHARACTER SET ascii DEFAULT 'a:3:{i:0;s:2:"50";i:1;s:2:"50";i:2;s:4:"crop";}' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_thumbs_visibleArea rsts_thumbs_visibleArea DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_module CHANGE rsts_thumbs_visibleAreaMax rsts_thumbs_visibleAreaMax DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_module CHANGE rsts_thumbs_rowSlideRatio rsts_thumbs_rowSlideRatio VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_visibleArea rsts_visibleArea DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_module CHANGE rsts_visibleAreaMax rsts_visibleAreaMax DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    ALTER TABLE tl_module CHANGE rsts_visibleAreaAlign rsts_visibleAreaAlign DOUBLE PRECISION UNSIGNED DEFAULT '50' NOT NULL
    ALTER TABLE tl_module CHANGE rsts_rowSlideRatio rsts_rowSlideRatio VARCHAR(32) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_combineNavItems rsts_combineNavItems CHAR(1) CHARACTER SET ascii DEFAULT '1' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_customSkin rsts_customSkin VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE rsts_cssPrefix rsts_cssPrefix VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    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 news_showQuantity news_showQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) CHARACTER SET ascii DEFAULT 'order_date_desc' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'news_month' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE news_metaFields 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 CHANGE news_jumpToCurrent news_jumpToCurrent VARCHAR(16) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE list_info_where list_info_where TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_info list_info TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_sort list_sort TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_search list_search TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_where list_where TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_fields list_fields TINYTEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE list_table list_table VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) 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 com_order com_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' 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_ctemplate cal_ctemplate VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(16) CHARACTER SET ascii DEFAULT 'ascending' 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_format cal_format VARCHAR(32) CHARACTER SET ascii DEFAULT 'cal_month' 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 guests guests 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_close reg_close VARCHAR(32) 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 rss_template rss_template VARCHAR(64) 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 imgSize imgSize VARCHAR(128) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE url url TEXT DEFAULT NULL
    ALTER TABLE tl_module CHANGE loadFirst loadFirst CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) CHARACTER SET ascii DEFAULT 'main' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE searchTpl searchTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(16) CHARACTER SET ascii DEFAULT 'simple' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE contextLength contextLength VARCHAR(64) 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 queryType queryType VARCHAR(8) CHARACTER SET ascii DEFAULT 'and' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE memberTpl memberTpl VARCHAR(64) 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 customTpl customTpl VARCHAR(64) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module CHANGE navigationTpl navigationTpl VARCHAR(64) 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 CHANGE type type VARCHAR(64) CHARACTER SET ascii DEFAULT 'navigation' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module ADD cal_featured VARCHAR(16) CHARACTER SET ascii DEFAULT 'all_items' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module ADD rootPageDependentModules BLOB DEFAULT NULL
    ALTER TABLE tl_module ADD data TEXT DEFAULT NULL
    ALTER TABLE tl_module ADD reg_deleteDir CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
    ALTER TABLE tl_module ADD overviewPage INT UNSIGNED DEFAULT 0 NOT NULL
    DROP INDEX pid_start_stop_published ON tl_news
    ALTER TABLE tl_news CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_news CHANGE imageUrl imageUrl VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_news ADD robots VARCHAR(32) DEFAULT '' NOT NULL
    CREATE INDEX pid_published_featured_start_stop ON tl_news (pid, published, featured, start, stop)
    ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_news_feed ADD imgSize VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_newsletter ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter_channel CHANGE template template VARCHAR(32) DEFAULT '' NOT NULL
    ALTER TABLE tl_newsletter_channel ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    DROP INDEX pid_type_start_stop_published ON tl_page
    ALTER TABLE tl_page CHANGE urlSuffix urlSuffix VARCHAR(16) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE urlPrefix urlPrefix VARCHAR(128) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_page CHANGE useSSL useSSL CHAR(1) DEFAULT '1' NOT NULL
    ALTER TABLE tl_page CHANGE url url VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_page DROP sitemapName
    ALTER TABLE tl_page ADD subpageLayout INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_page ADD canonicalKeepParams VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD canonicalLink VARCHAR(2048) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD enableCanonical CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD mailerTransport VARCHAR(255) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD maintenanceMode CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_page ADD robotsTxt TEXT DEFAULT NULL
    ALTER TABLE tl_page ADD favicon BINARY(16) DEFAULT NULL
    ALTER TABLE tl_page ADD routePriority INT DEFAULT 0 NOT NULL
    CREATE INDEX pid_published_type_start_stop ON tl_page (pid, published, type, start, stop)
    ALTER TABLE tl_page DROP createSitemap
    ALTER TABLE tl_page ADD disableLanguageRedirect CHAR(1) DEFAULT '' NOT NULL
    ALTER TABLE tl_undo DROP haste_data
    ALTER TABLE tl_undo ADD preview MEDIUMBLOB DEFAULT NULL
    ALTER TABLE tl_user CHANGE language language VARCHAR(64) DEFAULT '' NOT NULL
    ALTER TABLE tl_user CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
    ALTER TABLE tl_user DROP loginCount
    ALTER TABLE tl_user ADD rsts_permissions BLOB DEFAULT NULL
    ALTER TABLE tl_user ADD rsts_sliders BLOB DEFAULT NULL
    ALTER TABLE tl_user ADD pageLanguageLabels TEXT DEFAULT NULL
    ALTER TABLE tl_user ADD trustedTokenVersion INT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_user ADD backupCodes TEXT DEFAULT NULL
    ALTER TABLE tl_user ADD loginAttempts SMALLINT UNSIGNED DEFAULT 0 NOT NULL
    ALTER TABLE tl_user ADD fields BLOB DEFAULT NULL
    ALTER TABLE tl_user ADD elements BLOB DEFAULT NULL
    ALTER TABLE tl_user_group ADD rsts_permissions BLOB DEFAULT NULL
    ALTER TABLE tl_user_group ADD rsts_sliders BLOB DEFAULT NULL
    DROP INDEX fromtable ON tl_version
    DROP INDEX pid ON tl_version
    CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)
    CREATE INDEX userid ON tl_version (userid)
    DROP INDEX series ON tl_remember_me
    DROP INDEX value ON tl_remember_me
    ALTER TABLE tl_remember_me CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_article
    ALTER TABLE tl_article CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_calendar CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_calendar_events
    ALTER TABLE tl_calendar_events CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_calendar_feed
    ALTER TABLE tl_calendar_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX published ON tl_comments
    DROP INDEX source_parent_published ON tl_comments
    ALTER TABLE tl_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX tokenremove ON tl_comments_notify
    ALTER TABLE tl_comments_notify CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_faq CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_faq_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX extension ON tl_files
    DROP INDEX uuid ON tl_files
    DROP INDEX pid ON tl_files
    ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_form
    ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_form_field CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_image_size
    ALTER TABLE tl_image_size CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_image_size_item
    ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX email ON tl_member
    DROP INDEX username ON tl_member
    ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_news
    ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_news_archive CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX alias ON tl_news_feed
    ALTER TABLE tl_news_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_newsletter
    ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid_hash ON tl_newsletter_deny_list
    ALTER TABLE tl_newsletter_deny_list CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX active ON tl_newsletter_recipients
    DROP INDEX pid_email ON tl_newsletter_recipients
    DROP INDEX email ON tl_newsletter_recipients
    ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX removeon ON tl_opt_in
    DROP INDEX token ON tl_opt_in
    ALTER TABLE tl_opt_in CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX reltable_relid ON tl_opt_in_related
    ALTER TABLE tl_opt_in_related CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX languagemain ON tl_page
    DROP INDEX alias ON tl_page
    DROP INDEX type_dns ON tl_page
    ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_rocksolid_slide
    ALTER TABLE tl_rocksolid_slide CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_rocksolid_slider CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX pid ON tl_style
    ALTER TABLE tl_style CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX name ON tl_style_sheet
    ALTER TABLE tl_style_sheet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_undo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    DROP INDEX username ON tl_user
    DROP INDEX email ON tl_user
    ALTER TABLE tl_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

  2. #2
    Contao-Fan
    Registriert seit
    24.02.2021.
    Beiträge
    984
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Der Manager hat derzeit noch kein Logging für Fehler, welche bei einer fehlgeschlagenen Datenbanktransaktion auftreten.
    In deinem Beispiel gibt es auch keine Fehlermeldungen.

    Versuche es einmal über das Installtool und hangel dich von DROP INDEX über CREATE INDEX hoch...

  3. #3
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    35.517
    Partner-ID
    10107

    Standard

    Ansonsten über SSH contao:migrate --no-interaction -v ausführen.
    » sponsor me via GitHub or PayPal or Revolut

  4. #4
    Contao-Fan
    Registriert seit
    12.04.2011.
    Ort
    Hamburg
    Beiträge
    540

    Standard

    Hmmm... bin nicht sicher, ob ich Eure Tipps richtig verstehe, dennoch danke! :-)

    Über das Installtool hatte es ja bereits geklappt. Ich wollte gern wissen, ob es anders arbeitet als "Datenbank prüfen".

    Sind die aufgeführten Meldungen (s. Screenshot) unwichtig?

    Ist das Installtool "besser" oder nur weniger empfindlich? Sollte ich grundsätzlich mit dem Installtool arbeiten?

  5. #5
    Contao-Fan
    Registriert seit
    24.02.2021.
    Beiträge
    984
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Zitat Zitat von pipkin Beitrag anzeigen
    Ist das Installtool "besser" oder nur weniger empfindlich? Sollte ich grundsätzlich mit dem Installtool arbeiten?
    Das Install-Tool gibt es ab Contao 5 nicht mehr, daher wirst du hier ohne Install-Tool leben müssen.
    Es ist nicht weniger empfindlich, erlaubt aber einzelne Schema-Änderungen durchzuführen.

  6. #6
    Contao-Fan
    Registriert seit
    12.04.2011.
    Ort
    Hamburg
    Beiträge
    540

    Standard

    Das Install-Tool gibt es ab Contao 5 nicht mehr, daher wirst du hier ohne Install-Tool leben müssen.
    Es ist nicht weniger empfindlich, erlaubt aber einzelne Schema-Änderungen durchzuführen
    Ah, gut zu wissen...

    Verständnisfrage:
    Wenn eine Migration über SSH funktioniert und nicht über den Contao Manager - spricht das dafür, dass die Migrationsprobleme eigentlich Performance-Probleme sind?

  7. #7
    Contao-Fan
    Registriert seit
    24.02.2021.
    Beiträge
    984
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Zitat Zitat von zoglo Beitrag anzeigen
    Der Manager hat derzeit noch kein Logging für Fehler, welche bei einer fehlgeschlagenen Datenbanktransaktion auftreten
    Ich revidiere meine Aussage, da es vor 2 Stunden durch ausi in einem PR aufgenommen wurde - Dann wahrscheinlich in Version 1.8.5 oder 1.9.0

    https://github.com/contao/contao-manager/pull/804

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •