Ergebnis 1 bis 4 von 4

Thema: Fehler nach Update auf Contao 4.13

  1. #1
    Contao-Nutzer
    Registriert seit
    02.03.2017.
    Beiträge
    50

    Standard 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?

  2. #2
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    34.126
    Partner-ID
    10107

    Standard

    Nutze den Debug Modus und öffne das Install Tool und aktualisiere ggf. dort die Datenbank. Tritt dabei ein Fehler auf: poste den Stack Trace.
    » sponsor me via GitHub or PayPal or Revolut

  3. #3
    Contao-Nutzer
    Registriert seit
    02.03.2017.
    Beiträge
    50

    Standard

    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)

  4. #4
    Community-Moderator
    Wandelndes Contao-Lexikon
    Avatar von Spooky
    Registriert seit
    12.04.2012.
    Ort
    Scotland
    Beiträge
    34.126
    Partner-ID
    10107

    Standard

    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.
    » sponsor me via GitHub or PayPal or Revolut

Aktive Benutzer

Aktive Benutzer

Aktive Benutzer in diesem Thema: 1 (Registrierte Benutzer: 0, Gäste: 1)

Lesezeichen

Lesezeichen

Berechtigungen

  • Neue Themen erstellen: Nein
  • Themen beantworten: Nein
  • Anhänge hochladen: Nein
  • Beiträge bearbeiten: Nein
  •