Contao-Camp 2024
Ergebnis 1 bis 10 von 10

Thema: Migration 3.5x auf 4.9.x: Installer mit Datenbankfehler

  1. #1
    Contao-Nutzer Avatar von truni
    Registriert seit
    18.08.2009.
    Ort
    Zürcher Unterland
    Beiträge
    166

    Frage Migration 3.5x auf 4.9.x: Installer mit Datenbankfehler

    Wir möchten eine 3.5.40 wie gewohnt migrieren auf 4.9.3, der Installer läuft hoch und macht die DB-Zwischen-Updates der Contao-Versionen. Wir arbeiten beim Provider unseres Vertrauens (metanet), PHP 7.4 ist am Laufen mit 2GB Memory. Die anschliessenden DB Query hingegen stürzen ab. Könnte jemand helfen?
    Fehlermeldung in /manager/var/logs:

    Es ist ein Fehler aufgetreten.
    Bei der Ausführung des Skriptes ist ein Fehler aufgetreten. Irgendetwas funktioniert nicht richtig.

    Code:
    [2020-05-26 15:42:55] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://cn4.domain.ch/contao/install","method":"POST"} []
    [2020-05-26 15:42:56] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC':  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline." at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC':\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []
    Hier sind die vorgeschlagenen SQL Updates
    (Extensions habe ich noch keine installiert):

    Code:
    Tabellen ändern
    	Alle auswählen
    	
    ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_content CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX name ON tl_cron
    	
    ALTER TABLE tl_cron ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_cron CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX pid_published_sorting ON tl_faq
    	
    ALTER TABLE tl_faq ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_faq CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_faq_category ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_faq_category CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX extension ON tl_files
    	
    DROP INDEX pid ON tl_files
    	
    DROP INDEX path ON tl_files
    	
    DROP INDEX uuid ON tl_files
    	
    ALTER TABLE tl_files ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_files CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX alias ON tl_form
    	
    ALTER TABLE tl_form ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_form CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX pid ON tl_form_field
    	
    ALTER TABLE tl_form_field ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    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 ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    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 ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_image_size_item CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_layout ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_layout CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_log ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX username ON tl_member
    	
    DROP INDEX email ON tl_member
    	
    DROP INDEX autologin ON tl_member
    	
    DROP INDEX activation ON tl_member
    	
    ALTER TABLE tl_member ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_member CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_member_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_member_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_module ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_module CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX alias ON tl_news
    	
    DROP INDEX pid_start_stop_published ON tl_news
    	
    ALTER TABLE tl_news ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_news CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_news_archive ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    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 ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_news_feed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX pid ON tl_newsletter
    	
    ALTER TABLE tl_newsletter ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_newsletter CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_newsletter_channel ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_newsletter_channel CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX pid_email ON tl_newsletter_recipients
    	
    DROP INDEX pid ON tl_newsletter_recipients
    	
    DROP INDEX email ON tl_newsletter_recipients
    	
    ALTER TABLE tl_newsletter_recipients ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_newsletter_recipients CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX alias ON tl_page
    	
    DROP INDEX pid_type_start_stop_published ON tl_page
    	
    ALTER TABLE tl_page ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_page CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX url ON tl_search
    	
    DROP INDEX checksum_pid ON tl_search
    	
    DROP INDEX text ON tl_search
    	
    ALTER TABLE tl_search ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_search CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX pid ON tl_search_index
    	
    DROP INDEX word ON tl_search_index
    	
    ALTER TABLE tl_search_index ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_search_index CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX pid ON tl_style
    	
    ALTER TABLE tl_style ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    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 ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_style_sheet CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_theme ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_theme CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_undo ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_undo CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX email ON tl_user
    	
    DROP INDEX username ON tl_user
    	
    ALTER TABLE tl_user ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_user CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    ALTER TABLE tl_user_group ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_user_group CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    	
    DROP INDEX fromTable ON tl_version
    	
    DROP INDEX pid ON tl_version
    	
    ALTER TABLE tl_version ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    	
    ALTER TABLE tl_version CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
    Spalten ändern
    	Alle auswählen
    	
    ALTER TABLE tl_article CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
    	
    ALTER TABLE tl_article CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_calendar CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
    	
    ALTER TABLE tl_calendar CHANGE notify notify VARCHAR(32) DEFAULT 'notify_admin' NOT NULL
    	
    ALTER TABLE tl_calendar_events CHANGE source source VARCHAR(32) DEFAULT 'default' NOT NULL
    	
    ALTER TABLE tl_calendar_events CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL
    	
    ALTER TABLE tl_calendar_events CHANGE endTime endTime INT DEFAULT NULL
    	
    ALTER TABLE tl_calendar_events CHANGE startTime startTime INT DEFAULT NULL
    	
    ALTER TABLE tl_calendar_events CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_calendar_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL
    	
    ALTER TABLE tl_calendar_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL
    	
    ALTER TABLE tl_calendar_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL
    	
    ALTER TABLE tl_calendar_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_comments_notify CHANGE email email VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_content CHANGE com_template com_template VARCHAR(64) DEFAULT 'com_default' NOT NULL
    	
    ALTER TABLE tl_content CHANGE com_order com_order VARCHAR(32) DEFAULT 'ascending' NOT NULL
    	
    ALTER TABLE tl_content CHANGE perRow perRow SMALLINT UNSIGNED DEFAULT 4 NOT NULL
    	
    ALTER TABLE tl_content CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
    	
    ALTER TABLE tl_content CHANGE floating floating VARCHAR(32) DEFAULT 'above' NOT NULL
    	
    ALTER TABLE tl_content CHANGE size size VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_content CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
    	
    ALTER TABLE tl_content CHANGE type type VARCHAR(64) DEFAULT 'text' NOT NULL
    	
    ALTER TABLE tl_faq CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
    	
    ALTER TABLE tl_faq CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_faq_category CHANGE sortOrder sortOrder VARCHAR(12) DEFAULT 'ascending' NOT NULL
    	
    ALTER TABLE tl_faq_category CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL
    	
    ALTER TABLE tl_files CHANGE importantPartHeight importantPartHeight DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    	
    ALTER TABLE tl_files CHANGE importantPartWidth importantPartWidth DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    	
    ALTER TABLE tl_files CHANGE importantPartY importantPartY DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    	
    ALTER TABLE tl_files CHANGE importantPartX importantPartX DOUBLE PRECISION UNSIGNED DEFAULT '0' NOT NULL
    	
    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_form CHANGE method method VARCHAR(12) DEFAULT 'POST' NOT NULL
    	
    ALTER TABLE tl_form CHANGE format format VARCHAR(12) DEFAULT 'raw' NOT NULL
    	
    ALTER TABLE tl_form CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_form_field CHANGE extensions extensions VARCHAR(255) DEFAULT 'jpg,jpeg,gif,png,pdf,doc,docx,xls,xlsx,ppt,pptx' NOT NULL
    	
    ALTER TABLE tl_form_field CHANGE size size VARCHAR(255) DEFAULT 'a:2:{i:0;i:4;i:1;i:40;}' NOT NULL
    	
    ALTER TABLE tl_form_field CHANGE type type VARCHAR(64) DEFAULT 'text' 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 CHANGE align align VARCHAR(32) DEFAULT 'center' NOT NULL
    	
    ALTER TABLE tl_layout CHANGE mooSource mooSource VARCHAR(16) DEFAULT 'moo_local' NOT NULL
    	
    ALTER TABLE tl_layout CHANGE loadingOrder loadingOrder VARCHAR(16) DEFAULT 'external_first' NOT NULL
    	
    ALTER TABLE tl_layout CHANGE framework framework VARCHAR(255) DEFAULT 'a:2:{i:0;s:10:"layout.css";i:1;s:14:"responsive.css";}' NOT NULL
    	
    ALTER TABLE tl_layout CHANGE cols cols VARCHAR(8) DEFAULT '2cll' NOT NULL
    	
    ALTER TABLE tl_layout CHANGE `rows` `rows` VARCHAR(8) DEFAULT '2rwh' NOT NULL
    	
    ALTER TABLE tl_member CHANGE password password VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_member CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_module CHANGE nl_template nl_template VARCHAR(64) DEFAULT 'nl_simple' NOT NULL
    	
    ALTER TABLE tl_module CHANGE news_order news_order VARCHAR(32) DEFAULT 'order_date_desc' NOT NULL
    	
    ALTER TABLE tl_module CHANGE news_format news_format VARCHAR(32) DEFAULT 'news_month' NOT NULL
    	
    ALTER TABLE tl_module CHANGE news_template news_template VARCHAR(64) DEFAULT 'news_latest' NOT NULL
    	
    ALTER TABLE tl_module CHANGE news_metaFields news_metaFields VARCHAR(255) DEFAULT 'a:2:{i:0;s:4:"date";i:1;s:6:"author";}' NOT NULL
    	
    ALTER TABLE tl_module CHANGE news_featured news_featured VARCHAR(16) DEFAULT 'all_items' NOT NULL
    	
    ALTER TABLE tl_module CHANGE list_info_layout list_info_layout VARCHAR(64) DEFAULT 'info_default' NOT NULL
    	
    ALTER TABLE tl_module CHANGE list_layout list_layout VARCHAR(64) DEFAULT 'list_default' NOT NULL
    	
    ALTER TABLE tl_module CHANGE com_template com_template VARCHAR(64) DEFAULT 'com_default' NOT NULL
    	
    ALTER TABLE tl_module CHANGE com_order com_order VARCHAR(32) DEFAULT 'ascending' NOT NULL
    	
    ALTER TABLE tl_module CHANGE cal_ctemplate cal_ctemplate VARCHAR(64) DEFAULT 'cal_default' NOT NULL
    	
    ALTER TABLE tl_module CHANGE cal_template cal_template VARCHAR(64) DEFAULT 'event_full' NOT NULL
    	
    ALTER TABLE tl_module CHANGE cal_order cal_order VARCHAR(32) DEFAULT 'ascending' NOT NULL
    	
    ALTER TABLE tl_module CHANGE cal_format cal_format VARCHAR(32) DEFAULT 'cal_month' NOT NULL
    	
    ALTER TABLE tl_module CHANGE numberOfItems numberOfItems SMALLINT UNSIGNED DEFAULT 3 NOT NULL
    	
    ALTER TABLE tl_module CHANGE rss_template rss_template VARCHAR(64) DEFAULT 'rss_default' NOT NULL
    	
    ALTER TABLE tl_module CHANGE rss_cache rss_cache INT UNSIGNED DEFAULT 3600 NOT NULL
    	
    ALTER TABLE tl_module CHANGE imgSize imgSize VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_module CHANGE inColumn inColumn VARCHAR(32) DEFAULT 'main' NOT NULL
    	
    ALTER TABLE tl_module CHANGE searchType searchType VARCHAR(32) DEFAULT 'simple' NOT NULL
    	
    ALTER TABLE tl_module CHANGE queryType queryType VARCHAR(32) DEFAULT 'and' NOT NULL
    	
    ALTER TABLE tl_module CHANGE type type VARCHAR(64) DEFAULT 'navigation' NOT NULL
    	
    ALTER TABLE tl_module CHANGE headline headline VARCHAR(255) DEFAULT 'a:2:{s:5:"value";s:0:"";s:4:"unit";s:2:"h2";}' NOT NULL
    	
    ALTER TABLE tl_news CHANGE source source VARCHAR(12) DEFAULT 'default' NOT NULL
    	
    ALTER TABLE tl_news CHANGE floating floating VARCHAR(12) DEFAULT 'above' NOT NULL
    	
    ALTER TABLE tl_news CHANGE time time INT DEFAULT 0 NOT NULL
    	
    ALTER TABLE tl_news CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_news_archive CHANGE sortOrder sortOrder VARCHAR(32) DEFAULT 'ascending' NOT NULL
    	
    ALTER TABLE tl_news_archive CHANGE notify notify VARCHAR(16) DEFAULT 'notify_admin' NOT NULL
    	
    ALTER TABLE tl_news_feed CHANGE maxItems maxItems SMALLINT UNSIGNED DEFAULT 25 NOT NULL
    	
    ALTER TABLE tl_news_feed CHANGE source source VARCHAR(32) DEFAULT 'source_teaser' NOT NULL
    	
    ALTER TABLE tl_news_feed CHANGE format format VARCHAR(32) DEFAULT 'rss' NOT NULL
    	
    ALTER TABLE tl_news_feed CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_newsletter CHANGE sender sender VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_newsletter CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_newsletter_channel CHANGE smtpuser senderName VARCHAR(128) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_page CHANGE mobilelayout clientCache INT UNSIGNED DEFAULT 0 NOT NULL
    	
    ALTER TABLE tl_page CHANGE redirect redirect VARCHAR(32) DEFAULT 'permanent' NOT NULL
    	
    ALTER TABLE tl_page CHANGE type type VARCHAR(64) DEFAULT 'regular' NOT NULL
    	
    ALTER TABLE tl_page CHANGE alias alias VARCHAR(255) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_search CHANGE filesize filesize DOUBLE PRECISION DEFAULT '0' NOT NULL
    	
    ALTER TABLE tl_search_index CHANGE word word VARCHAR(64) DEFAULT '' NOT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_style_sheet CHANGE media media VARCHAR(255) DEFAULT 'a:1:{i:0;s:3:"all";}' NOT NULL
    	
    ALTER TABLE tl_user CHANGE photo amg BLOB DEFAULT NULL
    	
    ALTER TABLE tl_user CHANGE inherit inherit VARCHAR(12) DEFAULT 'group' NOT NULL
    	
    ALTER TABLE tl_user CHANGE password password VARCHAR(255) 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 CHANGE username username VARCHAR(64) DEFAULT NULL COLLATE `utf8mb4_bin`
    	
    ALTER TABLE tl_version CHANGE editUrl editUrl TEXT DEFAULT NULL
    Spalten anlegen
    	Alle auswählen
    	
    CREATE INDEX alias ON tl_article (alias)
    	
    CREATE INDEX pid_start_stop_published_sorting ON tl_article (
      pid, start, stop, published, sorting
    )
    	
    CREATE INDEX alias ON tl_calendar_events (alias)
    	
    CREATE INDEX pid_start_stop_published ON tl_calendar_events (pid, start, stop, published)
    	
    CREATE INDEX alias ON tl_calendar_feed (alias)
    	
    CREATE INDEX published ON tl_comments (published)
    	
    CREATE INDEX source_parent_published ON tl_comments (source, parent, published)
    	
    CREATE INDEX tokenremove ON tl_comments_notify (tokenremove)
    	
    CREATE INDEX pid_ptable_invisible_sorting ON tl_content (pid, ptable, invisible, sorting)
    	
    CREATE INDEX path ON tl_files (
      path(768)
    )
    	
    ALTER TABLE tl_form ADD customTpl VARCHAR(64) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_form_field ADD maxval VARCHAR(10) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_form_field ADD minval VARCHAR(10) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_image_size ADD formats VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_image_size ADD cssClass VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_layout ADD orderExtJs BLOB DEFAULT NULL
    	
    ALTER TABLE tl_layout ADD lightboxSize VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_member ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_member ADD secret BINARY(128) DEFAULT NULL
    	
    ALTER TABLE tl_module ADD cal_hideRunning CHAR(1) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_module ADD nl_text TEXT DEFAULT NULL
    	
    ALTER TABLE tl_news ADD orderEnclosure BLOB DEFAULT NULL
    	
    ALTER TABLE tl_news ADD imageTitle VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_news ADD description TEXT DEFAULT NULL
    	
    ALTER TABLE tl_news ADD pageTitle VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_newsletter_channel ADD sender VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_newsletter_channel ADD template VARCHAR(32) DEFAULT 'mail_default' NOT NULL
    	
    CREATE INDEX active ON tl_newsletter_recipients (active)
    	
    ALTER TABLE tl_page ADD twoFactorJumpTo INT UNSIGNED DEFAULT 0 NOT NULL
    	
    ALTER TABLE tl_page ADD enforceTwoFactor CHAR(1) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_page ADD requireItem CHAR(1) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_page ADD alwaysLoadFromCache CHAR(1) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_page ADD validAliasCharacters VARCHAR(255) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_page ADD redirectBack CHAR(1) DEFAULT '' NOT NULL
    	
    CREATE INDEX type_dns ON tl_page (type, dns)
    	
    ALTER TABLE tl_user ADD useTwoFactor CHAR(1) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_user ADD secret BINARY(128) DEFAULT NULL
    	
    ALTER TABLE tl_user ADD fullscreen CHAR(1) DEFAULT '' NOT NULL
    	
    ALTER TABLE tl_user_group ADD amg BLOB DEFAULT NULL

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

    Standard

    Du hast ein oder mehrere Extensions installiert, die tl_content um sehr viele bzw. große Felder erweitern. Dadurch wird in deiner MySQL Server Umgebung die Row Size zu groß.

    In manchen Fällen kann es aber helfen die Updates für tl_content nacheinander durchzuführen, anstatt alle auf einmal.

  3. #3
    Contao-Nutzer Avatar von truni
    Registriert seit
    18.08.2009.
    Ort
    Zürcher Unterland
    Beiträge
    166

    Frage

    Ja hatte in 3.5x Extensions drin und könnte diese evtl. VOR dem Installer-Update noch installieren in 4.9x
    Einzel-Updates der SQL-Statements hingegen stürzen schon bei den ersten ab bisher …

    botdection -> bugbuster/contao-botdetection-bundle
    dk_mmenu -> dklemmt/contao_dk_mmenu
    dlstats -> bugbuster/contao-dlstats-bundle
    xcontabackup (lass ich weg)

    Let's test …

    NOPE: leider lassen sich die drei ersten zwar installieren, aber danach kommt schon im Installer beim ersten einzelnen DB-Statement der Fehler. What do do?

    Code:
    [2020-05-26 16:04:36] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://cn4.domain.ch/contao/install","method":"POST"} []
    [2020-05-26 16:04:36] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC':  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline." at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC':\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []
    Geändert von truni (27.05.2020 um 08:09 Uhr)

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

    Standard

    Hast du das schon versucht?
    Zitat Zitat von Spooky Beitrag anzeigen
    In manchen Fällen kann es aber helfen die Updates für tl_content nacheinander durchzuführen, anstatt alle auf einmal.

  5. #5
    Contao-Nutzer Avatar von truni
    Registriert seit
    18.08.2009.
    Ort
    Zürcher Unterland
    Beiträge
    166

    Standard

    Zitat Zitat von Spooky Beitrag anzeigen
    Hast du das schon versucht?
    Ja, und schon beim ersten Statement gehts aber bereits nicht, stehe an. Scheint alles an der Grösse zu liegen der Inhalte?
    Code:
    ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    Fehler:
    Code:
    [2020-05-27 08:02:31] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://cn4.domain.ch/contao/install","method":"POST"} []
    [2020-05-27 08:02:31] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC':  SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline." at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'ALTER TABLE tl_content ENGINE = InnoDB ROW_FORMAT = DYNAMIC':\n\nSQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []

  6. #6
    Contao-Fan Avatar von Stefko
    Registriert seit
    25.10.2012.
    Ort
    Karlsruhe
    Beiträge
    771
    User beschenken
    Wunschliste

    Standard

    Und wenn Du bei diesem (ersten) Eintrag das Häkchen entfernst, laufen die anderen Änderungen dann durch?
    Grüße, Stefko

  7. #7
    Wandelndes Contao-Lexikon Avatar von tab
    Registriert seit
    22.10.2013.
    Beiträge
    10.060
    Contao-Projekt unterstützen

    Support Contao

    Standard

    Hmm, die maximale row size (8126) kommt mir arg niedrig vor, ist das normal?

  8. #8
    Contao-Nutzer Avatar von truni
    Registriert seit
    18.08.2009.
    Ort
    Zürcher Unterland
    Beiträge
    166

    Standard

    Zitat Zitat von Stefko Beitrag anzeigen
    Und wenn Du bei diesem (ersten) Eintrag das Häkchen entfernst, laufen die anderen Änderungen dann durch?
    Hauptproblem scheint dieser Befehl zu sein:
    Code:
    ALTER TABLE tl_article ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    Andere Updates spiele ich jetzt Schritt für Schritt durch …

    Unser Hoster meint:

    Sie können den Fehler temporär mit dieser Option umgehen:
    innodb_strict_mode=0
    ev. klappt dann die Umwandlung.

    Wie kann ich diesen Strict-Mode deaktivieren, in phpMyAdmin?

    Update: klappt leider auch nicht mit den Einzel-Schritten, dutzende analog des Screenshots. Installer ist jetzt ganz zu, kommt nur noch die Fehlerseite – im Log wiederum:
    Code:
    [2020-05-27 09:43:20] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://cn4.domain.ch/contao/install","method":"GET"} []
    [2020-05-27 09:43:20] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE UNIQUE INDEX pid_email ON tl_newsletter_recipients (pid, email)':  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes" at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 106 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE UNIQUE INDEX pid_email ON tl_newsletter_recipients (pid, email)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\\DBAL\\Driver\\PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/httpd/vhosts/domain.ch/subdomains/cn4/manager/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)"} []
    Angehängte Grafiken Angehängte Grafiken
    Geändert von truni (27.05.2020 um 09:50 Uhr)

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

    Standard

    Zitat Zitat von truni Beitrag anzeigen
    Hauptproblem scheint dieser Befehl zu sein:
    Code:
    ALTER TABLE tl_article ENGINE = InnoDB ROW_FORMAT = DYNAMIC
    Andere Updates spiele ich jetzt Schritt für Schritt durch …
    Ja, versuche zuerst mal die Updates für tl_content einzeln durchzuführen, exklusive diesem Update. Wenn es durch geht, versuche dieses Update dann am Schluss auszuführen.



    Zitat Zitat von truni Beitrag anzeigen
    Wie kann ich diesen Strict-Mode deaktivieren, in phpMyAdmin?
    Das macht man in der MySQL Server Konfiguration.

  10. #10
    Contao-Nutzer Avatar von truni
    Registriert seit
    18.08.2009.
    Ort
    Zürcher Unterland
    Beiträge
    166

    Standard

    Zitat Zitat von Spooky Beitrag anzeigen
    Ja, versuche zuerst mal die Updates für tl_content einzeln durchzuführen, exklusive diesem Update. Wenn es durch geht, versuche dieses Update dann am Schluss auszuführen.
    Das macht man in der MySQL Server Konfiguration.
    Danke für die Hilfe, aber wir müssen einen Stop machen für den Moment.
    Das Template würde nur auf 4.4 LTS laufen habe ich erfahren, das Downgrade klappt gerade nicht.

Aktive Benutzer

Aktive Benutzer

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

Lesezeichen

Lesezeichen

Berechtigungen

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