Hallo!
Auch ich habe heute ein Problem mit obigem Update.
Front- & Backend sind zwar problemlos erreichbar nur das DB-Update lässt sich nicht durchführen.
Folgende Fehlermeldungen werden erzeugt:
PHP-Code:
[2020-09-30 10:40:38] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE INDEX type_dns ON tl_page (type, dns)': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes" at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE INDEX type_dns ON tl_page (type, dns)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:96)"} []
PHP-Code:
[2020-09-30 10:46:06] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE UNIQUE INDEX url ON tl_search (url)': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes" at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE UNIQUE INDEX url ON tl_search (url)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:96)"} []
PHP-Code:
[2020-09-30 10:51:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)': SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes" at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 128 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occurred while executing 'CREATE UNIQUE INDEX pid_fromtable_version ON tl_version (pid, fromtable, version)':\n\nSQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes at /home/.sites/34/site5552689/web/aktuell/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:96)"} []
Wenn ich die jeweilige Tabelle beim DB-Update abwähle (wegklicke) kommt die jeweils nächste Fehlermeldung.
Also zuerst die Tabelle: CREATE INDEX type_dns ON tl_page
dann: CREATE UNIQUE INDEX url ON tl_search
und zuletzt: CREATE UNIQUE INDEX pid_fromtable_version
Wenn ich alle drei abwähle kommt zwar keine Fehlermeldung aber das DB-Update geht nicht weiter.
Wo kann ich 'drehen' um das Problem zu lösen?
Danke schon vorweg und schöne Grüße
Bernhard
Lesezeichen