4.13.x Contao und MariaDB

Contao und MariaDB

Hallo zusammen,

ich musste das erste mal Contao auf einen server mit MariaDB installieren bzw. eine bestehende Installation von Mysql auf MariabDB umgezogen. An sich läuft die Seite nur geht die Vorschau nicht. Hier lande ich wieder auf dem Backend Login. Somit kann ich auch den Debug Modus nicht verwenden. Folgender Fehler ist im Systemlog.

Was muss ich bei MariaDB beachten?

Code:

[2022-05-08T11:56:34.635233+02:00] 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://tmp.oberhammer-jagd.de/contao/install","method":"POST"} [] [2022-05-08T11:56:35.953920+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes" at /home/users/xxx/www/xxx/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 119 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1071): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /home/users/xxx/www/xxx/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1071): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /home/users/xxx/www/xxxxx/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at /home/users/xxxx/www/xxx/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

Contao 4.13.4
Server-Version: 10.1.48-MariaDB-0ubuntu0.18.04.1 - Ubuntu 18.04
PHP 7.4

VG Frank

Nutze den Debug-Modus und poste den Stack Trace.

Edit:
API MYSQL ist ja eigentlich falsch...ist ne MariaDB? Muss ich das nirgends angeben?

Code:

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119 at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert() (vendor/doctrine/dbal/src/Connection.php:1814) at Doctrine\DBAL\Connection->handleDriverException() (vendor/doctrine/dbal/src/Connection.php:1749) at Doctrine\DBAL\Connection->convertExceptionDuringQuery() (vendor/doctrine/dbal/src/Connection.php:1163) at Doctrine\DBAL\Connection->executeStatement() (vendor/contao/installation-bundle/src/Database/Installer.php:84) at Contao\InstallationBundle\Database\Installer->execCommand() (vendor/contao/installation-bundle/src/Controller/InstallationController.php:390) at Contao\InstallationBundle\Controller\InstallationController->adjustDatabaseTables() (vendor/contao/installation-bundle/src/Controller/InstallationController.php:100) at Contao\InstallationBundle\Controller\InstallationController->installAction() (vendor/symfony/http-kernel/HttpKernel.php:152) at Symfony\Component\HttpKernel\HttpKernel->handleRaw() (vendor/symfony/http-kernel/HttpKernel.php:74) at Symfony\Component\HttpKernel\HttpKernel->handle() (vendor/symfony/http-kernel/Kernel.php:202) at Symfony\Component\HttpKernel\Kernel->handle() (web/index.php:44)

composer.json

Code:

{ "name": "contao/managed-edition", "type": "project", "description": "Contao Open Source CMS", "license": "LGPL-3.0-or-later", "authors": [ { "name": "Leo Feyer", "homepage": "https://github.com/leofeyer" } ], "require": { "cboelter/contao-lead-optin": "^1.3", "codefog/contao-cookiebar": "^2.1", "contao-bootstrap/core": "^2.0", "contao-bootstrap/grid": "^2.3", "contao-bootstrap/layout": "^2.0", "contao-bootstrap/navbar": "^2.1", "contao/conflicts": "*@dev", "contao/faq-bundle": "4.13.*", "contao/listing-bundle": "4.13.*", "contao/manager-bundle": "4.13.*", "do-while/contao-backupdb-bundle": "^1.4", "jrgregory/m17-sticky-backend-footer": "^2.0", "madeyourday/contao-rocksolid-frontend-helper": "^2.1", "netzmacht/contao-font-awesome-inserttag": "^2.0", "oveleon/contao-cookiebar": "^1.10", "terminal42/contao-ajaxform": "^1.1", "terminal42/contao-easy_themes": "^2.2", "terminal42/contao-leads": "^1.4", "terminal42/notification_center": "^1.4", "w3scout/contao-searchfaq-bundle": "^1.0", "wr/onepage-bundle": "^2.0" }, "config": { "component-dir": "assets" }, "extra": { "branch-alias": { "dev-4.5": "4.5.x-dev" } }, "conflict": { "heimrichhannot/contao-utils-bundle": "<2.188.10", "menatwork/contao-multicolumnwizard-bundle": "<3.4.11" }, "scripts": { "post-install-cmd": [ "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication" ], "post-update-cmd": [ "Contao\\ManagerBundle\\Composer\\ScriptHandler::initializeApplication" ] } }

Für welchen Query passiert dieser Fehler?

Zitat:

Zitat von Kahmoon

API MYSQL ist ja eigentlich falsch...ist ne MariaDB?

MariaDB ist ein drop-in replacement für MySQL

Nach der Installation auf dem neuen Server und DB Aktualisierung im Installtool. Der rest ist abgearbeitet aber dieses Query mag nicht.

Du hast den Query nicht gepostet.

Hier:

Code:

CREATE UNIQUE INDEX url ON tl_search (url)

Aber die Ursache ist dann wohl innodb_large_prefix. Ich frage den Hoster.

Problem ist gelöst. Ursache wie vermutet.