An error occurred

An error occurred during execution; please try again later.


Additional information:

Doctrine\DBAL\DBALException

File
/home/web.viajesteide/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:47
Message
An exception occurred while executing 'SELECT DISTINCT id_blogpost0 FROM (SELECT b0_.id_blogpost AS id_blogpost0, b0_.type AS type1, b0_.state AS state2, b0_.thumbnail AS thumbnail3, b0_.date_create AS date_create4, b0_.date_published AS date_published5, b0_.date_modify AS date_modify6, b0_.count_comments AS count_comments7, b0_.count_visited AS count_visited8, b0_.`order` AS order9, b0_.active AS active10, b1_.title AS title11, b1_.slug AS slug12, b1_.content AS content13, b2_.id_blogcategory AS id_blogcategory14, b2_.`order` AS order15, b2_.active AS active16, b3_.name AS name17, b3_.slug AS slug18, b3_.description AS description19, b4_.id_blogtag AS id_blogtag20, b4_.tag AS tag21, l5_.id_language AS id_language22, l5_.code AS code23, l5_.flag AS flag24, l5_.name AS name25, l5_.`order` AS order26, l5_.active AS active27, b1_.id_blogpost AS id_blogpost28, b1_.id_language AS id_language29, b3_.id_blogcategory AS id_blogcategory30, b3_.id_language AS id_language31 FROM blogPosts b0_ LEFT JOIN blogPostTranslations b1_ ON b0_.id_blogpost = b1_.id_blogpost LEFT JOIN blogCategoriesPosts b6_ ON b0_.id_blogpost = b6_.id_blogpost LEFT JOIN blogCategories b2_ ON b2_.id_blogcategory = b6_.id_blogcategory LEFT JOIN blogCategoriesTranslations b3_ ON b2_.id_blogcategory = b3_.id_blogcategory LEFT JOIN blogTagsPosts b7_ ON b0_.id_blogpost = b7_.id_blogpost LEFT JOIN blogTags b4_ ON b4_.id_blogtag = b7_.id_blogtag LEFT JOIN languages l5_ ON b4_.id_language = l5_.id_language WHERE b1_.id_language = ? AND b0_.state = 3 AND b0_.active = 1 AND b3_.slug = ?) dctrn_result ORDER BY date_published5 DESC LIMIT 5 OFFSET 0' with params ["2", "culture"]:

SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dctrn_result.date_published5' which is not in SELECT list; this is incompatible with DISTINCT
Stack trace
#0 /home/web.viajesteide/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(649): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
#1 /home/web.viajesteide/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(46): Doctrine\DBAL\Connection->executeQuery()
#2 /home/web.viajesteide/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(264): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute()
#3 /home/web.viajesteide/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(741): Doctrine\ORM\Query->_doExecute()
#4 /home/web.viajesteide/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(566): Doctrine\ORM\AbstractQuery->execute()
#5 /home/web.viajesteide/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(152): Doctrine\ORM\AbstractQuery->getScalarResult()
#6 /home/web.viajesteide/vendor/emdb/emdbBlog/src/emdbBlog/Repository/BlogPostsRepository.php(63): Doctrine\ORM\Tools\Pagination\Paginator->getIterator()
#7 /home/web.viajesteide/vendor/emdb/emdbBlog/src/emdbBlog/Blog/Blog.php(44): emdbBlog\Repository\BlogPostsRepository->getBlogPosts()
#8 /home/web.viajesteide/vendor/emdb/emdbBlog/src/emdbBlog/Controller/BlogController.php(152): emdbBlog\Blog\Blog->getBlogPosts()
#9 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractActionController.php(83): emdbBlog\Controller\BlogController->categoryAction()
#10 [internal function]: Zend\Mvc\Controller\AbstractActionController->onDispatch()
#11 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(460): call_user_func()
#12 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(204): Zend\EventManager\EventManager->triggerListeners()
#13 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/Mvc/Controller/AbstractController.php(117): Zend\EventManager\EventManager->trigger()
#14 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/Mvc/DispatchListener.php(114): Zend\Mvc\Controller\AbstractController->dispatch()
#15 [internal function]: Zend\Mvc\DispatchListener->onDispatch()
#16 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(460): call_user_func()
#17 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/EventManager/EventManager.php(204): Zend\EventManager\EventManager->triggerListeners()
#18 /home/web.viajesteide/vendor/zendframework/zendframework/library/Zend/Mvc/Application.php(294): Zend\EventManager\EventManager->trigger()
#19 /home/web.viajesteide/public/index.php(14): Zend\Mvc\Application->run()
#20 {main}

Previous exceptions: