[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 'Bryan review by Edith Newhall in The Philadelphia Inquirer'' at line 1] [User Info: SELECT * FROM news WHERE date_format(created_at, '%d') = 06 AND date_format(created_at, '%m') = 05 AND date_format(created_at, '%Y') = 2012 AND headline = 'Jill O'Bryan review by Edith Newhall in The Philadelphia Inquirer']
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') = 05 AND date_format(created_at, '%Y') = 2012 AND headline = 'Jill O'Bryan review by Edith Newhall in The Philadelphia Inquirer'', 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') = 05 AND date_format(created_at, '%Y') = 2012 AND headline = 'Jill O'Bryan review by Edith Newhall in The Philadelphia Inquirer'', 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', '05', '2012', 'Jill O'Bryan review by Edith Newhall in The Philadelphia Inquirer')
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: 1711711194.2942
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: 05
title: Jill O'Bryan review by Edith Newhall in The Philadelphia Inquirer
year: 2012
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/2012/05/06/Jill+O%27Bryan+review+by+Edith+Newhall+in+The+Philadelphia+Inquirer
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: Zgaj2hPaFyViC-z564mzaQAAAAc
REDIRECT_URL: /news/2012/05/06/Jill+O'Bryan+review+by+Edith+Newhall+in+The+Philadelphia+Inquirer
REMOTE_ADDR: 3.209.56.116
REMOTE_PORT: 53304
REQUEST_METHOD: GET
REQUEST_SCHEME: http
REQUEST_TIME: 1711711194
REQUEST_TIME_FLOAT: 1711711194.292
REQUEST_URI: /news/2012/05/06/Jill+O'Bryan+review+by+Edith+Newhall+in+The+Philadelphia+Inquirer
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: Zgaj2hPaFyViC-z564mzaQAAAAc
argc: 0
argv:
session: