stack trace * at () in SF_ROOT_DIR\lib\symfony\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 DISTINCT(client_id) AS client_id FROM pot_visitors ORDER BY client_id', null) in SF_ROOT_DIR\lib\symfony\vendor\creole\common\PreparedStatementCommon.php line 333 ... 330. $this->conn->applyLimit($sql, $this->offset, $this->limit); 331. } 332. 333. $this->resultSet = $this->conn->executeQuery($sql, $fetchmode); 334. return $this->resultSet; 335. } 336. * at PreparedStatementCommon->executeQuery() in SF_ROOT_DIR\apps\reports\modules\home\actions\actions.class.php line 47 ... 44. 45. $sql = 'SELECT DISTINCT(client_id) AS client_id FROM pot_visitors ORDER BY client_id'; 46. $stmt = $con->prepareStatement( $sql ); 47. $res = $stmt->executeQuery(); 48. 49. while ( $res->next() ) { 50. $result = $res->getRow(); * at homeActions->executeAccess_statistics() in SF_ROOT_DIR\lib\symfony\action\sfActions.class.php line 53 ... 50. } 51. 52. // run action 53. $ret = $this->$actionToRun(); 54. 55. return $ret; 56. } * at sfActions->execute() in SF_ROOT_DIR\lib\symfony\filter\sfExecutionFilter.class.php line 115 ... 112. 113. // execute the action 114. $actionInstance->preExecute(); 115. $viewName = $actionInstance->execute(); 116. if ($viewName == '') 117. { 118. $viewName = sfView::SUCCESS; * at sfExecutionFilter->execute(object('sfFilterChain')) in SF_ROOT_DIR\lib\symfony\filter\sfFilterChain.class.php line 43 ... 40. } 41. 42. // execute the next filter 43. $this->chain[$this->index]->execute($this); 44. } 45. } 46. * at sfFilterChain->execute() in SF_ROOT_DIR\lib\symfony\filter\sfFlashFilter.class.php line 50 ... 47. } 48. 49. // execute next filter 50. $filterChain->execute(); 51. 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\symfony\filter\sfFilterChain.class.php line 43 ... 40. } 41. 42. // execute the next filter 43. $this->chain[$this->index]->execute($this); 44. } 45. } 46. * at sfFilterChain->execute() in SF_ROOT_DIR\lib\symfony\filter\sfCommonFilter.class.php line 29 ... 26. public function execute($filterChain) 27. { 28. // execute next filter 29. $filterChain->execute(); 30. 31. // execute this filter only once 32. $response = $this->getContext()->getResponse(); * at sfCommonFilter->execute(object('sfFilterChain')) in SF_ROOT_DIR\lib\symfony\filter\sfFilterChain.class.php line 43 ... 40. } 41. 42. // execute the next filter 43. $this->chain[$this->index]->execute($this); 44. } 45. } 46. * at sfFilterChain->execute() in SF_ROOT_DIR\lib\symfony\filter\sfRenderingFilter.class.php line 33 ... 30. public function execute($filterChain) 31. { 32. // execute next filter 33. $filterChain->execute(); 34. 35. if (sfConfig::get('sf_logging_enabled')) 36. { * at sfRenderingFilter->execute(object('sfFilterChain')) in SF_ROOT_DIR\lib\symfony\filter\sfFilterChain.class.php line 43 ... 40. } 41. 42. // execute the next filter 43. $this->chain[$this->index]->execute($this); 44. } 45. } 46. * at sfFilterChain->execute() in SF_ROOT_DIR\lib\symfony\controller\sfController.class.php line 276 ... 273. } 274. 275. // process the filter chain 276. $filterChain->execute(); 277. } 278. else 279. { * at sfController->forward('home', 'access_statistics') in SF_ROOT_DIR\lib\symfony\controller\sfFrontWebController.class.php line 48 ... 45. $actionName = $request->getParameter('action'); 46. 47. // make the first request 48. $this->forward($moduleName, $actionName); 49. } 50. catch (sfException $e) 51. { * at sfFrontWebController->dispatch() in SF_ROOT_DIR\web\reports_dev.php line 10 ... 7. 8. require_once(SF_ROOT_DIR.DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.SF_APP.DIRECTORY_SEPARATOR.'config'.DIRECTORY_SEPARATOR.'config.php'); 9. 10. sfContext::getInstance()->getController()->dispatch(); 11. symfony settings ... --- mod_home_enabled: 1 mod_home_is_internal: mod_home_view_class: sfPHP sf_admin_web_dir: /sf/sf_admin sf_app: reports sf_app_config_dir: > C:\Work\swisscom-eurospot\front-end\apps\reports\config sf_app_config_dir_name: config sf_app_dir: > C:\Work\swisscom-eurospot\front-end\apps\reports sf_app_i18n_dir: > C:\Work\swisscom-eurospot\front-end\apps\reports\i18n sf_app_i18n_dir_name: i18n sf_app_lib_dir: > C:\Work\swisscom-eurospot\front-end\apps\reports\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: > C:\Work\swisscom-eurospot\front-end\apps\reports\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: > C:\Work\swisscom-eurospot\front-end\apps\reports\templates sf_app_template_dir_name: templates sf_apps_dir_name: apps sf_autoloading_functions: sf_available: 1 sf_base_cache_dir: > C:\Work\swisscom-eurospot\front-end\cache\reports sf_bin_dir: > C:\Work\swisscom-eurospot\front-end\batch sf_bin_dir_name: batch sf_cache: sf_cache_dir: > C:\Work\swisscom-eurospot\front-end\cache\reports\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: > C:\Work\swisscom-eurospot\front-end\cache\reports\prod\config sf_config_dir: > C:\Work\swisscom-eurospot\front-end\config sf_config_dir_name: config sf_data_dir: C:\Work\swisscom-eurospot\front-end\data sf_data_dir_name: data sf_debug: 1 sf_default_action: index sf_default_module: default sf_doc_dir: > C:\Work\swisscom-eurospot\front-end\data\doc sf_doc_dir_name: doc sf_enabled_modules: - default sf_environment: prod sf_error_404_action: error404 sf_error_404_module: default sf_error_reporting: 341 sf_escaping_method: ESC_ENTITIES sf_escaping_strategy: bc sf_etag: 1 sf_i18n: sf_i18n_cache_dir: > C:\Work\swisscom-eurospot\front-end\cache\reports\prod\i18n sf_in_bootstrap: 1 sf_lib_dir: C:\Work\swisscom-eurospot\front-end\lib sf_lib_dir_name: lib sf_log_dir: C:\Work\swisscom-eurospot\front-end\log sf_log_dir_name: log sf_logging_enabled: sf_logging_history: 10 sf_logging_level: err sf_logging_period: 7 sf_logging_purge: sf_logging_rotate: 1 sf_login_action: login sf_login_module: default sf_max_forwards: 5 sf_model_dir_name: model sf_model_lib_dir: > C:\Work\swisscom-eurospot\front-end\lib\model sf_module_cache_dir: > C:\Work\swisscom-eurospot\front-end\cache\reports\prod\modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: sf_orm: propel sf_path_info_array: SERVER sf_path_info_key: PATH_INFO sf_plugins_dir: > C:\Work\swisscom-eurospot\front-end\plugins sf_plugins_dir_name: plugins sf_prototype_web_dir: /sf/prototype sf_rich_text_js_dir: js/tiny_mce sf_root_cache_dir: > C:\Work\swisscom-eurospot\front-end\cache sf_root_dir: C:\Work\swisscom-eurospot\front-end 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: > C:\Work\swisscom-eurospot\front-end\config/../data/symfony sf_symfony_lib_dir: > C:\Work\swisscom-eurospot\front-end\config/../lib/symfony sf_template_cache_dir: > C:\Work\swisscom-eurospot\front-end\cache\reports\prod\template sf_test: sf_test_cache_dir: > C:\Work\swisscom-eurospot\front-end\cache\reports\prod\test sf_test_dir: C:\Work\swisscom-eurospot\front-end\test sf_test_dir_name: test sf_timeout: 1800 sf_timer_start: 1178552804.24 sf_unavailable_action: unavailable sf_unavailable_module: default sf_upload_dir: > C:\Work\swisscom-eurospot\front-end\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: C:\Work\swisscom-eurospot\front-end\web sf_web_dir_name: web request ... --- parameterHolder: symfony/default: action: access_statistics module: home attributeHolder: symfony/default: response ... --- cookies: httpHeaders: parameterHolder: global vars ...