[SQLException]
Could not execute query [Native Error: 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 'Janus' selected as one of the Must See Painting Shows for October '' at line 1] [User Info: SELECT * FROM news WHERE date_format(created_at, '%d') = 06 AND date_format(created_at, '%m') = 11 AND date_format(created_at, '%Y') = 2014 AND headline = ''Janus' selected as one of the Must See Painting Shows for October ']
stack trace
- at ()
in SF_ROOT_DIR/lib/vendor/symfony/lib/vendor/creole/drivers/mysql/MySQLConnection.php line 202 ...
- }
- $result = @mysql_query($sql, $this->dblink);
- if (!$result) {
- throw new SQLException('Could not execute query', mysql_error($this->dblink), $sql);
- }
- return new MySQLResultSet($this, $result, $fetchmode);
- }
- at MySQLConnection->executeQuery('SELECT * FROM news WHERE date_format(created_at, '%d') = 06 AND date_format(created_at, '%m') = 11 AND date_format(created_at, '%Y') = 2014 AND headline = ''Janus' selected as one of the Must See Painting Shows for October '', 2)
in SF_ROOT_DIR/lib/vendor/symfony/lib/vendor/creole/common/StatementCommon.php line 242 ...
- if ($this->limit > 0 || $this->offset > 0) {
- $this->conn->applyLimit($sql, $this->offset, $this->limit);
- }
- $this->resultSet = $this->conn->executeQuery($sql, $fetchmode);
- return $this->resultSet;
- }
- at StatementCommon->executeQuery('SELECT * FROM news WHERE date_format(created_at, '%d') = 06 AND date_format(created_at, '%m') = 11 AND date_format(created_at, '%Y') = 2014 AND headline = ''Janus' selected as one of the Must See Painting Shows for October '', 2)
in SF_ROOT_DIR/lib/model/PostPeer.php line 89 ...
- $con = Propel::getConnection("propel");
- $sql = "SELECT * FROM news WHERE date_format(created_at, '%d') = $day AND date_format(created_at, '%m') = $month AND date_format(created_at, '%Y') = $year AND headline = '$title'";
- $stmt = $con->createStatement();
- $rs = $stmt->executeQuery($sql, ResultSet::FETCHMODE_NUM);
- return parent::populateObjects($rs);
- }
- at PostPeer::getSpecificPost('06', '11', '2014', ''Janus' selected as one of the Must See Painting Shows for October ')
in SF_ROOT_DIR/apps/frontend/modules/news/actions/actions.class.php line 51 ...
- if ((!is_numeric($this->getRequestParameter("year"))) || (!is_numeric($this->getRequestParameter("month"))) || (!is_numeric($this->getRequestParameter("day")))) { $this->forward404(); }
- $this->posts = PostPeer::getSpecificPost($this->getRequestParameter("day"), $this->getRequestParameter("month"), $this->getRequestParameter("year"), $this->getRequestParameter("title"));
- $this->allposts = PostPeer::getAllMonths();
- $this->forward404Unless($this->posts);
- at newsActions->executePost()
in SF_ROOT_DIR/lib/vendor/symfony/lib/action/sfActions.class.php line 62 ...
- }
- // run action
- $ret = $this->$actionToRun();
- return $ret;
- }
- at sfActions->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 129 ...
- // execute the action
- $actionInstance->preExecute();
- $viewName = $actionInstance->execute();
- if ($viewName == '')
- {
- $viewName = sfView::SUCCESS;
- at sfExecutionFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 43 ...
- }
- // execute the next filter
- $this->chain[$this->index]->execute($this);
- }
- }
- at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFlashFilter.class.php line 50 ...
- }
- // execute next filter
- $filterChain->execute();
- // remove flash that are tagged to be removed
- $names = $userAttributeHolder->getNames('symfony/flash/remove');
- at sfFlashFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 43 ...
- }
- // execute the next filter
- $this->chain[$this->index]->execute($this);
- }
- }
- at sfFilterChain->execute()
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfCommonFilter.class.php line 29 ...
- public function execute($filterChain)
- {
- // execute next filter
- $filterChain->execute();
- // execute this filter only once
- $response = $this->getContext()->getResponse();
- at sfCommonFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 43 ...
- }
- // 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();
- if (sfConfig::get('sf_logging_enabled'))
- {
- at sfRenderingFilter->execute(object('sfFilterChain'))
in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 43 ...
- }
- // 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 283 ...
- }
- // process the filter chain
- $filterChain->execute();
- }
- else
- {
- at sfController->forward('news', 'post')
in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfFrontWebController.class.php line 48 ...
- $actionName = $request->getParameter('action');
- // make the first request
- $this->forward($moduleName, $actionName);
- }
- catch (sfException $e)
- {
- at sfFrontWebController->dispatch()
in SF_ROOT_DIR/web/index.php line 10 ...
- require_once(SF_ROOT_DIR.DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.SF_APP.DIRECTORY_SEPARATOR.'config'.DIRECTORY_SEPARATOR.'config.php');
- sfContext::getInstance()->getController()->dispatch();
-
symfony settings ...
---
app_sfPropelSyncContentPlugin_content:
- web/uploads
mod_news_enabled: 1
mod_news_is_internal:
mod_news_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: /var/www/galleryjoe/symfony/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: /var/www/galleryjoe/symfony/apps/frontend
sf_app_i18n_dir: /var/www/galleryjoe/symfony/apps/frontend/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: /var/www/galleryjoe/symfony/apps/frontend/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: /var/www/galleryjoe/symfony/apps/frontend/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: /var/www/galleryjoe/symfony/apps/frontend/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions:
sf_available: 1
sf_base_cache_dir: /var/www/galleryjoe/symfony/cache/frontend
sf_bin_dir: /var/www/galleryjoe/symfony/batch
sf_bin_dir_name: batch
sf_cache:
sf_cache_dir: /var/www/galleryjoe/symfony/cache/frontend/prod
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock:
sf_check_symfony_version:
sf_compressed:
sf_config_cache_dir: /var/www/galleryjoe/symfony/cache/frontend/prod/config
sf_config_dir: /var/www/galleryjoe/symfony/config
sf_config_dir_name: config
sf_data_dir: /var/www/galleryjoe/symfony/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: /var/www/galleryjoe/symfony/data/doc
sf_doc_dir_name: doc
sf_enabled_modules:
- default
sf_environment: prod
sf_error_404_action: error404
sf_error_404_module: error
sf_error_reporting: 341
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 1
sf_i18n:
sf_i18n_cache_dir: /var/www/galleryjoe/symfony/cache/frontend/prod/i18n
sf_lazy_cache_key:
sf_lib_dir: /var/www/galleryjoe/symfony/lib
sf_lib_dir_name: lib
sf_log_dir: /var/www/galleryjoe/symfony/log
sf_log_dir_name: log
sf_logging_enabled:
sf_logging_history: 10
sf_logging_level: err
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate:
sf_login_action: login
sf_login_module: default
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: /var/www/galleryjoe/symfony/lib/model
sf_module_cache_dir: /var/www/galleryjoe/symfony/cache/frontend/prod/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 1
sf_orm: propel
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: /var/www/galleryjoe/symfony/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: /var/www/galleryjoe/symfony/cache
sf_root_dir: /var/www/galleryjoe/symfony
sf_routing_defaults:
sf_culture: en
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers:
- Partial
- Cache
- Form
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: /var/www/galleryjoe/symfony/config/../lib/vendor/symfony/data
sf_symfony_lib_dir: /var/www/galleryjoe/symfony/config/../lib/vendor/symfony/lib
sf_template_cache_dir: /var/www/galleryjoe/symfony/cache/frontend/prod/template
sf_test:
sf_test_cache_dir: /var/www/galleryjoe/symfony/cache/frontend/prod/test
sf_test_dir: /var/www/galleryjoe/symfony/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1711666676.6556
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: /var/www/galleryjoe/symfony/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix: ↓
sf_validation_error_suffix: ↓
sf_web_debug:
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /var/www/galleryjoe/symfony/web
sf_web_dir_name: web
request ...
---
parameterHolder:
symfony/default:
action: post
day: 06
module: news
month: 11
title: 'Janus' selected as one of the Must See Painting Shows for October
year: 2014
attributeHolder:
symfony/default:
response ...
---
cookies:
httpHeaders:
parameterHolder:
global vars ...
---
cookie:
env:
LANG: C
NOTIFY_SOCKET: /run/systemd/notify
PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
files:
get:
post:
server:
CONTEXT_DOCUMENT_ROOT: /var/www/galleryjoe/symfony/web
CONTEXT_PREFIX:
DOCUMENT_ROOT: /var/www/galleryjoe/symfony/web
GATEWAY_INTERFACE: CGI/1.1
HTTP_ACCEPT: */*
HTTP_HOST: www.galleryjoe.com
HTTP_REFERER: http://galleryjoe.com/news/2014/11/06/%27Janus%27+selected+as+one+of+the+Must+See+Painting+Shows+for+October+
HTTP_USER_AGENT: claudebot
PATH: /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
PHP_SELF: /index.php
QUERY_STRING:
REDIRECT_STATUS: 200
REDIRECT_UNIQUE_ID: ZgX19DlauWC7sVF6bVXJHgAAAAQ
REDIRECT_URL: /news/2014/11/06/'Janus'+selected+as+one+of+the+Must+See+Painting+Shows+for+October+
REMOTE_ADDR: 3.230.76.153
REMOTE_PORT: 49330
REQUEST_METHOD: GET
REQUEST_SCHEME: http
REQUEST_TIME: 1711666676
REQUEST_TIME_FLOAT: 1711666676.651
REQUEST_URI: /news/2014/11/06/'Janus'+selected+as+one+of+the+Must+See+Painting+Shows+for+October+
SCRIPT_FILENAME: /var/www/galleryjoe/symfony/web/index.php
SCRIPT_NAME: /index.php
SERVER_ADDR: 69.164.213.26
SERVER_ADMIN: root@localhost
SERVER_NAME: www.galleryjoe.com
SERVER_PORT: 80
SERVER_PROTOCOL: HTTP/1.1
SERVER_SIGNATURE:
SERVER_SOFTWARE: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/5.4.16
UNIQUE_ID: ZgX19DlauWC7sVF6bVXJHgAAAAQ
argc: 0
argv:
session: