Problem bei der Aktualisierung Datenbank
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. :eek:
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)
