Zend_Db_Statement_Exception Object ( [_previous:Zend_Exception:private] => [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`' at line 8 [string:Exception:private] => [code:protected] => 42000 [file:protected] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Statement/Pdo.php [line:protected] => 234 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Statement.php [line] => 300 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => SELECT `sections_sub`.*, `products`.`link`,`products`.`price`,`products`.`actionprice`,`products`.`id` as product_id FROM `sections_sub` JOIN `products` ON `products`.`category_id`=`sections_sub`.`id` WHERE `sections_sub`.`lang_id`=1 AND `sections_sub`.`section_id`= AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`=1 AND products.price = ( SELECT MIN(price) FROM products WHERE active=1 AND `sections_sub`.`lang_id`=1 AND `products`.`main`=1 AND `products`.`category_id`=`sections_sub`.`id` AND products.price > 0 ) GROUP BY `sections_sub`.`id` ORDER BY title LIMIT 0, 21 [1] => Array ( ) ) ) [3] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Adapter/Abstract.php [line] => 737 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => SELECT `sections_sub`.*, `products`.`link`,`products`.`price`,`products`.`actionprice`,`products`.`id` as product_id FROM `sections_sub` JOIN `products` ON `products`.`category_id`=`sections_sub`.`id` WHERE `sections_sub`.`lang_id`=1 AND `sections_sub`.`section_id`= AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`=1 AND products.price = ( SELECT MIN(price) FROM products WHERE active=1 AND `sections_sub`.`lang_id`=1 AND `products`.`main`=1 AND `products`.`category_id`=`sections_sub`.`id` AND products.price > 0 ) GROUP BY `sections_sub`.`id` ORDER BY title LIMIT 0, 21 [1] => Array ( ) ) ) [4] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/application/models/SectionsDb.php [line] => 223 [function] => fetchAll [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => SELECT `sections_sub`.*, `products`.`link`,`products`.`price`,`products`.`actionprice`,`products`.`id` as product_id FROM `sections_sub` JOIN `products` ON `products`.`category_id`=`sections_sub`.`id` WHERE `sections_sub`.`lang_id`=1 AND `sections_sub`.`section_id`= AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`=1 AND products.price = ( SELECT MIN(price) FROM products WHERE active=1 AND `sections_sub`.`lang_id`=1 AND `products`.`main`=1 AND `products`.`category_id`=`sections_sub`.`id` AND products.price > 0 ) GROUP BY `sections_sub`.`id` ORDER BY title LIMIT 0, 21 ) ) [5] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/application/controllers/sections/IndexController.php [line] => 185 [function] => getSubSectionsCustomForPage [class] => SectionsDb [type] => -> [args] => Array ( [0] => [1] => 1 [2] => 0 [3] => -1 [4] => title ) ) [6] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Controller/Action.php [line] => 516 [function] => sectionAction [class] => Sections_IndexController [type] => -> [args] => Array ( ) ) [7] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Controller/Dispatcher/Standard.php [line] => 298 [function] => dispatch [class] => Zend_Controller_Action [type] => -> [args] => Array ( [0] => sectionAction ) ) [8] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Controller/Front.php [line] => 954 [function] => dispatch [class] => Zend_Controller_Dispatcher_Standard [type] => -> [args] => Array ( [0] => Zend_Controller_Request_Http Object ( [_paramSources:protected] => Array ( [0] => _GET [1] => _POST ) [_requestUri:protected] => /section/klassicheskie-modulnye-sistemy/page/1 [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /section/klassicheskie-modulnye-sistemy/page/1 [_params:protected] => Array ( [link] => klassicheskie-modulnye-sistemy [page] => 1 [module] => sections [controller] => index [action] => section ) [_rawBody:protected] => [_aliases:protected] => Array ( ) [_dispatched:protected] => 1 [_module:protected] => sections [_moduleKey:protected] => module [_controller:protected] => index [_controllerKey:protected] => controller [_action:protected] => section [_actionKey:protected] => action ) [1] => Zend_Controller_Response_Http Object ( [_body:protected] => Array ( ) [_exceptions:protected] => Array ( ) [_headers:protected] => Array ( ) [_headersRaw:protected] => Array ( ) [_httpResponseCode:protected] => 200 [_isRedirect:protected] => [_renderExceptions:protected] => [headersSentThrowsException] => 1 ) ) ) [9] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/backend/R.php [line] => 840 [function] => dispatch [class] => Zend_Controller_Front [type] => -> [args] => Array ( ) ) [10] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Loader.php [line] => 146 [args] => Array ( [0] => /var/www/user_04/data/www/brwmebelspb.ru/backend/R.php ) [function] => include_once ) [11] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/index.php [line] => 126 [function] => loadFile [class] => Zend_Loader [type] => :: [args] => Array ( [0] => R.php [1] => /var/www/user_04/data/www/brwmebelspb.ru/backend/ [2] => 1 ) ) ) [previous:Exception:private] => PDOException Object ( [message:protected] => SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`' at line 8 [string:Exception:private] => [code:protected] => 42000 [file:protected] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Statement/Pdo.php [line:protected] => 228 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Statement/Pdo.php [line] => 228 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Statement.php [line] => 300 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [3] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => SELECT `sections_sub`.*, `products`.`link`,`products`.`price`,`products`.`actionprice`,`products`.`id` as product_id FROM `sections_sub` JOIN `products` ON `products`.`category_id`=`sections_sub`.`id` WHERE `sections_sub`.`lang_id`=1 AND `sections_sub`.`section_id`= AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`=1 AND products.price = ( SELECT MIN(price) FROM products WHERE active=1 AND `sections_sub`.`lang_id`=1 AND `products`.`main`=1 AND `products`.`category_id`=`sections_sub`.`id` AND products.price > 0 ) GROUP BY `sections_sub`.`id` ORDER BY title LIMIT 0, 21 [1] => Array ( ) ) ) [4] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Db/Adapter/Abstract.php [line] => 737 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => SELECT `sections_sub`.*, `products`.`link`,`products`.`price`,`products`.`actionprice`,`products`.`id` as product_id FROM `sections_sub` JOIN `products` ON `products`.`category_id`=`sections_sub`.`id` WHERE `sections_sub`.`lang_id`=1 AND `sections_sub`.`section_id`= AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`=1 AND products.price = ( SELECT MIN(price) FROM products WHERE active=1 AND `sections_sub`.`lang_id`=1 AND `products`.`main`=1 AND `products`.`category_id`=`sections_sub`.`id` AND products.price > 0 ) GROUP BY `sections_sub`.`id` ORDER BY title LIMIT 0, 21 [1] => Array ( ) ) ) [5] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/application/models/SectionsDb.php [line] => 223 [function] => fetchAll [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => SELECT `sections_sub`.*, `products`.`link`,`products`.`price`,`products`.`actionprice`,`products`.`id` as product_id FROM `sections_sub` JOIN `products` ON `products`.`category_id`=`sections_sub`.`id` WHERE `sections_sub`.`lang_id`=1 AND `sections_sub`.`section_id`= AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`=1 AND products.price = ( SELECT MIN(price) FROM products WHERE active=1 AND `sections_sub`.`lang_id`=1 AND `products`.`main`=1 AND `products`.`category_id`=`sections_sub`.`id` AND products.price > 0 ) GROUP BY `sections_sub`.`id` ORDER BY title LIMIT 0, 21 ) ) [6] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/application/controllers/sections/IndexController.php [line] => 185 [function] => getSubSectionsCustomForPage [class] => SectionsDb [type] => -> [args] => Array ( [0] => [1] => 1 [2] => 0 [3] => -1 [4] => title ) ) [7] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Controller/Action.php [line] => 516 [function] => sectionAction [class] => Sections_IndexController [type] => -> [args] => Array ( ) ) [8] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Controller/Dispatcher/Standard.php [line] => 298 [function] => dispatch [class] => Zend_Controller_Action [type] => -> [args] => Array ( [0] => sectionAction ) ) [9] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Controller/Front.php [line] => 954 [function] => dispatch [class] => Zend_Controller_Dispatcher_Standard [type] => -> [args] => Array ( [0] => Zend_Controller_Request_Http Object ( [_paramSources:protected] => Array ( [0] => _GET [1] => _POST ) [_requestUri:protected] => /section/klassicheskie-modulnye-sistemy/page/1 [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /section/klassicheskie-modulnye-sistemy/page/1 [_params:protected] => Array ( [link] => klassicheskie-modulnye-sistemy [page] => 1 [module] => sections [controller] => index [action] => section ) [_rawBody:protected] => [_aliases:protected] => Array ( ) [_dispatched:protected] => 1 [_module:protected] => sections [_moduleKey:protected] => module [_controller:protected] => index [_controllerKey:protected] => controller [_action:protected] => section [_actionKey:protected] => action ) [1] => Zend_Controller_Response_Http Object ( [_body:protected] => Array ( ) [_exceptions:protected] => Array ( ) [_headers:protected] => Array ( ) [_headersRaw:protected] => Array ( ) [_httpResponseCode:protected] => 200 [_isRedirect:protected] => [_renderExceptions:protected] => [headersSentThrowsException] => 1 ) ) ) [10] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/backend/R.php [line] => 840 [function] => dispatch [class] => Zend_Controller_Front [type] => -> [args] => Array ( ) ) [11] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/library/Zend/Loader.php [line] => 146 [args] => Array ( [0] => /var/www/user_04/data/www/brwmebelspb.ru/backend/R.php ) [function] => include_once ) [12] => Array ( [file] => /var/www/user_04/data/www/brwmebelspb.ru/index.php [line] => 126 [function] => loadFile [class] => Zend_Loader [type] => :: [args] => Array ( [0] => R.php [1] => /var/www/user_04/data/www/brwmebelspb.ru/backend/ [2] => 1 ) ) ) [previous:Exception:private] => [errorInfo] => Array ( [0] => 42000 [1] => 1064 [2] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `products`.`category_id`=`sections_sub`.`id` AND `products`.`main`' at line 8 ) ) ) 1