/customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:32
[Syntax Error] line 0, col 132: Error: Expected known function, got 'YEAR'
#0 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(508): Doctrine\ORM\Query\QueryException::syntaxError('line 0, col 132...', Object(Doctrine\ORM\Query\QueryException)) #1 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3497): Doctrine\ORM\Query\Parser->syntaxError('known function', Array) #2 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2948): Doctrine\ORM\Query\Parser->FunctionDeclaration() #3 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2907): Doctrine\ORM\Query\Parser->ArithmeticPrimary() #4 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2874): Doctrine\ORM\Query\Parser->ArithmeticFactor() #5 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2848): Doctrine\ORM\Query\Parser->ArithmeticTerm() #6 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2835): Doctrine\ORM\Query\Parser->SimpleArithmeticExpression() #7 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3174): Doctrine\ORM\Query\Parser->ArithmeticExpression() #8 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2695): Doctrine\ORM\Query\Parser->ComparisonExpression() #9 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2563): Doctrine\ORM\Query\Parser->SimpleConditionalExpression() #10 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2539): Doctrine\ORM\Query\Parser->ConditionalPrimary() #11 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2512): Doctrine\ORM\Query\Parser->ConditionalFactor() #12 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2482): Doctrine\ORM\Query\Parser->ConditionalTerm() #13 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1429): Doctrine\ORM\Query\Parser->ConditionalExpression() #14 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(930): Doctrine\ORM\Query\Parser->WhereClause() #15 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(897): Doctrine\ORM\Query\Parser->SelectStatement() #16 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(307): Doctrine\ORM\Query\Parser->QueryLanguage() #17 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(407): Doctrine\ORM\Query\Parser->getAST() #18 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(274): Doctrine\ORM\Query\Parser->parse() #19 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query->parse() #20 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1211): Doctrine\ORM\Query->_doExecute() #21 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1165): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 3) #22 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(937): Doctrine\ORM\AbstractQuery->execute(NULL, 3) #23 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(115): Doctrine\ORM\AbstractQuery->getScalarResult() #24 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/doctrine-orm-module/src/Paginator/Adapter/DoctrinePaginator.php(59): Doctrine\ORM\Tools\Pagination\Paginator->count() #25 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-paginator/src/Paginator.php(918): DoctrineORMModule\Paginator\Adapter\DoctrinePaginator->count() #26 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-paginator/src/Paginator.php(586): Laminas\Paginator\Paginator->_calculatePageCount() #27 /customers/0/1/5/minervacars.com/httpd.www/module/Application/src/Service/PostService.php(91): Laminas\Paginator\Paginator->setItemCountPerPage(10) #28 /customers/0/1/5/minervacars.com/httpd.www/module/Application/src/Controller/IndexController.php(32): Application\Service\PostService->getAllPosts(2014, 8, NULL, 1, 10) #29 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(72): Application\Controller\IndexController->indexAction() #30 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #31 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #32 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #33 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response)) #34 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #35 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #36 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/Application.php(319): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #37 /customers/0/1/5/minervacars.com/httpd.www/index.php(42): Laminas\Mvc\Application->run() #38 {main}
/customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/QueryException.php:21
SELECT p, u, i FROM Application\Model\Post p INNER JOIN p.author u LEFT JOIN p.images i WHERE p.published = 1 AND p.deleted = 0 AND YEAR(p.date) = 2014 AND MONTH(p.date) = 8 ORDER BY p.date DESC
#0 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(508): Doctrine\ORM\Query\QueryException::dqlError('SELECT p, u, i ...') #1 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3497): Doctrine\ORM\Query\Parser->syntaxError('known function', Array) #2 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2948): Doctrine\ORM\Query\Parser->FunctionDeclaration() #3 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2907): Doctrine\ORM\Query\Parser->ArithmeticPrimary() #4 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2874): Doctrine\ORM\Query\Parser->ArithmeticFactor() #5 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2848): Doctrine\ORM\Query\Parser->ArithmeticTerm() #6 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2835): Doctrine\ORM\Query\Parser->SimpleArithmeticExpression() #7 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(3174): Doctrine\ORM\Query\Parser->ArithmeticExpression() #8 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2695): Doctrine\ORM\Query\Parser->ComparisonExpression() #9 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2563): Doctrine\ORM\Query\Parser->SimpleConditionalExpression() #10 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2539): Doctrine\ORM\Query\Parser->ConditionalPrimary() #11 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2512): Doctrine\ORM\Query\Parser->ConditionalFactor() #12 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(2482): Doctrine\ORM\Query\Parser->ConditionalTerm() #13 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(1429): Doctrine\ORM\Query\Parser->ConditionalExpression() #14 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(930): Doctrine\ORM\Query\Parser->WhereClause() #15 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(897): Doctrine\ORM\Query\Parser->SelectStatement() #16 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(307): Doctrine\ORM\Query\Parser->QueryLanguage() #17 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(407): Doctrine\ORM\Query\Parser->getAST() #18 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(274): Doctrine\ORM\Query\Parser->parse() #19 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query->parse() #20 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1211): Doctrine\ORM\Query->_doExecute() #21 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(1165): Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache(NULL, 3) #22 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(937): Doctrine\ORM\AbstractQuery->execute(NULL, 3) #23 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(115): Doctrine\ORM\AbstractQuery->getScalarResult() #24 /customers/0/1/5/minervacars.com/httpd.www/vendor/doctrine/doctrine-orm-module/src/Paginator/Adapter/DoctrinePaginator.php(59): Doctrine\ORM\Tools\Pagination\Paginator->count() #25 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-paginator/src/Paginator.php(918): DoctrineORMModule\Paginator\Adapter\DoctrinePaginator->count() #26 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-paginator/src/Paginator.php(586): Laminas\Paginator\Paginator->_calculatePageCount() #27 /customers/0/1/5/minervacars.com/httpd.www/module/Application/src/Service/PostService.php(91): Laminas\Paginator\Paginator->setItemCountPerPage(10) #28 /customers/0/1/5/minervacars.com/httpd.www/module/Application/src/Controller/IndexController.php(32): Application\Service\PostService->getAllPosts(2014, 8, NULL, 1, 10) #29 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/Controller/AbstractActionController.php(72): Application\Controller\IndexController->indexAction() #30 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\Controller\AbstractActionController->onDispatch(Object(Laminas\Mvc\MvcEvent)) #31 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #32 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/Controller/AbstractController.php(105): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #33 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/DispatchListener.php(117): Laminas\Mvc\Controller\AbstractController->dispatch(Object(Laminas\Http\PhpEnvironment\Request), Object(Laminas\Http\PhpEnvironment\Response)) #34 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(318): Laminas\Mvc\DispatchListener->onDispatch(Object(Laminas\Mvc\MvcEvent)) #35 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-eventmanager/src/EventManager.php(178): Laminas\EventManager\EventManager->triggerListeners(Object(Laminas\Mvc\MvcEvent), Object(Closure)) #36 /customers/0/1/5/minervacars.com/httpd.www/vendor/laminas/laminas-mvc/src/Application.php(319): Laminas\EventManager\EventManager->triggerEventUntil(Object(Closure), Object(Laminas\Mvc\MvcEvent)) #37 /customers/0/1/5/minervacars.com/httpd.www/index.php(42): Laminas\Mvc\Application->run() #38 {main}