Fehler nach Update auf Contao 4.13

Moin zusammen,

ich bin aktuell dabei ein Update von der 4.8 auf die 4.13 zu machen. Beim aktualisieren der DB bricht das Install-Tool ab. Im log steht dann das hier:

Code:

---


 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":"http://domain/contao/install","method":"POST"} []

request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'featured' doesn't exist in table" at /html/Pfad-zumOrdner/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 117 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1072): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'featured' doesn't exist in table at /html/Pfad-zumOrdner/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1072): SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'featured' doesn't exist in table at /html/Pfad-zumOrdner/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'featured' doesn't exist in table at /html/Pfad-zumOrdner/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:31)"} []

---

Ich weiß nicht wo ich noch ansetzen kann mit der Fehlersuche oder besser Behebung. Kann jemand helfen?

Nutze den Debug Modus und öffne das Install Tool und aktualisiere ggf. dort die Datenbank. Tritt dabei ein Fehler auf: poste den Stack Trace.

Hi,
hier die Ausgabe des Stack Trace

Code:

---

Doctrine\DBAL\Exception\DriverException:
An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'featured' doesn't exist in table

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert(object(Exception), object(Query))
    (vendor/doctrine/dbal/src/Connection.php:1818)
  at Doctrine\DBAL\Connection->handleDriverException(object(Exception), object(Query))
    (vendor/doctrine/dbal/src/Connection.php:1761)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery(object(Exception), 'CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)', array(), array())
    (vendor/doctrine/dbal/src/Connection.php:1137)
  at Doctrine\DBAL\Connection->executeStatement('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('e0eefae2555dccae2a08ea5c27252058')
    (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)

---

Code:

---

Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'featured' doesn't exist in table

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new(object(PDOException))
    (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:37)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Logging/Connection.php:50)
  at Doctrine\DBAL\Logging\Connection->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Connection.php:1135)
  at Doctrine\DBAL\Connection->executeStatement('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('e0eefae2555dccae2a08ea5c27252058')
    (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)

---

Code:

---

PDOException:
SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'featured' doesn't exist in table

  at vendor/doctrine/dbal/src/Driver/PDO/Connection.php:31
  at PDO->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Driver/PDO/Connection.php:31)
  at Doctrine\DBAL\Driver\PDO\Connection->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Logging/Connection.php:50)
  at Doctrine\DBAL\Logging\Connection->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Driver/Middleware/AbstractConnectionMiddleware.php:46)
  at Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/symfony/doctrine-bridge/Middleware/Debug/Connection.php:85)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Connection->exec('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/doctrine/dbal/src/Connection.php:1135)
  at Doctrine\DBAL\Connection->executeStatement('CREATE INDEX pid_published_featured_start_stop ON tl_calendar_events (pid, published, featured, start, stop)')
    (vendor/contao/installation-bundle/src/Database/Installer.php:84)
  at Contao\InstallationBundle\Database\Installer->execCommand('e0eefae2555dccae2a08ea5c27252058')
    (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)

---

Hm, das könnte ein Bug sein. Da wird versucht ein Index anzulegen, bevor alle Felder hinzugefügt sind. Das könntest du auf GitHub reporten.