Installtool nicht aufrufbar

[elwega]

Hallo,
sowas gabs schon mal, aber ich finde die Notiz dazu nicht mehr.
Contao 4.13.5
BE und FE funktionieren
Installtool Aufruf scheitert mit

Es ist ein Fehler aufgetreten

Im Log steht:

[2022-06-30T07:53:22.809866+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 1000 bytes" at /var/www/vhosts/domain.de/httpdocs/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 1000 bytes at /var/www/vhosts/domain.de/httpdocs/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 1000 bytes at /var/www/vhosts/domain.de/httpdocs/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 1000 bytes at /var/www/vhosts/domain.de/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

Das Stack Trace sagt:

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 1000 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/core-bundle/src/Migration/Version404/Version447Update.php:129)
at Contao\CoreBundle\Migration\Version404\Version447U pdate->run()
(vendor/contao/core-bundle/src/Migration/MigrationCollection.php:58)
at Contao\CoreBundle\Migration\MigrationCollection->run()
(vendor/contao/installation-bundle/src/InstallTool.php:427)
at Contao\InstallationBundle\InstallTool->runMigrations()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:361)
at Contao\InstallationBundle\Controller\InstallationC ontroller->runDatabaseUpdates()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:96)
at Contao\InstallationBundle\Controller\InstallationC ontroller->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)
at require('/var/www/vhosts/domainname.de/httpdocs/web/index.php')
(web/app.php:13)

Wer kann bitte helfen den Fehler weg zu bekommen?
Danke

[Spooky]

Wie sieht deine config.yaml aus?

[elwega]

Hallo und danke.

# config/config.yml
doctrine:
dbal:
connections:
default:
default_table_options:
charset: utf8
collate: utf8_unicode_ci
engine: InnoDB
options:
1002: "SET SESSION sql_mode=(SELECT CONCAT(@@sql_mode,',TRADITIONAL'))"

[Spooky]

Entferne mal diese Angaben alle.

[elwega]

phpMyAdmin: unter Typ steht bei allen Einträgen MyISAM
als letzter Eintrag aber:

67 Tabellen Gesamt 13.422 InnoDB utf8_general_ci 2,5 MiB

[elwega]

ok config.yml habe ich gelöscht
Prod Cache gelöscht
Installtool Aufruf scheitert

[elwega]

Nochmal das aktualisierte dreiteilige Stack Trace
Teil 1

[1/3] PDOException

PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34
at PDO->exec()
(vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)
at Doctrine\DBAL\Driver\PDO\Connection->exec()
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->exec()
(vendor/doctrine/dbal/src/Logging/Connection.php:53)
at Doctrine\DBAL\Logging\Connection->exec()
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->exec()
(vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
at Symfony\Bridge\Doctrine\Middleware\Debug\Connectio n->exec()
(vendor/doctrine/dbal/src/Connection.php:1161)
at Doctrine\DBAL\Connection->executeStatement()
(vendor/contao/core-bundle/src/Migration/Version404/Version447Update.php:129)
at Contao\CoreBundle\Migration\Version404\Version447U pdate->run()
(vendor/contao/core-bundle/src/Migration/MigrationCollection.php:58)
at Contao\CoreBundle\Migration\MigrationCollection->run()
(vendor/contao/installation-bundle/src/InstallTool.php:427)
at Contao\InstallationBundle\InstallTool->runMigrations()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:361)
at Contao\InstallationBundle\Controller\InstallationC ontroller->runDatabaseUpdates()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:96)
at Contao\InstallationBundle\Controller\InstallationC ontroller->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)
at require('/var/www/vhosts/domain.de/httpdocs/web/index.php')
(web/app.php:13)

Teil 2 [2/3] DriverException

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30
at Doctrine\DBAL\Driver\PDO\Exception::new()
(vendor/doctrine/dbal/src/Driver/PDO/Connection.php:40)
at Doctrine\DBAL\Driver\PDO\Connection->exec()
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->exec()
(vendor/doctrine/dbal/src/Logging/Connection.php:53)
at Doctrine\DBAL\Logging\Connection->exec()
(vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
at Doctrine\DBAL\Driver\Middleware\AbstractConnection Middleware->exec()
(vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
at Symfony\Bridge\Doctrine\Middleware\Debug\Connectio n->exec()
(vendor/doctrine/dbal/src/Connection.php:1161)
at Doctrine\DBAL\Connection->executeStatement()
(vendor/contao/core-bundle/src/Migration/Version404/Version447Update.php:129)
at Contao\CoreBundle\Migration\Version404\Version447U pdate->run()
(vendor/contao/core-bundle/src/Migration/MigrationCollection.php:58)
at Contao\CoreBundle\Migration\MigrationCollection->run()
(vendor/contao/installation-bundle/src/InstallTool.php:427)
at Contao\InstallationBundle\InstallTool->runMigrations()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:361)
at Contao\InstallationBundle\Controller\InstallationC ontroller->runDatabaseUpdates()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:96)
at Contao\InstallationBundle\Controller\InstallationC ontroller->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)
at require('/var/www/vhosts/domain.de/httpdocs/web/index.php')
(web/app.php:13)

