Neuer Install - Abonnenten bearbeiten: SQLSTATE[42S22]: Column not found: 1054

[dtptiger]

Hallo,

ich bin ratlos!
Auch eine ganz frische Contao 4.31 Installation, nur der Core mit den Coremodulen, PHP 8.2, MariaDB 10.5; hostingwerk;

Zum Testen hatte ich mehrere Installationen vorgenommen, neu aufgesetzte in leere Datenbanken.
Contao 4.31 und auch Contao 5.01
Es ist immer der selbe Fehler, ich komme nicht an die Abonnenten, also kann ich keinen Newsletter versenden.

Ich habe noch ein paar weitere 4.13 Installationen, Projekte die seit langem online sind, keine hat diesen Fehler beim Abonnenten Bearbeiten.


Beim klick auf auf den grünen Button "Abonnenten bearbeiten" gibts sofort den SQL Fehler:
Auf der Website:

An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

Ist das ein bekannter Bug?

Fragt DTP-tiger

Weil ich hoffe das es helfen kann den Fehler einzugrenzen,der komplette Stacktrace:

[3/3] InvalidFieldNameException
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

  at vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:67
  at Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter->convert()
     (vendor/doctrine/dbal/src/Connection.php:1931)
  at Doctrine\DBAL\Connection->handleDriverException()
     (vendor/doctrine/dbal/src/Connection.php:1874)
  at Doctrine\DBAL\Connection->convertExceptionDuringQuery()
     (vendor/doctrine/dbal/src/Connection.php:1099)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4534)
  at Contao\DC_Table->parentView()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:306)
  at Contao\DC_Table->showAll()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:44)
  at require('/srv/www/mysite/public/public/index.php')
     (public/app.php:13)                
[2/3] Exception
Doctrine\DBAL\Driver\PDO\Exception:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

  at vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28
  at Doctrine\DBAL\Driver\PDO\Exception::new()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:123)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:65)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1092)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4534)
  at Contao\DC_Table->parentView()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:306)
  at Contao\DC_Table->showAll()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:44)
  at require('/srv/www/mysite/public/public/index.php')
     (public/app.php:13)                
[1/3] PDOException
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'

  at vendor/doctrine/dbal/src/Driver/PDO/Statement.php:121
  at PDOStatement->execute()
     (vendor/doctrine/dbal/src/Driver/PDO/Statement.php:121)
  at Doctrine\DBAL\Driver\PDO\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/doctrine/dbal/src/Logging/Statement.php:98)
  at Doctrine\DBAL\Logging\Statement->execute()
     (vendor/doctrine/dbal/src/Driver/Middleware/AbstractStatementMiddleware.php:69)
  at Doctrine\DBAL\Driver\Middleware\AbstractStatementMiddleware->execute()
     (vendor/symfony/doctrine-bridge/Middleware/Debug/Statement.php:65)
  at Symfony\Bridge\Doctrine\Middleware\Debug\Statement->execute()
     (vendor/doctrine/dbal/src/Connection.php:1092)
  at Doctrine\DBAL\Connection->executeQuery()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:284)
  at Contao\Database\Statement->query()
     (vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:240)
  at Contao\Database\Statement->execute()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4534)
  at Contao\DC_Table->parentView()
     (vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:306)
  at Contao\DC_Table->showAll()
     (vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:667)
  at Contao\Backend->getBackendModule()
     (vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:168)
  at Contao\BackendMain->run()
     (vendor/contao/core-bundle/src/Controller/BackendController.php:49)
  at Contao\CoreBundle\Controller\BackendController->mainAction()
     (vendor/symfony/http-kernel/HttpKernel.php:163)
  at Symfony\Component\HttpKernel\HttpKernel->handleRaw()
     (vendor/symfony/http-kernel/HttpKernel.php:75)
  at Symfony\Component\HttpKernel\HttpKernel->handle()
     (vendor/symfony/http-kernel/Kernel.php:202)
  at Symfony\Component\HttpKernel\Kernel->handle()
     (public/index.php:44)
  at require('/srv/www/mysite/public/public/index.php')
     (public/app.php:13)                
500  @ contao_backend
473 ms
15.6 MiB
 1

[Spooky]

Bist du dir sicher, dass das komplett ohne Anpassungen bzw. Extensions ist?

[dtptiger]

Ja, sicherlich, hatte ich extra deswegen nur installiert.

Vielleicht bin ich ja Geistig umnachtet, denn jetzt hab ich extra ne neu Webadresse aufgesetzt und eine 4.13 Installation gezogen, in dieser ist sind die Abbos zu bearbeiten.
Werde jetzt die db der nicht funktionieren einspielen, vielleicht löst sich das Problem so wies aufgetaucht ist, quasi aus dem nichts.

Viele Grüße dtptiger

[dtptiger]

Der Fehler kommt aus der Datenbank.
Das war eine Update Version, sobald ich mit der selben Contaoinstallation eine andere db verwende ist die Funktion wieder da.
Ich hab gesucht die Tabelle die mit dem Event angesprochen wird zu finden, ohne Erfolg!
Weis jemand wo ich schauen könnte?

Gruß dtptiger