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 MariaDB server version for the right syntax to use near '-4' at line 1. Failing Query: "SELECT p.idpost AS p__idpost, p.title AS p__title, p.description AS p__description, p.created_at AS p__created_at, p.archiv AS p__archiv, p.newsletter AS p__newsletter, p.avatar AS p__avatar, p.post_catalog_idpost_catalog AS p__post_catalog_idpost_catalog, p.users_idusers AS p__users_idusers, p.movie_url AS p__movie_url FROM post p ORDER BY p.created_at DESC LIMIT 4 OFFSET -4"
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()
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()
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php line 983 ...
- return $this->_conn->exec($query, $params);
- }
- $stmt = $this->_conn->execute($query, $params);
- $this->_params['exec'] = array();
- at Doctrine_Query_Abstract->_execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/plugins/sfDoctrinePlugin/lib/vendor/doctrine/Doctrine/Query/Abstract.php line 1033 ...
- $result = $this->_constructQueryFromCache($cached);
- }
- } else {
- $stmt = $this->_execute($params);
- if (is_integer($stmt)) {
- $result = $stmt;
- at Doctrine_Query_Abstract->execute()
in SF_ROOT_DIR/apps/page/modules/post/actions/actions.class.php line 21 ...
- $post->limit(sfConfig::get('bpcms_post_max_count_to_page'));
- $post->orderBy('a.created_at DESC');
- $this->posts = $post->execute();
- define('MENU_ACTIVE', 4);
- }
- at postActions->executeIndex()
in SF_ROOT_DIR/lib/vendor/symfony/lib/action/sfActions.class.php line 60 ...
- }
- // run action
- return $this->$actionToRun($request);
- }
- }
-
- at sfActions->execute()
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()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 78 ...
- }
- }
- return $this->executeAction($actionInstance);
- }
- /**
- at sfExecutionFilter->handleAction()
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()
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()
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 238 ...
- }
- // process the filter chain
- $filterChain->execute();
- }
- else
- {
- at sfController->forward()
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 SF_ROOT_DIR/web/index.php line 24 ...
- define('LANG_'.strtoupper($bpcms_lang_text->getTextName()), $bpcms_lang_text->getLangTextValue());
- }
- $context->dispatch();
-
symfony settings ...
bpcms_home_text_1: '"Jakość oraz terminowość stawiamy na pierszym miejscu,<br> dzięki temu jesteśmy w stanie zoferować najwyższy standard."'
bpcms_page_author: '© 2013 REjjo. Created by REjjo. Develop & hosting by blackPAGE'
bpcms_page_description: ''
bpcms_page_gallery_aboutusgallery: '4'
bpcms_page_gallery_certificates: '3'
bpcms_page_gallery_partners: '5'
bpcms_page_gallery_reference: '2'
bpcms_page_keywords: 'docieplanie, ocieplanie, remont, tynk. rusztowania, renowacja, termomodernizacja, izolacje, oszuszanie, malowanie, tynkowanie, usługi, budowlane, materiały, dachy, gipsy, narzędzia, wełna, styropian, granulat, regranulat, zaprawy, posadzki, wentylowane, nieruchomości, hydroizolacja, jakość, dom, sprzedaż, budowa'
bpcms_page_title: 'CIEPŁY DOM - przedsiębiorstwo budowlane'
bpcms_post_max_count_to_page: '4'
bpcms_social_link_fb: 'https://www.facebook.com/Ciepły-DOM-przedsiębiorstwo-budowlane-1417063451948387/?fref=ts'
bpcms_social_link_gplus: '#'
mod_post_enabled: true
mod_post_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: page
sf_app_base_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache/page
sf_app_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache/page/prod
sf_app_config_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/apps/page/config
sf_app_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/apps/page
sf_app_i18n_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/apps/page/i18n
sf_app_lib_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/apps/page/lib
sf_app_module_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/apps/page/modules
sf_app_template_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/apps/page/templates
sf_apps_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/apps
sf_cache: false
sf_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache
sf_charset: utf-8
sf_check_lock: false
sf_compressed: false
sf_config_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache/page/prod/config
sf_config_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/config
sf_csrf_secret: b5c12aa94fc79a6d12a0ae852f2d6a3ff1920bd6
sf_data_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/data
sf_debug: true
sf_default_culture: en
sf_enabled_modules:
- default
sf_environment: prod
sf_error_404_action: 404
sf_error_404_module: default
sf_error_reporting: 341
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: false
sf_etag: true
sf_file_link_format: null
sf_i18n: false
sf_i18n_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache/page/prod/i18n
sf_lib_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/lib
sf_log_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/log
sf_logging_enabled: false
sf_login_action: login
sf_login_module: default
sf_module_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache/page/prod/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: true
sf_orm: doctrine
sf_plugins_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/plugins
sf_root_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
- Partial
- Cache
sf_symfony_lib_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/lib/vendor/symfony/lib
sf_template_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache/page/prod/template
sf_test_cache_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/cache/page/prod/test
sf_test_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/test
sf_upload_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/web/uploads
sf_use_database: true
sf_web_debug: false
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/web
request ...
options:
path_info_key: PATH_INFO
path_info_array: SERVER
http_port: null
https_port: null
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: index
module: post
page: index
attributeHolder:
sf_route: 'sfRoute Object()'
response ...
status:
code: 500
text: 'Internal Server Error'
options:
http_protocol: HTTP/1.0
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
authenticated: false
credentials: { }
lastRequest: 1711695922
global vars ...
cookie: { }
env: { }
files: { }
get: { }
post: { }
server:
CONTEXT_DOCUMENT_ROOT: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/web
CONTEXT_PREFIX: ''
DOCUMENT_ROOT: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/web
FCGI_ROLE: RESPONDER
GATEWAY_INTERFACE: CGI/1.1
HOME: /var/www/vhosts/cieplydomraciborz.pl
HTTPS: on
HTTP_ACCEPT: '*/*'
HTTP_CONNECTION: close
HTTP_HOST: cieplydomraciborz.pl
HTTP_USER_AGENT: claudebot
HTTP_X_ACCEL_INTERNAL: /internal-nginx-static-location
HTTP_X_REAL_IP: 34.231.109.23
PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY: '0'
PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY: '0'
PATH: '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
PERL5LIB: '/usr/share/awstats/lib:/usr/share/awstats/plugins'
PHP_SELF: /index.php
QUERY_STRING: ''
REDIRECT_HTTPS: on
REDIRECT_PASSENGER_COMPILE_NATIVE_SUPPORT_BINARY: '0'
REDIRECT_PASSENGER_DOWNLOAD_NATIVE_SUPPORT_BINARY: '0'
REDIRECT_PERL5LIB: '/usr/share/awstats/lib:/usr/share/awstats/plugins'
REDIRECT_SCRIPT_URI: 'https://cieplydomraciborz.pl/aktualnosci/strona/index.html'
REDIRECT_SCRIPT_URL: /aktualnosci/strona/index.html
REDIRECT_STATUS: '200'
REDIRECT_UNIQUE_ID: ZgZoMrd5gYCXM6jfSDoDcgAAARU
REDIRECT_URL: /aktualnosci/strona/index.html
REMOTE_ADDR: 34.231.109.23
REMOTE_PORT: '55648'
REQUEST_METHOD: GET
REQUEST_SCHEME: https
REQUEST_TIME: 1711695922
REQUEST_TIME_FLOAT: 1711695922.3455
REQUEST_URI: /aktualnosci/strona/index.html
SCRIPT_FILENAME: /var/www/vhosts/cieplydomraciborz.pl/httpdocs/web/index.php
SCRIPT_NAME: /index.php
SCRIPT_URI: 'https://cieplydomraciborz.pl/aktualnosci/strona/index.html'
SCRIPT_URL: /aktualnosci/strona/index.html
SERVER_ADDR: 167.235.100.84
SERVER_ADMIN: root@localhost
SERVER_NAME: cieplydomraciborz.pl
SERVER_PORT: '443'
SERVER_PROTOCOL: HTTP/1.0
SERVER_SIGNATURE: ''
SERVER_SOFTWARE: Apache
UNIQUE_ID: ZgZoMrd5gYCXM6jfSDoDcgAAARU
USER: cieplydom
proxy-nokeepalive: '1'
session: { }