Pagina de erro

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 'group by p.nome' at line 11 [string:Exception:private] => [code:protected] => 42000 [file:protected] => /var/www/maxetour/library/Zend/Db/Statement/Pdo.php [line:protected] => 234 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/maxetour/library/Zend/Db/Statement.php [line] => 300 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /var/www/maxetour/library/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /var/www/maxetour/library/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => select p.nome from pacotes p left join destino_categorias pc on p.id = pc.pacote_id left join categoria c on pc.categoria_id = c.id left join destinos d on pc.destino_id = d.id where 1 and ( p.cidade = 'madri' or p.tags like '%madri%' ) and pc.categoria_id = 48 and pc.status = 1 and pc.nivel2_id = group by p.nome [1] => Array ( ) ) ) [3] => Array ( [file] => /var/www/maxetour/application/models/Pacotes.php [line] => 441 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => select p.nome from pacotes p left join destino_categorias pc on p.id = pc.pacote_id left join categoria c on pc.categoria_id = c.id left join destinos d on pc.destino_id = d.id where 1 and ( p.cidade = 'madri' or p.tags like '%madri%' ) and pc.categoria_id = 48 and pc.status = 1 and pc.nivel2_id = group by p.nome ) ) [4] => Array ( [file] => /var/www/maxetour/application/controllers/PacoteController.php [line] => 119 [function] => getNamePacotes [class] => Application_Model_Pacotes [type] => :: [args] => Array ( [0] => Array ( [tipo] => internacional [aba] => ver%C3%A3o [destino] => madri [roteiro] => [id_aba] => ) [1] => 48 ) ) [5] => Array ( [file] => /var/www/maxetour/library/Zend/Controller/Action.php [line] => 516 [function] => cvcAction [class] => pacoteController [type] => -> [args] => Array ( ) ) [6] => Array ( [file] => /var/www/maxetour/library/Zend/Controller/Dispatcher/Standard.php [line] => 295 [function] => dispatch [class] => Zend_Controller_Action [type] => -> [args] => Array ( [0] => cvcAction ) ) [7] => Array ( [file] => /var/www/maxetour/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] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_params:protected] => Array ( [controller] => pacote [action] => cvc [tipo] => internacional [aba] => ver%C3%A3o [destino] => madri [module] => default [error_handler] => ArrayObject Object ( [storage:ArrayObject:private] => Array ( [exception] => Zend_Db_Statement_Exception Object *RECURSION* [type] => EXCEPTION_OTHER [request] => Zend_Controller_Request_Http Object ( [_paramSources:protected] => Array ( [0] => _GET [1] => _POST ) [_requestUri:protected] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_params:protected] => Array ( [controller] => pacote [action] => cvc [tipo] => internacional [aba] => ver%C3%A3o [destino] => madri [module] => default ) [_rawBody:protected] => [_aliases:protected] => Array ( ) [_dispatched:protected] => 1 [_module:protected] => default [_moduleKey:protected] => module [_controller:protected] => pacote [_controllerKey:protected] => controller [_action:protected] => cvc [_actionKey:protected] => action ) ) ) ) [_rawBody:protected] => [_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] => 500 [_isRedirect:protected] => [_renderExceptions:protected] => [headersSentThrowsException] => 1 ) ) ) [8] => Array ( [file] => /var/www/maxetour/library/Zend/Application/Bootstrap/Bootstrap.php [line] => 97 [function] => dispatch [class] => Zend_Controller_Front [type] => -> [args] => Array ( ) ) [9] => Array ( [file] => /var/www/maxetour/library/Zend/Application.php [line] => 366 [function] => run [class] => Zend_Application_Bootstrap_Bootstrap [type] => -> [args] => Array ( ) ) [10] => Array ( [file] => /var/www/maxetour/public/index.php [line] => 57 [function] => run [class] => Zend_Application [type] => -> [args] => Array ( ) ) ) [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 'group by p.nome' at line 11 [string:Exception:private] => [code:protected] => 42000 [file:protected] => /var/www/maxetour/library/Zend/Db/Statement/Pdo.php [line:protected] => 228 [trace:Exception:private] => Array ( [0] => Array ( [file] => /var/www/maxetour/library/Zend/Db/Statement/Pdo.php [line] => 228 [function] => execute [class] => PDOStatement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [1] => Array ( [file] => /var/www/maxetour/library/Zend/Db/Statement.php [line] => 300 [function] => _execute [class] => Zend_Db_Statement_Pdo [type] => -> [args] => Array ( [0] => Array ( ) ) ) [2] => Array ( [file] => /var/www/maxetour/library/Zend/Db/Adapter/Abstract.php [line] => 479 [function] => execute [class] => Zend_Db_Statement [type] => -> [args] => Array ( [0] => Array ( ) ) ) [3] => Array ( [file] => /var/www/maxetour/library/Zend/Db/Adapter/Pdo/Abstract.php [line] => 238 [function] => query [class] => Zend_Db_Adapter_Abstract [type] => -> [args] => Array ( [0] => select p.nome from pacotes p left join destino_categorias pc on p.id = pc.pacote_id left join categoria c on pc.categoria_id = c.id left join destinos d on pc.destino_id = d.id where 1 and ( p.cidade = 'madri' or p.tags like '%madri%' ) and pc.categoria_id = 48 and pc.status = 1 and pc.nivel2_id = group by p.nome [1] => Array ( ) ) ) [4] => Array ( [file] => /var/www/maxetour/application/models/Pacotes.php [line] => 441 [function] => query [class] => Zend_Db_Adapter_Pdo_Abstract [type] => -> [args] => Array ( [0] => select p.nome from pacotes p left join destino_categorias pc on p.id = pc.pacote_id left join categoria c on pc.categoria_id = c.id left join destinos d on pc.destino_id = d.id where 1 and ( p.cidade = 'madri' or p.tags like '%madri%' ) and pc.categoria_id = 48 and pc.status = 1 and pc.nivel2_id = group by p.nome ) ) [5] => Array ( [file] => /var/www/maxetour/application/controllers/PacoteController.php [line] => 119 [function] => getNamePacotes [class] => Application_Model_Pacotes [type] => :: [args] => Array ( [0] => Array ( [tipo] => internacional [aba] => ver%C3%A3o [destino] => madri [roteiro] => [id_aba] => ) [1] => 48 ) ) [6] => Array ( [file] => /var/www/maxetour/library/Zend/Controller/Action.php [line] => 516 [function] => cvcAction [class] => pacoteController [type] => -> [args] => Array ( ) ) [7] => Array ( [file] => /var/www/maxetour/library/Zend/Controller/Dispatcher/Standard.php [line] => 295 [function] => dispatch [class] => Zend_Controller_Action [type] => -> [args] => Array ( [0] => cvcAction ) ) [8] => Array ( [file] => /var/www/maxetour/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] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_params:protected] => Array ( [controller] => pacote [action] => cvc [tipo] => internacional [aba] => ver%C3%A3o [destino] => madri [module] => default [error_handler] => ArrayObject Object ( [storage:ArrayObject:private] => Array ( [exception] => Zend_Db_Statement_Exception Object *RECURSION* [type] => EXCEPTION_OTHER [request] => Zend_Controller_Request_Http Object ( [_paramSources:protected] => Array ( [0] => _GET [1] => _POST ) [_requestUri:protected] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_baseUrl:protected] => [_basePath:protected] => [_pathInfo:protected] => /pacote/cvc/tipo/internacional/aba/ver%25C3%25A3o/destino/madri [_params:protected] => Array ( [controller] => pacote [action] => cvc [tipo] => internacional [aba] => ver%C3%A3o [destino] => madri [module] => default ) [_rawBody:protected] => [_aliases:protected] => Array ( ) [_dispatched:protected] => 1 [_module:protected] => default [_moduleKey:protected] => module [_controller:protected] => pacote [_controllerKey:protected] => controller [_action:protected] => cvc [_actionKey:protected] => action ) ) ) ) [_rawBody:protected] => [_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] => 500 [_isRedirect:protected] => [_renderExceptions:protected] => [headersSentThrowsException] => 1 ) ) ) [9] => Array ( [file] => /var/www/maxetour/library/Zend/Application/Bootstrap/Bootstrap.php [line] => 97 [function] => dispatch [class] => Zend_Controller_Front [type] => -> [args] => Array ( ) ) [10] => Array ( [file] => /var/www/maxetour/library/Zend/Application.php [line] => 366 [function] => run [class] => Zend_Application_Bootstrap_Bootstrap [type] => -> [args] => Array ( ) ) [11] => Array ( [file] => /var/www/maxetour/public/index.php [line] => 57 [function] => run [class] => Zend_Application [type] => -> [args] => Array ( ) ) ) [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 'group by p.nome' at line 11 ) ) ) 1