Contao 4.6, Datenbankupdate bei hosteurope Basic klappt nicht
Hallo,
ich habe heute bei einem Kunden ein neues Contao 4.6 installiert. Soweit lief alles ohne Probleme allerdings lässt sich Contao nicht mit der Datenbank verbinden. Genauer gesagt, ich bekomme eine Fehlermeldung, wenn ich die Tabellen aktualisieren will. Es handelt sich wie gesagt um eine frische Installation ohne vorherige Inhalte oder Update etc. Ich habe mehrere Kunden bei denen das bei hosteurope ohne Probleme klappt, jedoch alles im Medium Paket. Die aktuell laufende MySQL Version ist 5.6.38-83.0-log. PHP ist 7.2. In der Logdatei steht folgende Fehlermeldung, weiss vielleicht jemand wo ich da ansetzen kann, ich habe zwar einige Sachen gegoogelt, auch hier im Forum was gefunden, allerdings bringt mich das nicht weiter:
HTML-Code:
[2018-12-25 17:26:27] 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":"http://www.meine-webseite.de/contao/install","method":"POST"} []
[2018-12-25 17:26:28] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE TABLE tl_newsletter_recipients (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, active CHAR(1) DEFAULT '' NOT NULL, addedOn VARCHAR(10) DEFAULT '' NOT NULL, confirmed VARCHAR(10) DEFAULT '' NOT NULL, ip VARCHAR(64) DEFAULT '' NOT NULL, token VARCHAR(32) DEFAULT '' NOT NULL, UNIQUE INDEX pid_email (pid, email), INDEX email (email(191)), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes" at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/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 TABLE tl_newsletter_recipients (id INT UNSIGNED AUTO_INCREMENT NOT NULL, pid INT UNSIGNED DEFAULT 0 NOT NULL, tstamp INT UNSIGNED DEFAULT 0 NOT NULL, email VARCHAR(255) DEFAULT '' NOT NULL, active CHAR(1) DEFAULT '' NOT NULL, addedOn VARCHAR(10) DEFAULT '' NOT NULL, confirmed VARCHAR(10) DEFAULT '' NOT NULL, ip VARCHAR(64) DEFAULT '' NOT NULL, token VARCHAR(32) DEFAULT '' NOT NULL, UNIQUE INDEX pid_email (pid, email), INDEX email (email(191)), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ENGINE = InnoDB ROW_FORMAT = DYNAMIC':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/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 767 bytes at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []
[2018-12-25 17:26:28] request.INFO: Matched route "contao_catch_all". {"route":"contao_catch_all","route_parameters":{"_route":"contao_catch_all","_scope":"frontend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_url_fragment":"favicon.ico"},"request_uri":"http://www.meine-webseite.de/favicon.ico","method":"HEAD"} []
[2018-12-25 17:26:28] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2018-12-25 17:26:29] request.INFO: Matched route "contao_catch_all". {"route":"contao_catch_all","route_parameters":{"_route":"contao_catch_all","_scope":"frontend","_token_check":true,"_controller":"Contao\\CoreBundle\\Controller\\FrontendController::indexAction","_url_fragment":"favicon.ico"},"request_uri":"http://www.meine-webseite.de/favicon.ico","method":"GET"} []
[2018-12-25 17:26:29] security.INFO: Populated the TokenStorage with an anonymous Token. [] []
[2018-12-25 17:26:29] request.ERROR: Uncaught PHP Exception Symfony\Component\HttpKernel\Exception\NotFoundHttpException: "Page not found: http://www.meine-webseite.de/favicon.ico" at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php line 96 {"exception":"[object] (Symfony\\Component\\HttpKernel\\Exception\\NotFoundHttpException(code: 0): Page not found: [url]http://www.meine-webseite.de/favicon.ico[/url] at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/contao/core-bundle/src/EventListener/ExceptionConverterListener.php:96, Contao\\CoreBundle\\Exception\\PageNotFoundException(code: 0): Page not found: [url]http://www.meine-webseite.de/favicon.ico[/url] at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:67)"} []
[2018-12-25 17:26:29] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\TableNotFoundException: "An exception occurred while executing 'SELECT sitemapName FROM tl_page WHERE type='root' AND createSitemap=1 AND sitemapName!=''': SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12192771-bk.tl_page' doesn't exist" at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 42 {"exception":"[object] (Doctrine\\DBAL\\Exception\\TableNotFoundException(code: 0): An exception occurred while executing 'SELECT sitemapName FROM tl_page WHERE type='root' AND createSitemap=1 AND sitemapName!=''':\n\nSQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12192771-bk.tl_page' doesn't exist at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:42, Doctrine\\DBAL\\Driver\\PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12192771-bk.tl_page' doesn't exist at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:90, PDOException(code: 42S02): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db12192771-bk.tl_page' doesn't exist at /is/htdocs/wp12192771_EJ4GJZXTXR/www/webpage2019/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:88)"} []
Danke für Tipps