Duplikat von 4.4 auf 4.9 - kein Datenbank-Update möglich

**smeyli** · 28.03.2023, 08:34

Ich habe hier eine ziemlich widerspenstige Vereinsseite in Bearbeitung und wollte von dieser Seite mal ein Duplikat erstellen.
Die Ursprungsseite ist in 4.4.x und die neue sollte erstmal in.4.9.x sein.

Nachdem das System erstellt, alles Wichtige kopiert ist, wollte der Manager mal ein DB-Scheme Update machen, doch daran scheitert es einfach immer wieder.
Besonderheit: Es ist ein Seamedia Theme (X4 ...) verbaut. Doch das sollte doch für die Installation erstmal kein Problem sein...

Im Logfile steht folgendes:

Code:

[2023-03-28 09:14:08] 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://__#####PATH#####__/contao/install","method":"POST"} []
[2023-03-28 09:14:08] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing 'CREATE INDEX path ON tl_files (path(768))':  SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path'" at /www/htdocs/__#####PATH#####__/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 path ON tl_files (path(768))':\n\nSQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /www/htdocs/__#####PATH#####__/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:128, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /www/htdocs/__#####PATH#####__/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'path' at /www/htdocs/__#####PATH#####__/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)"} []

Es scheint (nach meiner Einschätzung) irgendwas mit den Zugriffsrechten nicht zu stimmen...
Kann mir jemand einen kleinen Tipp geben?

**Spooky** · 28.03.2023, 08:38

Die tl_files Tabelle ist kaputt. Lösche mal alle Indexes der tl_files Tabelle manuell.

**mlweb** · 28.03.2023, 09:22

Zitat von smeyli

Besonderheit: Es ist ein Seamedia Theme (X4 ...) verbaut.

Seamedia ist doch PCT - da habe ich bei Updates schon alles mögliche erlebt.

**smeyli** · 28.03.2023, 10:29

Zitat von Spooky

Die tl_files Tabelle ist kaputt. Lösche mal alle Indexes der tl_files Tabelle manuell.

Wie stelle ich das an? (hab ich noch nie gebraucht)

Code:

DROP INDEX * ON 'tl_files';

oder

Code:

ALTER TABLE 'tl_files' DROP INDEX *;

**Spooky** · 28.03.2023, 10:42

Am besten über ein SQL Tool deiner Wahl.

**smeyli** · 28.03.2023, 12:41

Zitat von Spooky

Am besten über ein SQL Tool deiner Wahl.

Ich bin heute etwas "bluna" - frei nach dem Motto: "Starte mal den Motor des Autos!" - "Was ist ein Auto?"

Hat natürlich alles funktioniert und ich hangele mich mal vor zu der nächsten fehlerhaften Tabelle...

Code:

ALTER TABLE tl_search_index ADD PRIMARY KEY (id)
ALTER TABLE tl_search_index ADD id INT UNSIGNED AUTO_INCREMENT NOT NULL

Das gab natürlich auch eine Fehlermeldung (Spalte "id" existiert nicht). Die Spalte habe ich dann auch von manuell angelegt - dann konnte das Installtool arbeiten...

Doch nun kommt der knifflige Teil...

Das Installtool will nun folgende Spalten ändern:

Code:

ALTER TABLE `cc_directory` CHANGE `ptable` `ptable` varchar(64) NOT NULL default '';	
ALTER TABLE `cc_directory` CHANGE `item_number` `item_number` varchar(255) NOT NULL default '';	
ALTER TABLE `cc_directory` CHANGE `name` `name` varchar(255) NOT NULL default '';	
...

Aber es werden ja nur tabellen mit tl_* berücksichtigt.

Die Tabelle "cc_directory" existiert und ist gefüllt. Da muss doch nix geändert werden...

Doch irgendwo hängt's noch, denn nach einem Login ins Backend zerschießt es das Menü von dem CC Katalog, vom Frontend ganz zu schweigen...

und das Logfile sagt

Code:

request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\InvalidFieldNameException: "An exception occurred while executing 'SELECT * FROM tl_news_archive WHERE id IN(1) AND manualSorting=1':  SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause'" at /www/htdocs/__#####PATH#####__/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 79 {"exception":"[object] (Doctrine\\DBAL\\Exception\\InvalidFieldNameException(code: 0): An exception occurred while executing 'SELECT * FROM tl_news_archive WHERE id IN(1) AND manualSorting=1':\n\nSQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /www/htdocs/__#####PATH#####__/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:79, Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /www/htdocs/__#####PATH#####__/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18, PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'manualSorting' in 'where clause' at /www/htdocs/__#####PATH#####__/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:141)"} []

