Array ( [zona] => el-espinillo [module] => real-estate [controller] => property [action] => zonapiso.html [error_handler] => ArrayObject Object ( [storage:ArrayObject:private] => Array ( [exception] => Zend_Db_Statement_Exception 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 'ORDER BY idproperty DESC' at line 17 [string:Exception:private] => [code:protected] => 0 [file:protected] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Db/Statement/Pdo.php [line:protected] => 238 [trace:Exception:private] => Array ( [0] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Db/Statement.php [line] => 283 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Db/Adapter/Abstract.php [line] => 430 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Db/Adapter/Pdo/Abstract.php [line] => 220 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => SELECT `idproperty`, `reference`, `typeofoffer`, `typeofproperty`, `addressstreet`, `price`, `bathrooms`, `bedrooms`, `surface`, `highlight`, `available`, `creation`, `re_data_areas`.`name` AS `area`, `re_data_zones`.`name` AS `zone` FROM `re_properties` LEFT OUTER JOIN `re_data_areas` ON `re_properties`.`idarea`=`re_data_areas`.`idarea` LEFT OUTER JOIN `re_data_zones` ON `re_properties`.`idzone`=`re_data_zones`.`idzone` WHERE `re_properties`.`typeofproperty` = 1 AND `re_properties`.`idzone` = ORDER BY idproperty DESC; [1] => Array ( ) ) ) [3] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Db/Adapter/Abstract.php [line] => 641 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => SELECT `idproperty`, `reference`, `typeofoffer`, `typeofproperty`, `addressstreet`, `price`, `bathrooms`, `bedrooms`, `surface`, `highlight`, `available`, `creation`, `re_data_areas`.`name` AS `area`, `re_data_zones`.`name` AS `zone` FROM `re_properties` LEFT OUTER JOIN `re_data_areas` ON `re_properties`.`idarea`=`re_data_areas`.`idarea` LEFT OUTER JOIN `re_data_zones` ON `re_properties`.`idzone`=`re_data_zones`.`idzone` WHERE `re_properties`.`typeofproperty` = 1 AND `re_properties`.`idzone` = ORDER BY idproperty DESC; [1] => Array ( ) ) ) [4] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/models/ModelReProperties.php [line] => 297 [function] => fetchAll [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => SELECT `idproperty`, `reference`, `typeofoffer`, `typeofproperty`, `addressstreet`, `price`, `bathrooms`, `bedrooms`, `surface`, `highlight`, `available`, `creation`, `re_data_areas`.`name` AS `area`, `re_data_zones`.`name` AS `zone` FROM `re_properties` LEFT OUTER JOIN `re_data_areas` ON `re_properties`.`idarea`=`re_data_areas`.`idarea` LEFT OUTER JOIN `re_data_zones` ON `re_properties`.`idzone`=`re_data_zones`.`idzone` WHERE `re_properties`.`typeofproperty` = 1 AND `re_properties`.`idzone` = ORDER BY idproperty DESC; ) ) [5] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/modules/real-estate/controllers/PropertyController.php [line] => 305 [function] => fetchList [class] => ModelReProperties [type] => -> [args] => Array ( [0] => `re_properties`.`typeofproperty` = 1 AND `re_properties`.`idzone` = ) ) [6] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/modules/real-estate/controllers/PropertyController.php [line] => 223 [function] => listarResultado [class] => RealEstate_PropertyController [type] => -> [args] => Array ( [0] => `re_properties`.`typeofproperty` = 1 AND `re_properties`.`idzone` = ) ) [7] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Controller/Action.php [line] => 502 [function] => zonapisoHtmlAction [class] => RealEstate_PropertyController [type] => -> [args] => Array ( ) ) [8] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Controller/Dispatcher/Standard.php [line] => 293 [function] => dispatch [class] => Zend_Controller_Action [type] => -> [args] => Array ( [0] => zonapisoHtmlAction ) ) [9] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Zend/Controller/Front.php [line] => 946 [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] => /pisos-el-espinillo.html [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /pisos-el-espinillo.html [_params:protected] => Array ( [zona] => el-espinillo [module] => real-estate [controller] => property [action] => zonapiso.html [error_handler] => ArrayObject Object *RECURSION* ) [_aliases:protected] => Array ( ) [_dispatched:protected] => 1 [_module:protected] => default [_moduleKey:protected] => module [_controller:protected] => error [_controllerKey:protected] => controller [_action:protected] => error [_actionKey:protected] => action ) [1] => Zend_Controller_Response_Http Object ( [_body:protected] => Array ( ) [_exceptions:protected] => Array ( [0] => Zend_Db_Statement_Exception Object *RECURSION* ) [_headers:protected] => Array ( ) [_headersRaw:protected] => Array ( ) [_httpResponseCode:protected] => 200 [_isRedirect:protected] => [_renderExceptions:protected] => [headersSentThrowsException] => 1 ) ) ) [10] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/library/Byo/Application.php [line] => 53 [function] => dispatch [class] => Zend_Controller_Front [type] => -> [args] => Array ( ) ) [11] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/application.php [line] => 7 [function] => start [class] => Byo_Application [type] => :: [args] => Array ( [0] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application ) ) [12] => Array ( [file] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/index.php [line] => 6 [args] => Array ( [0] => /usr/home/uPmc57g4yyJb/asetrainmo.com/web/application/application.php ) [function] => require_once ) ) [previous:Exception:private] => ) [type] => EXCEPTION_OTHER [request] => Zend_Controller_Request_Http Object ( [_paramSources:protected] => Array ( [0] => _GET [1] => _POST ) [_requestUri:protected] => /pisos-el-espinillo.html [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /pisos-el-espinillo.html [_params:protected] => Array ( [zona] => el-espinillo [module] => real-estate [controller] => property [action] => zonapiso.html ) [_aliases:protected] => Array ( ) [_dispatched:protected] => 1 [_module:protected] => real-estate [_moduleKey:protected] => module [_controller:protected] => property [_controllerKey:protected] => controller [_action:protected] => zonapiso.html [_actionKey:protected] => action ) ) ) [language] => es [page] => property/list [hoja] => 1 )