Application error
exeption
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '&& node.rgt <= ) GROUP BY `node`.`dep_id` ORDER BY `node`.`lft` ASC' at line 3
stack
#0 /var/www/apriori.dp.ua/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/apriori.dp.ua/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /var/www/apriori.dp.ua/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `node`.*...', Array) #3 /var/www/apriori.dp.ua/library/Zend/Db/Table/Abstract.php(1537): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #4 /var/www/apriori.dp.ua/library/Zend/Db/Table/Abstract.php(1352): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #5 /var/www/apriori.dp.ua/library/Turist/Db/Table/NestedSet.php(295): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) #6 /var/www/apriori.dp.ua/application/models/MenuCatalog.php(66): Turist_Db_Table_NestedSet->getTree('node.lft >= \n\t\t...') #7 /var/www/apriori.dp.ua/application/controllers/MenuController.php(130): Application_Model_MenuCatalog->getBranch(NULL) #8 /var/www/apriori.dp.ua/library/Zend/Controller/Action.php(516): MenuController->frontendAction() #9 /var/www/apriori.dp.ua/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('frontendAction') #10 /var/www/apriori.dp.ua/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #11 /var/www/apriori.dp.ua/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch() #12 /var/www/apriori.dp.ua/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #13 /var/www/apriori.dp.ua/public/index.php(77): Zend_Application->run() #14 {main}
request
array(5) { ["furl"]=> string(10) "ikra-black" ["dep_id"]=> string(2) "19" ["dep-furl"]=> string(14) "some_furl_here" ["controller"]=> string(4) "menu" ["action"]=> string(8) "frontend" }
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '&& node.rgt <= ) GROUP BY `node`.`dep_id` ORDER BY `node`.`lft` ASC' at line 3 in /var/www/apriori.dp.ua/library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /var/www/apriori.dp.ua/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1 /var/www/apriori.dp.ua/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #2 /var/www/apriori.dp.ua/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #3 /var/www/apriori.dp.ua/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `node`.*...', Array) #4 /var/www/apriori.dp.ua/library/Zend/Db/Table/Abstract.php(1537): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #5 /var/www/apriori.dp.ua/library/Zend/Db/Table/Abstract.php(1352): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #6 /var/www/apriori.dp.ua/library/Turist/Db/Table/NestedSet.php(295): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) #7 /var/www/apriori.dp.ua/application/models/MenuCatalog.php(66): Turist_Db_Table_NestedSet->getTree('node.lft >= \n\t\t...') #8 /var/www/apriori.dp.ua/application/controllers/MenuController.php(130): Application_Model_MenuCatalog->getBranch(NULL) #9 /var/www/apriori.dp.ua/library/Zend/Controller/Action.php(516): MenuController->frontendAction() #10 /var/www/apriori.dp.ua/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('frontendAction') #11 /var/www/apriori.dp.ua/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #12 /var/www/apriori.dp.ua/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch() #13 /var/www/apriori.dp.ua/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #14 /var/www/apriori.dp.ua/public/index.php(77): Zend_Application->run() #15 {main} Next Zend_Db_Statement_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '&& node.rgt <= ) GROUP BY `node`.`dep_id` ORDER BY `node`.`lft` ASC' at line 3 in /var/www/apriori.dp.ua/library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /var/www/apriori.dp.ua/library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/apriori.dp.ua/library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /var/www/apriori.dp.ua/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `node`.*...', Array) #3 /var/www/apriori.dp.ua/library/Zend/Db/Table/Abstract.php(1537): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Table_Select)) #4 /var/www/apriori.dp.ua/library/Zend/Db/Table/Abstract.php(1352): Zend_Db_Table_Abstract->_fetch(Object(Zend_Db_Table_Select)) #5 /var/www/apriori.dp.ua/library/Turist/Db/Table/NestedSet.php(295): Zend_Db_Table_Abstract->fetchAll(Object(Zend_Db_Table_Select)) #6 /var/www/apriori.dp.ua/application/models/MenuCatalog.php(66): Turist_Db_Table_NestedSet->getTree('node.lft >= \n\t\t...') #7 /var/www/apriori.dp.ua/application/controllers/MenuController.php(130): Application_Model_MenuCatalog->getBranch(NULL) #8 /var/www/apriori.dp.ua/library/Zend/Controller/Action.php(516): MenuController->frontendAction() #9 /var/www/apriori.dp.ua/library/Zend/Controller/Dispatcher/Standard.php(295): Zend_Controller_Action->dispatch('frontendAction') #10 /var/www/apriori.dp.ua/library/Zend/Controller/Front.php(954): Zend_Controller_Dispatcher_Standard->dispatch(Object(Zend_Controller_Request_Http), Object(Zend_Controller_Response_Http)) #11 /var/www/apriori.dp.ua/library/Zend/Application/Bootstrap/Bootstrap.php(97): Zend_Controller_Front->dispatch() #12 /var/www/apriori.dp.ua/library/Zend/Application.php(366): Zend_Application_Bootstrap_Bootstrap->run() #13 /var/www/apriori.dp.ua/public/index.php(77): Zend_Application->run() #14 {main}