Spalte "manualSorting" in "tl_news_archive" existiertiert nicht.

Wo kommt denn diese Spalte her? Die ist ja kein Standard, oder?

**Spooky** · 28.03.2023, 12:43

Zitat von smeyli

Wo kommt denn diese Spalte her? Die ist ja kein Standard, oder?

Ja, ist kein Standard und daher kannst es nur du wissen, da es deine Contao Installation ist

. Über den Debug-Modus findest du über den Stack Trace möglicherweise mehr heraus.

**smeyli** · 28.03.2023, 13:29

Ich habe die Lösung hier gefunden:
https://community.contao.org/de/show...ste-sql-Fehler

Es lag an der Erweiterung "pct_autogrid"...

Danke für Deine Hilfe / Impulse.

**smeyli** · 28.03.2023, 16:07

Leider gibt es immernoch Probleme mit der Seite...

Heute werden die Haare wieder etwas grauer...

Frontend und Backend laufen - bis auf diesen PCT CustomCatalog. Alle Backend-Menüs und Module, die damit zu tun haben, verursachen Fehlermeldungen.
Wenn ich richtig informiert bin, muss die Website-URL wohl bei PCT hinterlegt sein, damit das Template funktioniert. Das wurde auch erledigt...
Könnte es sein, dass die Verbindung nicht funktioniert oder irgendwo noch eine "Erlaubnis" erforderlich ist? So würde ich jedenfalls (mal vorsichtig) den Stack trace interpretieren...

Stack Trace

Code:

Doctrine\DBAL\Exception\ConnectionException:
An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:112
  at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user \'root\'@\'localhost\' (using password: NO)', object(Exception))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:182)
  at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(Exception), 'An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user \'root\'@\'localhost\' (using password: NO)')
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169)
  at Doctrine\DBAL\DBALException::driverException(object(Driver), object(Exception))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:31)
  at Doctrine\DBAL\Driver\PDOMySql\Driver->connect(array('driver' => 'pdo_mysql', 'url' => 'pdo-mysql://localhost:3306', 'charset' => 'utf8mb4', 'host' => 'localhost', 'port' => 3306, 'user' => 'root', 'password' => null, 'driverOptions' => array(false), 'defaultTableOptions' => array('charset' => 'utf8mb4', 'collate' => 'utf8mb4_unicode_ci', 'engine' => 'InnoDB', 'row_format' => 'DYNAMIC')), 'root', null, array(false))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:980)
  at Doctrine\DBAL\Connection->quote('____________PATH____________')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:319)
  at Contao\Database\Statement->escapeParams(array('____________PATH____________'))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:295)
  at Contao\Database\Statement->replaceWildcards(array('____________PATH____________'))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:246)
  at Contao\Database\Statement->execute('____________PATH____________')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:1077)
  at Contao\Model::find(array('column' => array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), 'value' => '____________PATH____________', 'return' => 'Collection', 'table' => 'tl_page', 'limit' => 0, 'offset' => 0))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:948)
  at Contao\Model::findBy(array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), '____________PATH____________')
     (vendor/contao/core-bundle/src/Framework/Adapter.php:44)
  at Contao\CoreBundle\Framework\Adapter->__call('findBy', array(array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), '____________PATH____________'))
     (vendor/contao/core-bundle/src/Routing/RouteProvider.php:533)
  at Contao\CoreBundle\Routing\RouteProvider->findRootPages('____________PATH____________')
     (vendor/contao/core-bundle/src/Routing/RouteProvider.php:70)
  at Contao\CoreBundle\Routing\RouteProvider->getRouteCollectionForRequest(object(Request))
     (vendor/contao/core-bundle/src/Routing/LegacyRouteProvider.php:43)
  at Contao\CoreBundle\Routing\LegacyRouteProvider->getRouteCollectionForRequest(object(Request))
     (vendor/symfony-cmf/routing/src/NestedMatcher/NestedMatcher.php:140)
  at Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest(object(Request))
     (vendor/contao/core-bundle/src/Routing/Matcher/LegacyMatcher.php:69)
  at Contao\CoreBundle\Routing\Matcher\LegacyMatcher->matchRequest(object(Request))
     (vendor/symfony-cmf/routing/src/DynamicRouter.php:272)
  at Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest(object(Request))
     (vendor/symfony-cmf/routing/src/ChainRouter.php:188)
  at Symfony\Cmf\Component\Routing\ChainRouter->doMatch('/', object(Request))
     (vendor/symfony-cmf/routing/src/ChainRouter.php:158)
  at Symfony\Cmf\Component\Routing\ChainRouter->matchRequest(object(Request))
     (vendor/symfony/http-kernel/EventListener/RouterListener.php:112)
  at Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:126)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:264)
  at Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:239)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:73)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:168)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/http-kernel/HttpKernel.php:145)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:81)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:31)

