[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 at Mayeur Projects'' at line 1] [User Info: SELECT * FROM news WHERE date_format(created_at, '%d') = 26 AND date_format(created_at, '%m') = 07 AND date_format(created_at, '%Y') = 2017 AND headline = 'Jill O'Bryan at Mayeur Projects']

stack trace

• at ()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/vendor/creole/drivers/mysql/MySQLConnection.php line 202 ...
  
  199.         }
  200.         $result = @mysql_query($sql, $this->dblink);
  201.         if (!$result) {
  202.             throw new SQLException('Could not execute query', mysql_error($this->dblink), $sql);
  203.         }
  204.         return new MySQLResultSet($this, $result, $fetchmode);
  205.     }
• at MySQLConnection->executeQuery('SELECT * FROM news WHERE date_format(created_at, '%d') = 26 AND date_format(created_at, '%m') = 07 AND date_format(created_at, '%Y') = 2017 AND headline = 'Jill O'Bryan at Mayeur Projects'', 2)
  in SF_ROOT_DIR/lib/vendor/symfony/lib/vendor/creole/common/StatementCommon.php line 242 ...
  
  239.         if ($this->limit > 0 || $this->offset > 0) {
  240.             $this->conn->applyLimit($sql, $this->offset, $this->limit);
  241.         }
  242.         $this->resultSet = $this->conn->executeQuery($sql, $fetchmode);
  243.         return $this->resultSet;
  244.     }
• at StatementCommon->executeQuery('SELECT * FROM news WHERE date_format(created_at, '%d') = 26 AND date_format(created_at, '%m') = 07 AND date_format(created_at, '%Y') = 2017 AND headline = 'Jill O'Bryan at Mayeur Projects'', 2)
  in SF_ROOT_DIR/lib/model/PostPeer.php line 89 ...
  
  86.       $con = Propel::getConnection("propel");
  87.       $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'";
  88.       $stmt = $con->createStatement();
  89.       $rs = $stmt->executeQuery($sql, ResultSet::FETCHMODE_NUM);
  91.       return parent::populateObjects($rs);
  92.     }
• at PostPeer::getSpecificPost('26', '07', '2017', 'Jill O'Bryan at Mayeur Projects')
  in SF_ROOT_DIR/apps/frontend/modules/news/actions/actions.class.php line 51 ...
  
  49.     if ((!is_numeric($this->getRequestParameter("year"))) || (!is_numeric($this->getRequestParameter("month"))) || (!is_numeric($this->getRequestParameter("day")))) { $this->forward404(); }
  51.     $this->posts = PostPeer::getSpecificPost($this->getRequestParameter("day"), $this->getRequestParameter("month"), $this->getRequestParameter("year"), $this->getRequestParameter("title"));
  52.     $this->allposts = PostPeer::getAllMonths();
  54.     $this->forward404Unless($this->posts);
• at newsActions->executePost()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/action/sfActions.class.php line 62 ...
  
  59.     }
  61.     // run action
  62.     $ret = $this->$actionToRun();
  64.     return $ret;
  65.   }
• at sfActions->execute()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfExecutionFilter.class.php line 129 ...
  
  127.           // execute the action
  128.           $actionInstance->preExecute();
  129.           $viewName = $actionInstance->execute();
  130.           if ($viewName == '')
  131.           {
  132.             $viewName = sfView::SUCCESS;
• at sfExecutionFilter->execute(object('sfFilterChain'))
  in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 43 ...
  
  40.       }
  42.       // execute the next filter
  43.       $this->chain[$this->index]->execute($this);
  44.     }
  45.   }
• at sfFilterChain->execute()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFlashFilter.class.php line 50 ...
  
  47.     }
  49.     // execute next filter
  50.     $filterChain->execute();
  52.     // remove flash that are tagged to be removed
  53.     $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 ...
  
  40.       }
  42.       // execute the next filter
  43.       $this->chain[$this->index]->execute($this);
  44.     }
  45.   }
• at sfFilterChain->execute()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfCommonFilter.class.php line 29 ...
  
  26.   public function execute($filterChain)
  27.   {
  28.     // execute next filter
  29.     $filterChain->execute();
  31.     // execute this filter only once
  32.     $response = $this->getContext()->getResponse();
• at sfCommonFilter->execute(object('sfFilterChain'))
  in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 43 ...
  
  40.       }
  42.       // execute the next filter
  43.       $this->chain[$this->index]->execute($this);
  44.     }
  45.   }
• at sfFilterChain->execute()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfRenderingFilter.class.php line 33 ...
  
  30.   public function execute($filterChain)
  31.   {
  32.     // execute next filter
  33.     $filterChain->execute();
  35.     if (sfConfig::get('sf_logging_enabled'))
  36.     {
• at sfRenderingFilter->execute(object('sfFilterChain'))
  in SF_ROOT_DIR/lib/vendor/symfony/lib/filter/sfFilterChain.class.php line 43 ...
  
  40.       }
  42.       // execute the next filter
  43.       $this->chain[$this->index]->execute($this);
  44.     }
  45.   }
• at sfFilterChain->execute()
  in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfController.class.php line 283 ...
  
  280.         }
  282.         // process the filter chain
  283.         $filterChain->execute();
  284.       }
  285.       else
  286.       {
• at sfController->forward('news', 'post')
  in SF_ROOT_DIR/lib/vendor/symfony/lib/controller/sfFrontWebController.class.php line 48 ...
  
  45.       $actionName = $request->getParameter('action');
  47.       // make the first request
  48.       $this->forward($moduleName, $actionName);
  49.     }
  50.     catch (sfException $e)
  51.     {
• at sfFrontWebController->dispatch()
  in SF_ROOT_DIR/web/index.php line 10 ...
  
  8. require_once(SF_ROOT_DIR.DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.SF_APP.DIRECTORY_SEPARATOR.'config'.DIRECTORY_SEPARATOR.'config.php');
  10. 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: 1713457391.9771
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: 26
    module: news
    month: 07
    title: Jill O'Bryan at Mayeur Projects
    year: 2017
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_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: ZiFI7w6yQ@E4TMuMcFwKWAAAAAc
  REDIRECT_URL: /news/2017/07/26/Jill+O'Bryan+at+Mayeur+Projects
  REMOTE_ADDR: 3.137.175.224
  REMOTE_PORT: 42508
  REQUEST_METHOD: GET
  REQUEST_SCHEME: http
  REQUEST_TIME: 1713457391
  REQUEST_TIME_FLOAT: 1713457391.975
  REQUEST_URI: /news/2017/07/26/Jill+O%27Bryan+at+Mayeur+Projects
  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: ZiFI7w6yQ@E4TMuMcFwKWAAAAAc
  argc: 0
  argv: 
session: 

symfony v.1.0.22-LAST - php 5.4.16
for help resolving this issue, please visit http://www.symfony-project.org/.