Neuer Install - Abonnenten bearbeiten: SQLSTATE[42S22]: Column not found: 1054
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:
Code:
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:
Code:
[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
