Code:
[3/3] InvalidFieldNameException
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing 'SELECT * FROM tl_newsletter_recipients WHERE pid='1' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER('kuec') ORDER BY confirmed DESC, email LIMIT 0,30':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'
at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:60
at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'confirmed\' in \'order clause\'', object(PDOException))
(vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:169)
at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'confirmed\' in \'order clause\'')
(vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:149)
at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30', array())
(vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:914)
at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
at Contao\Database\Statement->query()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
at Contao\Database\Statement->execute(array('1', 'kuec'))
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4424)
at Contao\DC_Table->parentView()
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:364)
at Contao\DC_Table->showAll()
(vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
at Contao\Backend->getBackendModule('newsletter', null)
(vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
at Contao\BackendMain->run()
(vendor/contao/core-bundle/src/Controller/BackendController.php:48)
at Contao\CoreBundle\Controller\BackendController->mainAction()
(vendor/symfony/http-kernel/HttpKernel.php:158)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:80)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:201)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(web/index.php:31)
at require('/var/customers/webs/weller/brauerei-weller.de/web/index.php')
(web/app.php:4)
[2/3] PDOException
Doctrine\DBAL\Driver\PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'
at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:83
at Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
(vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:911)
at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
at Contao\Database\Statement->query()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
at Contao\Database\Statement->execute(array('1', 'kuec'))
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4424)
at Contao\DC_Table->parentView()
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:364)
at Contao\DC_Table->showAll()
(vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
at Contao\Backend->getBackendModule('newsletter', null)
(vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
at Contao\BackendMain->run()
(vendor/contao/core-bundle/src/Controller/BackendController.php:48)
at Contao\CoreBundle\Controller\BackendController->mainAction()
(vendor/symfony/http-kernel/HttpKernel.php:158)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:80)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:201)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(web/index.php:31)
at require('/var/customers/webs/weller/brauerei-weller.de/web/index.php')
(web/app.php:4)
[1/3] PDOException
PDOException:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'confirmed' in 'order clause'
at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78
at PDO->query('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
(vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:78)
at Doctrine\DBAL\Driver\PDOConnection->query('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
(vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:911)
at Doctrine\DBAL\Connection->executeQuery('SELECT * FROM tl_newsletter_recipients WHERE pid=\'1\' AND LOWER(CAST(`email` AS CHAR)) REGEXP LOWER(\'kuec\') ORDER BY confirmed DESC, email LIMIT 0,30')
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:274)
at Contao\Database\Statement->query()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:248)
at Contao\Database\Statement->execute(array('1', 'kuec'))
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:4424)
at Contao\DC_Table->parentView()
(vendor/contao/core-bundle/src/Resources/contao/drivers/DC_Table.php:364)
at Contao\DC_Table->showAll()
(vendor/contao/core-bundle/src/Resources/contao/classes/Backend.php:644)
at Contao\Backend->getBackendModule('newsletter', null)
(vendor/contao/core-bundle/src/Resources/contao/controllers/BackendMain.php:167)
at Contao\BackendMain->run()
(vendor/contao/core-bundle/src/Controller/BackendController.php:48)
at Contao\CoreBundle\Controller\BackendController->mainAction()
(vendor/symfony/http-kernel/HttpKernel.php:158)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/http-kernel/HttpKernel.php:80)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/http-kernel/Kernel.php:201)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(web/index.php:31)
at require('/var/customers/webs/weller/brauerei-weller.de/web/index.php')
(web/app.php:4)
Lesezeichen