Stack Trace:
Code:
Doctrine\DBAL\Exception\InvalidFieldNameException:
An exception occurred while executing 'SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start='' OR tl_news.start<='1565951040') AND (tl_news.stop='' OR tl_news.stop>'1565951100') AND tl_news.published='1' ORDER BY order_date_asc LIMIT 0,3':
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_date_asc' in 'order clause'
at vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:80
at Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'order_date_asc\' in \'order clause\'', object(PDOException))
(vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:184)
at Doctrine\DBAL\DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'order_date_asc\' in \'order clause\'')
(vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:158)
at Doctrine\DBAL\DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3', array())
(vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:943)
at Doctrine\DBAL\Connection->executeQuery('SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3')
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:276)
at Contao\Database\Statement->query()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php:250)
at Contao\Database\Statement->execute(null)
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:1088)
at Contao\Model::find(array('column' => array('tl_news.pid IN(1)', '(tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\''), 'value' => null, 'return' => 'Collection', 'order' => 'order_date_asc', 'limit' => '3', 'offset' => 0, 'table' => 'tl_news'))
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php:959)
at Contao\Model::findBy(array('tl_news.pid IN(1)', '(tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\''), null, array('column' => array('tl_news.pid IN(1)', '(tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\''), 'value' => null, 'return' => 'Collection', 'order' => 'order_date_asc', 'limit' => '3', 'offset' => 0))
(vendor/contao/news-bundle/src/Resources/contao/models/NewsModel.php:238)
at Contao\NewsModel::findPublishedByPids(array('1'), null, '3', 0, array('order' => 'order_date_asc', 'limit' => '3', 'offset' => 0))
(system/modules/pct_autogrid/PCT/AutoGrid/AutoGrid.php:1602)
at PCT\AutoGrid\AutoGrid->applyNewsSorting(array('1'), null, '3', 0, object(ModuleNewsList))
(vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:199)
at Contao\ModuleNewsList->fetchItems(array('1'), null, '3', 0)
(vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:141)
at Contao\ModuleNewsList->compile()
(vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:220)
at Contao\Module->generate()
(vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php:62)
at Contao\ModuleNewsList->generate()
(vendor/contao/core-bundle/src/Resources/contao/elements/ContentModule.php:68)
at Contao\ContentModule->generate()
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:480)
at Contao\Controller::getContentElement(object(ContentModel), 'main')
(vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:183)
at Contao\ModuleArticle->compile()
(vendor/contao/core-bundle/src/Resources/contao/modules/Module.php:220)
at Contao\Module->generate()
(vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php:65)
at Contao\ModuleArticle->generate(false)
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:420)
at Contao\Controller::getArticle(object(ArticleModel), false, false, 'main')
(vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php:279)
at Contao\Controller::getFrontendModule('0', 'main')
(vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:174)
at Contao\PageRegular->prepare(object(PageModel))
(vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php:47)
at Contao\PageRegular->getResponse(object(PageModel), true)
(vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:306)
at Contao\FrontendIndex->renderPage(object(Collection))
(vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php:75)
at Contao\FrontendIndex->run()
(vendor/contao/core-bundle/src/Controller/FrontendController.php:42)
at Contao\CoreBundle\Controller\FrontendController->indexAction()
(vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:151)
at Symfony\Component\HttpKernel\HttpKernel->handleRaw(object(Request), 1)
(vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php:68)
at Symfony\Component\HttpKernel\HttpKernel->handle(object(Request), 1, true)
(vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php:200)
at Symfony\Component\HttpKernel\Kernel->handle(object(Request))
(web/app_dev.php:69)
Exceptions
Code:
Doctrine\DBAL\Exception\ InvalidFieldNameException
in vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php (line 80)
AbstractMySQLDriver->convertException('An exception occurred while executing \'SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'order_date_asc\' in \'order clause\'', object(PDOException)) in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php (line 184)
DBALException::wrapException(object(Driver), object(PDOException), 'An exception occurred while executing \'SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3\':SQLSTATE[42S22]: Column not found: 1054 Unknown column \'order_date_asc\' in \'order clause\'') in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php (line 158)
DBALException::driverExceptionDuringQuery(object(Driver), object(PDOException), 'SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3', array()) in vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php (line 943)
Connection->executeQuery('SELECT tl_news.* FROM tl_news WHERE tl_news.pid IN(1) AND (tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\' ORDER BY order_date_asc LIMIT 0,3') in vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php (line 276)
Statement->query() in vendor/contao/core-bundle/src/Resources/contao/library/Contao/Database/Statement.php (line 250)
Statement->execute(null) in vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php (line 1088)
Model::find(array('column' => array('tl_news.pid IN(1)', '(tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\''), 'value' => null, 'return' => 'Collection', 'order' => 'order_date_asc', 'limit' => '3', 'offset' => 0, 'table' => 'tl_news')) in vendor/contao/core-bundle/src/Resources/contao/library/Contao/Model.php (line 959)
Model::findBy(array('tl_news.pid IN(1)', '(tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\''), null, array('column' => array('tl_news.pid IN(1)', '(tl_news.start=\'\' OR tl_news.start<=\'1565951040\') AND (tl_news.stop=\'\' OR tl_news.stop>\'1565951100\') AND tl_news.published=\'1\''), 'value' => null, 'return' => 'Collection', 'order' => 'order_date_asc', 'limit' => '3', 'offset' => 0)) in vendor/contao/news-bundle/src/Resources/contao/models/NewsModel.php (line 238)
NewsModel::findPublishedByPids(array('1'), null, '3', 0, array('order' => 'order_date_asc', 'limit' => '3', 'offset' => 0)) in system/modules/pct_autogrid/PCT/AutoGrid/AutoGrid.php (line 1602)
}
// add sorting
$arrOptions['order'] = $objModule->news_order ?: 'sorting';
return \NewsModel::findPublishedByPids($arrArchives, $blnFeatured, $limit, $offset, $arrOptions);
}
}
AutoGrid->applyNewsSorting(array('1'), null, '3', 0, object(ModuleNewsList)) in vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php (line 199)
ModuleNewsList->fetchItems(array('1'), null, '3', 0) in vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php (line 141)
ModuleNewsList->compile() in vendor/contao/core-bundle/src/Resources/contao/modules/Module.php (line 220)
Module->generate() in vendor/contao/news-bundle/src/Resources/contao/modules/ModuleNewsList.php (line 62)
ModuleNewsList->generate() in vendor/contao/core-bundle/src/Resources/contao/elements/ContentModule.php (line 68)
ContentModule->generate() in vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php (line 480)
Controller::getContentElement(object(ContentModel), 'main') in vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php (line 183)
ModuleArticle->compile() in vendor/contao/core-bundle/src/Resources/contao/modules/Module.php (line 220)
Module->generate() in vendor/contao/core-bundle/src/Resources/contao/modules/ModuleArticle.php (line 65)
ModuleArticle->generate(false) in vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php (line 420)
Controller::getArticle(object(ArticleModel), false, false, 'main') in vendor/contao/core-bundle/src/Resources/contao/library/Contao/Controller.php (line 279)
Controller::getFrontendModule('0', 'main') in vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php (line 174)
PageRegular->prepare(object(PageModel)) in vendor/contao/core-bundle/src/Resources/contao/pages/PageRegular.php (line 47)
PageRegular->getResponse(object(PageModel), true) in vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php (line 306)
FrontendIndex->renderPage(object(Collection)) in vendor/contao/core-bundle/src/Resources/contao/controllers/FrontendIndex.php (line 75)
FrontendIndex->run() in vendor/contao/core-bundle/src/Controller/FrontendController.php (line 42)
FrontendController->indexAction() in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 151)
HttpKernel->handleRaw(object(Request), 1) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernel.php (line 68)
HttpKernel->handle(object(Request), 1, true) in vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php (line 200)
Kernel->handle(object(Request)) in web/app_dev.php (line 69)