Teil 3

[3/3] DriverException

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 1000 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/core-bundle/src/Migration/Version404/Version447Update.php:129)
at Contao\CoreBundle\Migration\Version404\Version447U pdate->run()
(vendor/contao/core-bundle/src/Migration/MigrationCollection.php:58)
at Contao\CoreBundle\Migration\MigrationCollection->run()
(vendor/contao/installation-bundle/src/InstallTool.php:427)
at Contao\InstallationBundle\InstallTool->runMigrations()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:361)
at Contao\InstallationBundle\Controller\InstallationC ontroller->runDatabaseUpdates()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:96)
at Contao\InstallationBundle\Controller\InstallationC ontroller->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)
at require('/var/www/vhosts/domain.de/httpdocs/web/index.php')
(web/app.php:13)

[Spooky]

Hast du eine DCA Anpassung für tl_newsletter_recipients?

[elwega]

hallo Spooky,
nicht das ich wüsste?

[elwega]

Weitere Maßnahmen zur Fehlereingrenzung.
Backup der DB eingespielt.
Installtool aufrufbar mit 2 Änderungen.
Nach dem Aktivieren Fehlermeldung und Installtool weg.
Im Log steht:

[2022-06-30T16:05:49.375758+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: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8'" at /var/www/vhosts/domain.de/httpdocs/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 119 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1253): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8' at /var/www/vhosts/domain.de/httpdocs/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1253): SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8' at /var/www/vhosts/domain.de/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8mb4_unicode_ci' is not valid for CHARACTER SET 'utf8' at /var/www/vhosts/domain.de/httpdocs/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

Das Stack Trace nur noch ein Hinweis:

ErrorException:
Warning: Undefined array key "tl_nc_message"

at vendor/contao/core-bundle/src/Resources/contao/library/Contao/DcaExtractor.php:459
at Contao\DcaExtractor->createExtract()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/DcaExtractor.php:126)
at Contao\DcaExtractor->__construct()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/DcaExtractor.php:148)
at Contao\DcaExtractor::getInstance()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Installer.php:283)
at Contao\Database\Installer->getFromDca()
(vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:315)
at Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvide r->getSqlDefinitions()
(vendor/contao/core-bundle/src/Doctrine/Schema/DcaSchemaProvider.php:55)
at Contao\CoreBundle\Doctrine\Schema\DcaSchemaProvide r->appendToSchema()
(vendor/contao/core-bundle/src/EventListener/DoctrineSchemaListener.php:35)
at Contao\CoreBundle\EventListener\DoctrineSchemaList ener->postGenerateSchema()
(vendor/symfony/doctrine-bridge/ContainerAwareEventManager.php:68)
at Symfony\Bridge\Doctrine\ContainerAwareEventManager->dispatchEvent()
(vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php:409)
at Doctrine\ORM\Tools\SchemaTool->getSchemaFromMetadata()
(vendor/contao/core-bundle/src/Doctrine/Schema/SchemaProvider.php:37)
at Contao\CoreBundle\Doctrine\Schema\SchemaProvider->createSchema()
(vendor/contao/installation-bundle/src/Database/Installer.php:112)
at Contao\InstallationBundle\Database\Installer->compileCommands()
(vendor/contao/installation-bundle/src/Database/Installer.php:43)
at Contao\InstallationBundle\Database\Installer->getCommands()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:374)
at Contao\InstallationBundle\Controller\InstallationC ontroller->adjustDatabaseTables()
(vendor/contao/installation-bundle/src/Controller/InstallationController.php:100)
at Contao\InstallationBundle\Controller\InstallationC ontroller->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)

Die beiden DB Einträge:

ALTER TABLE tl_member_to_group CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci

ALTER TABLE tl_user_to_group CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci

Vieleicht hilft das weiter?
Update etwas später und try and error
Händisch die Tabellen angepasst, dh. Kollation und Engine danach funktioniert das Installtool wie es soll.
Hat leider viel Zeit gekostet weil ich anfangs keine Ahnung hatte wo zu suchen ist.
Danke Spooky für die Hinweise