Code:

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:44)
  at Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=localhost;port=3306;charset=utf8mb4;', 'root', null, array(false))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:25)
  at Doctrine\DBAL\Driver\PDOMySql\Driver->connect(array('driver' => 'pdo_mysql', 'url' => 'pdo-mysql://localhost:3306', 'charset' => 'utf8mb4', 'host' => 'localhost', 'port' => 3306, 'user' => 'root', 'password' => null, 'driverOptions' => array(false), 'defaultTableOptions' => array('charset' => 'utf8mb4', 'collate' => 'utf8mb4_unicode_ci', 'engine' => 'InnoDB', 'row_format' => 'DYNAMIC')), 'root', null, array(false))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:980)
  at Doctrine\DBAL\Connection->quote('____________PATH____________')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:319)
  at Contao\Database\Statement->escapeParams(array('____________PATH____________'))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:295)
  at Contao\Database\Statement->replaceWildcards(array('____________PATH____________'))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:246)
  at Contao\Database\Statement->execute('____________PATH____________')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:1077)
  at Contao\Model::find(array('column' => array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), 'value' => '____________PATH____________', 'return' => 'Collection', 'table' => 'tl_page', 'limit' => 0, 'offset' => 0))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:948)
  at Contao\Model::findBy(array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), '____________PATH____________')
     (vendor/contao/core-bundle/src/Framework/Adapter.php:44)
  at Contao\CoreBundle\Framework\Adapter->__call('findBy', array(array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), '____________PATH____________'))
     (vendor/contao/core-bundle/src/Routing/RouteProvider.php:533)
  at Contao\CoreBundle\Routing\RouteProvider->findRootPages('____________PATH____________')
     (vendor/contao/core-bundle/src/Routing/RouteProvider.php:70)
  at Contao\CoreBundle\Routing\RouteProvider->getRouteCollectionForRequest(object(Request))
     (vendor/contao/core-bundle/src/Routing/LegacyRouteProvider.php:43)
  at Contao\CoreBundle\Routing\LegacyRouteProvider->getRouteCollectionForRequest(object(Request))
     (vendor/symfony-cmf/routing/src/NestedMatcher/NestedMatcher.php:140)
  at Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest(object(Request))
     (vendor/contao/core-bundle/src/Routing/Matcher/LegacyMatcher.php:69)
  at Contao\CoreBundle\Routing\Matcher\LegacyMatcher->matchRequest(object(Request))
     (vendor/symfony-cmf/routing/src/DynamicRouter.php:272)
  at Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest(object(Request))
     (vendor/symfony-cmf/routing/src/ChainRouter.php:188)
  at Symfony\Cmf\Component\Routing\ChainRouter->doMatch('/', object(Request))
     (vendor/symfony-cmf/routing/src/ChainRouter.php:158)
  at Symfony\Cmf\Component\Routing\ChainRouter->matchRequest(object(Request))
     (vendor/symfony/http-kernel/EventListener/RouterListener.php:112)
  at Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:126)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:264)
  at Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:239)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:73)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:168)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/http-kernel/HttpKernel.php:145)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:81)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:31)

Code:

