Problem bei der Aktualisierung Datenbank

**Arachnophilia** · 03.07.2022, 10:00

Moin

Ich habe wieder ein "Problem" bei der Aktualisierung der Datenbank.

Um eine komplette Designüberarbeitung der Homepage machen zu können, habe ich eine ältere Installationskopie beim Provider auf den neuesten Stand gebracht.

Bei der Aktualisierung der Datenbank wurde das Autreten von einem Problem gemeldet.

Durch Ausprobieren wurden alle Eintragungen soweit in der Datenbank bis auf Einen übernommen.

Folgender Eintrag

Code:

Spalten anlegen
	Alle auswählen
	

CREATE UNIQUE INDEX term ON tl_search_term (term)

erzeugt in der Log den Eintrag:

[

Code:

2022-07-03T10:34:01.277301+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://www.hosting126252.a2fdf.netcup.net/contao/install","method":"POST"} []
[2022-07-03T10:34:03.158745+02:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\UniqueConstraintViolationException: "An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'was' for key 'tl_search_term.term'" at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C4100/contao/cms/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 64 {"exception":"[object] (Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException(code: 1062): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'was' for key 'tl_search_term.term' at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C4100/contao/cms/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:64)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1062): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'was' for key 'tl_search_term.term' at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C4100/contao/cms/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'was' for key 'tl_search_term.term' at /var/www/vhosts/hosting126252.a2fdf.netcup.net/httpdocs_C4100/contao/cms/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)"} []

Interessanterweise wird der "Fehler" auch in der "eigentlichen" Installation erzeugt.
Ausser Aktualisierungen der Erweiterungen habe ich nichts gemacht. Die gemachten Aktualisierungen hatten seinerzeit aber keine Fehlermeldungen erzeugt.

In der Datenbank habe ich so Einträge zwar gefunden, aber kann ich die einfach alle löschen?

Kann jemand von Euch mit der Meldung etwas anfangen?

Das ist der Stack Trace aus dem Debug-Modus

[3/3] UniqueConstraintViolationException

Code:

Doctrine\DBAL\Exception\UniqueConstraintViolationException:
An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'man' for key 'tl_search_term.term'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:64
  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), 'CREATE UNIQUE INDEX term ON tl_search_term (term)', array(), array())
     (vendor/doctrine/dbal/src/Connection.php:1163)
  at Doctrine\DBAL\Connection->executeStatement('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('dd053f0843d47c711600e5ab766aa585')
     (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)

[2/3] Exception

Code:

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'man' for key 'tl_search_term.term'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:30
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:40)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Logging/Connection.php:53)
  at Doctrine\DBAL\Logging\Connection->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Connection.php:1161)
  at Doctrine\DBAL\Connection->executeStatement('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('dd053f0843d47c711600e5ab766aa585')
     (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)

[1/3] PDOException

Code:

PDOException:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'man' for key 'tl_search_term.term'

  at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34
  at PDO->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:34)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Logging/Connection.php:53)
  at Doctrine\DBAL\Logging\Connection->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:47)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/doctrine/dbal/src/Connection.php:1161)
  at Doctrine\DBAL\Connection->executeStatement('CREATE UNIQUE INDEX term ON tl_search_term (term)')
     (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('dd053f0843d47c711600e5ab766aa585')
     (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)

**Spooky** · 03.07.2022, 10:32

Lösche die Tabellen tl_search, tl_search_index und tl_search_term, aktualisiere danach die Datenbank und baue den Suchindex danach neu auf.

**Arachnophilia** · 03.07.2022, 11:41

Moin Spooky

Das war es. Vielen Dank!

Ich habe diese Inhalte jetzt über PhpMyAdmin gelöscht.
Wenn ich das im BE mache, müsste es doch den selben Effekt haben. Das habe ich und trotzdem....

Also manchmal.......