Каталог статей по темам

    An exception occurred while executing 'SELECT node.id, (COUNT(parent.id) - (sub_tree.depth + 1)) AS depth FROM Topics as node, Topics as parent, Topics as sub_parent, (SELECT node.id, (COUNT(parent.id) - 1) AS depth FROM Topics as node, Topics as parent WHERE node.node_left BETWEEN parent.node_left AND parent.node_right AND node.id = 668 GROUP BY node.id ORDER BY node.node_left) as sub_tree WHERE sub_parent.id = sub_tree.id AND node.node_left BETWEEN sub_parent.node_left AND sub_parent.node_right AND node.node_left BETWEEN parent.node_left AND parent.node_right GROUP BY node.id HAVING depth > 0 ORDER BY node.node_left': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sub_tree.depth' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by#0 /var/www/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(649): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), 'SELECT node.id,...', Array) #1 /var/www/newscoop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(584): Doctrine\DBAL\Connection->executeQuery('SELECT node.id,...', Array) #2 /var/www/newscoop/library/Newscoop/Doctrine/AdoDbAdapter.php(156): Doctrine\DBAL\Connection->fetchAll('SELECT node.id,...', Array) #3 /var/www/newscoop/classes/Topic.php(666): Newscoop\Doctrine\AdoDbAdapter->getAll('SELECT node.id,...') #4 /var/www/newscoop/classes/Article.php(2582): Topic->getSubtopics(true, 0) #5 /var/www/newscoop/template_engine/classes/ArticlesList.php(101): Article::GetList(Array, Array, 0, 0, NULL, false, false) #6 /var/www/newscoop/template_engine/classes/ListObject.php(194): ArticlesList->CreateList(0, 0, Array, NULL) #7 /var/www/newscoop/include/smarty/campsite_plugins/block.list_articles.php(32): ListObject->__construct(NULL, Array) #8 /var/www/newscoop/vendor/smarty/smarty-dev/distribution/libs/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code(83): smarty_block_list_articles(Array, NULL, Object(Smarty_Internal_Template), true) #9 /var/www/newscoop/vendor/smarty/smarty-dev/distribution/libs/sysplugins/smarty_internal_templatebase.php(188): content_5e2c5ee5b1bdd4_51824292(Object(Smarty_Internal_Template)) #10 /var/www/newscoop/vendor/smarty/smarty-dev/distribution/libs/sysplugins/smarty_internal_templatebase.php(394): Smarty_Internal_TemplateBase->fetch('_tpl/bytopics-c...', NULL, NULL, NULL, true) #11 /var/www/newscoop/include/smarty/campsite_plugins/function.render.php(84): Smarty_Internal_TemplateBase->display('_tpl/bytopics-c...') #12 /var/www/newscoop/vendor/smarty/smarty-dev/distribution/libs/sysplugins/smarty_internal_templatebase.php(157) : eval()'d code(70): smarty_function_render(Array, Object(Smarty_Internal_Template)) #13 /var/www/newscoop/vendor/smarty/smarty-dev/distribution/libs/sysplugins/smarty_internal_templatebase.php(188): content_5e2c5ee5544448_00035360(Object(Smarty_Internal_Template)) #14 /var/www/newscoop/vendor/smarty/smarty-dev/distribution/libs/sysplugins/smarty_internal_templatebase.php(394): Smarty_Internal_TemplateBase->fetch('bytopics.tpl', NULL, NULL, NULL, true) #15 /var/www/newscoop/template_engine/classes/CampHTMLDocument.php(315): Smarty_Internal_TemplateBase->display('bytopics.tpl') #16 /var/www/newscoop/template_engine/classes/CampSite.php(154): CampHTMLDocument->render(Array) #17 /var/www/newscoop/application/controllers/LegacyController.php(391): CampSite->render() #18 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/Controller/Action.php(516): LegacyController->indexAction() #19 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('indexAction') #20 /var/www/newscoop/vendor/bombayworks/zendframework1/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #21 /var/www/newscoop/src/Newscoop/ZendBridgeBundle/Controller/BridgeController.php(60): Zend_Controller_Front->dispatch() #22 [internal function]: Newscoop\ZendBridgeBundle\Controller\BridgeController->indexAction(Object(Symfony\Component\HttpFoundation\Request)) #23 /var/www/newscoop/application/bootstrap.php.cache(2891): call_user_func_array(Array, Array) #24 /var/www/newscoop/application/bootstrap.php.cache(2865): Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object(Symfony\Component\HttpFoundation\Request), 1) #25 /var/www/newscoop/application/bootstrap.php.cache(2994): Symfony\Component\HttpKernel\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #26 /var/www/newscoop/application/bootstrap.php.cache(2274): Symfony\Component\HttpKernel\DependencyInjection\ContainerAwareHttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #27 /var/www/newscoop/public/index.php(114): Symfony\Component\HttpKernel\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request)) #28 /var/www/newscoop/index.php(17): require_once('/var/www/newsco...') #29 {main}