500 | Internal Server Error | Doctrine_Connection_Mysql_Exception
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 '-1' at line 1. Failing Query: "SELECT a.id AS a__id FROM a_edificis a WHERE (a.poblacio LIKE '%Ventall%C3%B3%') ORDER BY a.id LIMIT 1 OFFSET -1"
stack trace
- at ()
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php line 1082 ...
- $message .= sprintf('. Failing Query: "%s"', $query);
- }
-
- $exc = new $name($message, (int) $e->getCode());
- if ( ! isset($e->errorInfo) || ! is_array($e->errorInfo)) {
- $e->errorInfo = array(null, null, null, null);
- }
- at Doctrine_Connection->rethrowException(object('PDOException'), object('Doctrine_Connection_Mysql'), 'SELECT a.id AS a__id FROM a_edificis a WHERE (a.poblacio LIKE '%Ventall%C3%B3%') ORDER BY a.id LIMIT 1 OFFSET -1')
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Connection.php line 1025 ...
- } catch (Doctrine_Adapter_Exception $e) {
- } catch (PDOException $e) { }
-
- $this->rethrowException($e, $this, $query);
- }
-
- /**
- at Doctrine_Connection->execute('SELECT a.id AS a__id FROM a_edificis a WHERE (a.poblacio LIKE '%Ventall%C3%B3%') ORDER BY a.id LIMIT 1 OFFSET -1', array())
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php line 976 ...
- return $this->_conn->exec($query, $params);
- }
-
- $stmt = $this->_conn->execute($query, $params);
-
- $this->_params['exec'] = array();
-
- at Doctrine_Query_Abstract->_execute(array())
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php line 1026 ...
- $result = $this->_constructQueryFromCache($cached);
- }
- } else {
- $stmt = $this->_execute($params);
-
- if (is_integer($stmt)) {
- $result = $stmt;
- at Doctrine_Query_Abstract->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/pager/sfDoctrinePager.class.php line 174 ...
- ->limit(1)
- ;
-
- $results = $queryForRetrieve->execute();
-
- return $results[0];
- }
- at sfDoctrinePager->retrieveObject(0)
in SF_ROOT_DIR/lib/vendor/symfony/lib/addon/sfPager.class.php line 193 ...
- */
- public function getCurrent()
- {
- return $this->retrieveObject($this->cursor);
- }
-
- /**
- at sfPager->getCurrent()
in SF_ROOT_DIR/lib/vendor/symfony/lib/addon/sfPager.class.php line 183 ...
- {
- $this->setCursor($pos);
-
- return $this->getCurrent();
- }
-
- /**
- at sfPager->getObjectByCursor('29')
in SF_ROOT_DIR/apps/frontend/modules/edificis/actions/actions.class.php line 155 ...
- $this->pager->setPage($request->getParameter('page', 1));
- $this->pager->setCursor($request->getParameter('pos', 1));
- $this->pager->init();
- $this->edifici = $this->pager->getObjectByCursor($request->getParameter('pos', 1));
- $this->fer_navegacio = true;
- }
-
- at edificisActions->executeDadesFitxa(object('sfWebRequest'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/action/sfActions.class.php line 60 ...
- }
-
- // run action
- return $this->$actionToRun($request);
- }
- }
-
- at sfActions->execute(object('sfWebRequest'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 92 ...
- {
- // execute the action
- $actionInstance->preExecute();
- $viewName = $actionInstance->execute($this->context->getRequest());
- $actionInstance->postExecute();
-
- return null === $viewName ? sfView::SUCCESS : $viewName;
- at sfExecutionFilter->executeAction(object('edificisActions'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 78 ...
- }
- }
-
- return $this->executeAction($actionInstance);
- }
-
- /**
- at sfExecutionFilter->handleAction(object('sfFilterChain'), object('edificisActions'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 53 ...
- }
- else
- {
- $viewName = $this->handleAction($filterChain, $actionInstance);
- $this->handleView($filterChain, $actionInstance, $viewName);
- }
- }
- at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
- }
-
- // execute the next filter
- $this->chain[$this->index]->execute($this);
- }
- }
-
- at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfRenderingFilter.class.php line 33 ...
- public function execute($filterChain)
- {
- // execute next filter
- $filterChain->execute();
-
- // get response object
- $response = $this->context->getResponse();
- at sfRenderingFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 53 ...
- }
-
- // execute the next filter
- $this->chain[$this->index]->execute($this);
- }
- }
-
- at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfController.class.php line 233 ...
- }
-
- // process the filter chain
- $filterChain->execute();
- }
- else
- {
- at sfController->forward('edificis', 'dadesFitxa')
in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfFrontWebController.class.php line 48 ...
- }
-
- // make the first request
- $this->forward($moduleName, $actionName);
- }
- catch (sfException $e)
- {
- at sfFrontWebController->dispatch()
in SF_ROOT_DIR/lib/vendor/symfony/lib/util/sfContext.class.php line 170 ...
- */
- public function dispatch()
- {
- $this->getController()->dispatch();
- }
-
- /**
- at sfContext->dispatch()
in /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/index.php line 7 ...
- require_once(dirname(__FILE__).'/symfony/config/ProjectConfiguration.class.php');
-
- $configuration = ProjectConfiguration::getApplicationConfiguration('frontend', 'prod', true);
- sfContext::createInstance($configuration)->dispatch();
-
-
symfony settings ...
app_max_autors: 10
app_max_correspondencia: 10
app_max_dibuixos: 10
app_max_edificis: 10
app_max_edificis_guia: 20
app_max_imatges: 10
app_max_imatges_guia: 10
app_max_projectes: 10
mod_edificis_enabled: true
mod_edificis_view_class: sfPHP
seccio_dades: true
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache/frontend
sf_app_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache/frontend/prod
sf_app_config_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/apps/frontend/config
sf_app_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/apps/frontend
sf_app_i18n_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/apps/frontend/i18n
sf_app_lib_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/apps/frontend/lib
sf_app_module_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/apps/frontend/modules
sf_app_template_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/apps/frontend/templates
sf_apps_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/apps
sf_cache: false
sf_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache/frontend/prod/config
sf_config_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/config
sf_csrf_secret: cb8c9f1c8656567886ab108b8aeadc58cc7c1e0a
sf_data_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/data
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
- sfJqueryReloadedPlugin
sf_environment: prod
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 341
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: true
sf_file_link_format: null
sf_i18n: false
sf_i18n_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache/frontend/prod/i18n
sf_jquery_autocomplete: jquery.autocomplete.min.js
sf_jquery_core: jquery-1.4.2.min.js
sf_jquery_path: null
sf_jquery_plugin_paths: null
sf_jquery_ui: jquery-ui-1.7.2.custom.min.js
sf_jquery_web_dir: /sfJqueryReloadedPlugin
sf_lib_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/lib
sf_log_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/log
sf_logging_enabled: false
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache/frontend/prod/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: true
sf_orm: doctrine
sf_plugins_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/plugins
sf_root_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
- Partial
- jQuery
sf_symfony_lib_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/lib/vendor/symfony/lib
sf_template_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache/frontend/prod/template
sf_test_cache_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/cache/frontend/prod/test
sf_test_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/test
sf_upload_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/..//uploads
sf_use_database: true
sf_web_debug: false
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /site.web/coac/htdocs/COAC/centredocumentacio/Girona/arxiu/symfony/../
request ...
options:
path_info_key: PATH_INFO
path_info_array: SERVER
default_format: null
logging: ''
relative_url_root: null
formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml }
no_script_name: true
parameterHolder:
action: dadesFitxa
adreca: ''
autor: ''
denominacio: ''
module: edificis
page: '3'
poblacio: Ventall%C3%B3
pos: '29'
registre: ''
attributeHolder:
sf_route: 'sfRoute Object()'
response ...
status:
code: 500
text: 'Internal Server Error'
options:
http_protocol: HTTP/1.1
logging: ''
charset: utf-8
send_http_headers: true
content_type: 'text/html; charset=utf-8'
cookies: { }
httpHeaders:
Content-Type: 'text/html; charset=utf-8'
javascripts: { }
stylesheets: { }
metas: { }
httpMetas: { }
options:
auto_shutdown: false
culture: null
default_culture: en
use_flash: true
logging: ''
timeout: 1800
attributeHolder: { }
culture: en
global vars ...
cookie: { }
env: { }
files: { }
get:
adreca: ''
autor: ''
denominacio: ''
page: '3'
poblacio: Ventall%C3%B3
pos: '29'
registre: ''
post: { }
server:
DOCUMENT_ROOT: /web/htdocs
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: '*/*'
HTTP_HOST: www.coac.net
HTTP_USER_AGENT: claudebot
PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
PHP_SELF: /COAC/centredocumentacio/Girona/arxiu/index.php
QUERY_STRING: 'registre=&autor=&denominacio=&adreca=&poblacio=Ventall%25C3%25B3&page=3&pos=29'
REDIRECT_QUERY_STRING: 'registre=&autor=&denominacio=&adreca=&poblacio=Ventall%25C3%25B3&page=3&pos=29'
REDIRECT_SCRIPT_URI: 'http://www.coac.net/COAC/centredocumentacio/Girona/arxiu/edificis/dades/fitxa.html'
REDIRECT_SCRIPT_URL: /COAC/centredocumentacio/Girona/arxiu/edificis/dades/fitxa.html
REDIRECT_STATUS: '200'
REDIRECT_URL: /COAC/centredocumentacio/Girona/arxiu/edificis/dades/fitxa.html
REMOTE_ADDR: 3.234.212.253
REMOTE_PORT: '46746'
REQUEST_METHOD: GET
REQUEST_TIME: 1711694492
REQUEST_URI: '/COAC/centredocumentacio/Girona/arxiu/edificis/dades/fitxa.html?registre=&autor=&denominacio=&adreca=&poblacio=Ventall%25C3%25B3&page=3&pos=29'
SCRIPT_FILENAME: /web/htdocs/COAC/centredocumentacio/Girona/arxiu/index.php
SCRIPT_NAME: /COAC/centredocumentacio/Girona/arxiu/index.php
SCRIPT_URI: 'http://www.coac.net/COAC/centredocumentacio/Girona/arxiu/edificis/dades/fitxa.html'
SCRIPT_URL: /COAC/centredocumentacio/Girona/arxiu/edificis/dades/fitxa.html
SERVER_ADDR: 172.31.1.5
SERVER_ADMIN: webmaster@coac.net
SERVER_NAME: www.coac.net
SERVER_PORT: '80'
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE: "<address>Apache Server at www.coac.net Port 80</address>\n"
SERVER_SOFTWARE: Apache
session: { }