4.13.5 nach Update Fehler im Installtool

**DatGruen** · 11.06.2022, 13:22

Hi,
nach dem Update auf 4.13.5 bekomme ich eine Fehlermeldung im Instlltool, schaue ich in die Logs:

Code:

[2022-06-11T14:05:03.175714+02:00] request.CRITICAL: Uncaught PHP Exception TypeError: "substr() expects parameter 1 to be string, bool given" at /www/htdocs/xxx/vendor/contao/core-bundle/src/Migration/Version413/RelLightboxMigration.php line 96 {"exception":"[object] (TypeError(code: 0): substr() expects parameter 1 to be string, bool given at /www/xxx/vendor/contao/core-bundle/src/Migration/Version413/RelLightboxMigration.php:96)"} []

Im Stack Trace steht Folgendes:

Code:

TypeError:
substr() expects parameter 1 to be string, bool given

  at vendor/contao/core-bundle/src/Migration/Version413/RelLightboxMigration.php:96
  at substr(false, 0, 4)
     (vendor/contao/core-bundle/src/Migration/Version413/RelLightboxMigration.php:96)
  at Contao\CoreBundle\Migration\Version413\RelLightboxMigration->getTargets()
     (vendor/contao/core-bundle/src/Migration/Version413/RelLightboxMigration.php:39)
  at Contao\CoreBundle\Migration\Version413\RelLightboxMigration->shouldRun()
     (vendor/contao/core-bundle/src/Migration/MigrationCollection.php:36)
  at Contao\CoreBundle\Migration\MigrationCollection->getPending()
     (vendor/contao/core-bundle/src/Migration/MigrationCollection.php:57)
  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\InstallationController->runDatabaseUpdates()
     (vendor/contao/installation-bundle/src/Controller/InstallationController.php:96)
  at Contao\InstallationBundle\Controller\InstallationController->installAction()
     (vendor/symfony/http-kernel/HttpKernel.php:152)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

meine config.yml ist quasi jungfräulich, da steht außer:

Code:

contao:
    url_suffix: ""

nichts drin.
Wo kann ich ansetzten oder einfach warten auf das nächste Update? Da die Seite noch in der Entwicklung ist, drängt das Thema jetzt nicht so :-)

**Spooky** · 11.06.2022, 13:34

In einem DCA von dir hast du irgendwo

PHP-Code:


'eval' => ['rte' => true]

stehen, was falsch ist. Das müsste bspw.

PHP-Code:


'eval' => ['rte' => 'tinyMCE']

heißen. Kann aber auch von einer Extension kommen.

**DatGruen** · 11.06.2022, 13:44

Ok dann begebe ich mich mal auf die Suche... da ich diesmal selbst nichts modifiziert habe, wird es wohl etwas dauern

**DatGruen** · 27.06.2022, 08:15

Nach langen Suchen bin ich leider nicht fündig geworden. Ein Rollback auf die Version 4.13.4 hat dann den Fehler behoben.

**Spooky** · 27.06.2022, 08:38

Aktualisiere auf Contao 4.13.5 und ändere in vendor\contao\contao\core-bundle\src\Migration\Version413\RelLightboxMigration.php die Zeile 96 auf

PHP-Code:


                if (0 === strpos((string) ($fieldConfig['eval']['rte'] ?? ''), 'tiny')) {

und teste dann nochmal.

**Spooky** · 27.06.2022, 10:27

https://github.com/contao/contao/pull/4878

**DatGruen** · 27.06.2022, 12:25

Fehler Nr.1 ist damit behoben. Das Installtool öffnet sich wieder, es werden drei ALTER Befehle angezeigt.
install.jpg

Führe ich die Befehle aus, läuft es wieder auf einen Fehler:

Code:

[2022-06-27T13:20:41.242169+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 /www/htdocs/w016f8b2/xxx.de/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 /www/htdocs/w016f8b2/xxx.de/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 /www/htdocs/w016f8b2/hsg08.toellich-webentwicklung.de/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 /www/htdocs/w016f8b2/xxx.de/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

Trace:

Code:

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 vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:119
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1814)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
     (vendor/doctrine/dbal/src/Connection.php:1749)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'ALTER TABLE tl_member_to_group CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:1163)
  at Doctrine\DBAL\Connection->executeStatement('ALTER TABLE tl_member_to_group CONVERT TO CHARACTER SET utf8 COLLATE utf8mb4_unicode_ci')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('de64ec6dfb69d7fa13f79877896759c7')
     (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(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:74)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:44)

Ich teste nachher noch bissel rum.