PDOException:
SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)

  at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40
  at PDO->__construct('mysql:host=localhost;port=3306;charset=utf8mb4;', 'root', '', array(false))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:40)
  at Doctrine\DBAL\Driver\PDOConnection->__construct('mysql:host=localhost;port=3306;charset=utf8mb4;', 'root', null, array(false))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOMySql/Driver.php:25)
  at Doctrine\DBAL\Driver\PDOMySql\Driver->connect(array('driver' => 'pdo_mysql', 'url' => 'pdo-mysql://localhost:3306', 'charset' => 'utf8mb4', 'host' => 'localhost', 'port' => 3306, 'user' => 'root', 'password' => null, 'driverOptions' => array(false), 'defaultTableOptions' => array('charset' => 'utf8mb4', 'collate' => 'utf8mb4_unicode_ci', 'engine' => 'InnoDB', 'row_format' => 'DYNAMIC')), 'root', null, array(false))
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:412)
  at Doctrine\DBAL\Connection->connect()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:1952)
  at Doctrine\DBAL\Connection->getWrappedConnection()
     (vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:980)
  at Doctrine\DBAL\Connection->quote('____________PATH____________')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:319)
  at Contao\Database\Statement->escapeParams(array('____________PATH____________'))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:295)
  at Contao\Database\Statement->replaceWildcards(array('____________PATH____________'))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:246)
  at Contao\Database\Statement->execute('____________PATH____________')
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:1077)
  at Contao\Model::find(array('column' => array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), 'value' => '____________PATH____________', 'return' => 'Collection', 'table' => 'tl_page', 'limit' => 0, 'offset' => 0))
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:948)
  at Contao\Model::findBy(array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), '____________PATH____________')
     (vendor/contao/core-bundle/src/Framework/Adapter.php:44)
  at Contao\CoreBundle\Framework\Adapter->__call('findBy', array(array('(tl_page.type=\'root\' AND (tl_page.dns=? OR tl_page.dns=\'\'))'), '____________PATH____________'))
     (vendor/contao/core-bundle/src/Routing/RouteProvider.php:533)
  at Contao\CoreBundle\Routing\RouteProvider->findRootPages('____________PATH____________')
     (vendor/contao/core-bundle/src/Routing/RouteProvider.php:70)
  at Contao\CoreBundle\Routing\RouteProvider->getRouteCollectionForRequest(object(Request))
     (vendor/contao/core-bundle/src/Routing/LegacyRouteProvider.php:43)
  at Contao\CoreBundle\Routing\LegacyRouteProvider->getRouteCollectionForRequest(object(Request))
     (vendor/symfony-cmf/routing/src/NestedMatcher/NestedMatcher.php:140)
  at Symfony\Cmf\Component\Routing\NestedMatcher\NestedMatcher->matchRequest(object(Request))
     (vendor/contao/core-bundle/src/Routing/Matcher/LegacyMatcher.php:69)
  at Contao\CoreBundle\Routing\Matcher\LegacyMatcher->matchRequest(object(Request))
     (vendor/symfony-cmf/routing/src/DynamicRouter.php:272)
  at Symfony\Cmf\Component\Routing\DynamicRouter->matchRequest(object(Request))
     (vendor/symfony-cmf/routing/src/ChainRouter.php:188)
  at Symfony\Cmf\Component\Routing\ChainRouter->doMatch('/', object(Request))
     (vendor/symfony-cmf/routing/src/ChainRouter.php:158)
  at Symfony\Cmf\Component\Routing\ChainRouter->matchRequest(object(Request))
     (vendor/symfony/http-kernel/EventListener/RouterListener.php:112)
  at Symfony\Component\HttpKernel\EventListener\RouterListener->onKernelRequest(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/Debug/WrappedListener.php:126)
  at Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke(object(RequestEvent), 'kernel.request', object(TraceableEventDispatcher))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:264)
  at Symfony\Component\EventDispatcher\EventDispatcher->doDispatch(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:239)
  at Symfony\Component\EventDispatcher\EventDispatcher->callListeners(array(object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener), object(WrappedListener)), 'kernel.request', object(RequestEvent))
     (vendor/symfony/event-dispatcher/EventDispatcher.php:73)
  at Symfony\Component\EventDispatcher\EventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/event-dispatcher/Debug/TraceableEventDispatcher.php:168)
  at Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch(object(RequestEvent), 'kernel.request')
     (vendor/symfony/http-kernel/HttpKernel.php:145)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
     (vendor/symfony/http-kernel/HttpKernel.php:81)
  at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
     (vendor/symfony/http-kernel/Kernel.php:201)
  at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
     (web/index.php:31)

**mlweb** · 28.03.2023, 16:51

Ich denke da wirst Du eventuell bei PCT im Forum besser fündig. Es gibt auf jeden Fall einen Thread mit Update-Anleitungen für Eclipse X (https://forum.premium-contao-themes....age2#post17427). Inzwischen gibt es auch einen Themeupdater käuflich zu erwerben https://www.premium-contao-themes.co...e_updater.html (zu mindestens, wenn es um ein Eclipse X geht).

**smeyli** · 28.03.2023, 17:10

Zitat von mlweb

Ich denke da wirst Du eventuell bei PCT im Forum besser fündig. Es gibt auf jeden Fall einen Thread mit Update-Anleitungen für Eclipse X (https://forum.premium-contao-themes....age2#post17427). Inzwischen gibt es auch einen Themeupdater käuflich zu erwerben https://www.premium-contao-themes.co...e_updater.html (zu mindestens, wenn es um ein Eclipse X geht).

Danke Maren.
Ich werde mich dann wohl oder übel mal damit beschäftigen