Log and debug messages

#	type	message
1	Context	initialization
2	Controller	initialization
3	Routing	match route [projectCountry] "/project/country/:country_code"
4	Request	request parameters array ( 'country_code' => 'GH', 'module' => 'project', 'action' => 'list',)
5	Controller	dispatch request
6	Filter	executing filter "sfRenderingFilter"
7	Filter	executing filter "sfWebDebugFilter"
8	Filter	executing filter "sfCommonFilter"
9	Filter	executing filter "sfFlashFilter"
10	Filter	executing filter "sfExecutionFilter"
11	Action	call "projectActions->executeList()"
12	Creole	connect(): DSN: array ( 'compat_assoc_lower' => '**', 'compat_rtrim_string' => '', 'database' => '', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
13	Creole	prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=?
14	Creole	executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='GH'
15	Creole	prepareStatement(): SELECT region.CODE, region.TITLE, region.WEBREGION_ID FROM region WHERE region.CODE=?
16	Creole	executeQuery(): [15.62 ms] SELECT region.CODE, region.TITLE, region.WEBREGION_ID FROM region WHERE region.CODE='AF'
17	Creole	prepareStatement(): SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.ID=?
18	Creole	executeQuery(): [0.00 ms] SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.ID=1
19	Creole	prepareStatement(): SELECT project.ID, project.PROJECT_NUMBER, project.TITLE, project.WEBSITE, project.SUMMARY, project.BODY, project.SIDEBAR, project.TOTAL_COST, project.NEEDED, project.WEBREGION_ID, project.COUNTRY_CODE, project.UPDATED_ON, project.IS_APPROVED, project.IS_PUBLISHED, project.BANNER_URL, UPPER(country.TITLE), UPPER(project.TITLE) FROM project LEFT JOIN country ON (project.COUNTRY_CODE=country.CODE) WHERE project.NEEDED<>? AND project.COUNTRY_CODE=? ORDER BY UPPER(country.TITLE) ASC,UPPER(project.TITLE) ASC
20	Creole	executeQuery(): [2462.72 ms] SELECT project.ID, project.PROJECT_NUMBER, project.TITLE, project.WEBSITE, project.SUMMARY, project.BODY, project.SIDEBAR, project.TOTAL_COST, project.NEEDED, project.WEBREGION_ID, project.COUNTRY_CODE, project.UPDATED_ON, project.IS_APPROVED, project.IS_PUBLISHED, project.BANNER_URL, UPPER(country.TITLE), UPPER(project.TITLE) FROM project LEFT JOIN country ON (project.COUNTRY_CODE=country.CODE) WHERE project.NEEDED<>0 AND project.COUNTRY_CODE='GH' ORDER BY UPPER(country.TITLE) ASC,UPPER(project.TITLE) ASC
21	View	initialize view for "project/list"
22	View	render "sf_app_dir\modules/project/templates/listSuccess.php"
23	View	initialize view for "global/_banner"
24	View	render "sf_app_dir\templates/_banner.php"
25	PartialHelper	call "hppage->executePrayer()"
26	Creole	prepareStatement(): SELECT hppagecontent.HPPAGE_ID, hppagecontent.HPCONTENT_ID, hpcontent.ID, hpcontent.HPSLOT_ID, hpcontent.TITLE, hpcontent.SUMMARY, hpcontent.IMAGE, hpcontent.LINK, hpcontent.CREATED_ON, hpcontent.LISTING_ORDER FROM hppagecontent, hpcontent WHERE hpcontent.HPSLOT_ID=? AND hppagecontent.HPCONTENT_ID=hpcontent.ID ORDER BY hpcontent.LISTING_ORDER ASC
27	Creole	executeQuery(): [0.00 ms] SELECT hppagecontent.HPPAGE_ID, hppagecontent.HPCONTENT_ID, hpcontent.ID, hpcontent.HPSLOT_ID, hpcontent.TITLE, hpcontent.SUMMARY, hpcontent.IMAGE, hpcontent.LINK, hpcontent.CREATED_ON, hpcontent.LISTING_ORDER FROM hppagecontent, hpcontent WHERE hpcontent.HPSLOT_ID=5 AND hppagecontent.HPCONTENT_ID=hpcontent.ID ORDER BY hpcontent.LISTING_ORDER ASC
28	View	initialize view for "hppage/_prayer"
29	View	render "sf_app_dir\modules/hppage/templates/_prayer.php"
30	View	initialize view for "global/_languages"
31	View	render "sf_app_dir\templates/_languages.php"
32	View	initialize view for "global/_navigation"
33	View	render "sf_app_dir\templates/_navigation.php"
34	View	initialize view for "country/_africa-europe"
35	View	render "sf_app_dir\modules/country/templates/_africa-europe.php"
36	Creole	prepareStatement(): SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE=?
37	Creole	executeQuery(): [0.00 ms] SELECT country.CODE, country.TITLE, country.FULLTITLE, country.SUMMARY, country.WEBSITE, country.BODY, country.SIDEBAR, country.PRAYER_REQUEST, country.REGION_CODE, country.OFFICE_ID, country.BANNER_URL FROM country WHERE country.CODE='GH'
38	View	initialize view for "project/_thermometer"
39	View	render "sf_app_dir\modules/project/templates/_thermometer.php"
40	View	initialize view for "project/_thermometer"
41	View	render "sf_app_dir\modules/project/templates/_thermometer.php"
42	View	initialize view for "project/_thermometer"
43	View	render "sf_app_dir\modules/project/templates/_thermometer.php"
44	View	initialize view for "project/_thermometer"
45	View	render "sf_app_dir\modules/project/templates/_thermometer.php"
46	View	initialize view for "project/_thermometer"
47	View	render "sf_app_dir\modules/project/templates/_thermometer.php"
48	View	initialize view for "project/_thermometer"
49	View	render "sf_app_dir\modules/project/templates/_thermometer.php"
50	View	initialize view for "project/_thermometer"
51	View	render "sf_app_dir\modules/project/templates/_thermometer.php"
52	View	initialize view for "global/_donate-resources-email"
53	View	render "sf_app_dir\templates/_donate-resources-email.php"
54	View	decorate content with "sf_app_dir\templates/layout.php"
55	View	render "sf_app_dir\templates/layout.php"

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    action: list
    country_code: GH
    module: project
attributeHolder: 
  symfony/default:

Response

---
cookies: 
httpHeaders: 
  Content-Type: text/html; charset=utf-8
parameterHolder: 
  helper/asset/auto/httpmeta: 
    Content-Type: text/html; charset=utf-8
  helper/asset/auto/javascript: 
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    language: en
    robots: index, follow
    title: Projects
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    blue: 
    site: 
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
mod_hppage_enabled: 1
mod_hppage_is_internal: 
mod_hppage_view_class: sfPHP
mod_project_enabled: 1
mod_project_is_internal: 
mod_project_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: D:\www\LocalUser\domain16\apps\frontend\config
sf_app_config_dir_name: config
sf_app_dir: D:\www\LocalUser\domain16\apps\frontend
sf_app_i18n_dir: D:\www\LocalUser\domain16\apps\frontend\i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: D:\www\LocalUser\domain16\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: D:\www\LocalUser\domain16\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: D:\www\LocalUser\domain16\apps\frontend\templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: D:\www\LocalUser\domain16\cache\frontend
sf_bin_dir: D:\www\LocalUser\domain16\batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev
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: D:\www\LocalUser\domain16\cache\frontend\dev\config
sf_config_dir: D:\www\LocalUser\domain16\config
sf_config_dir_name: config
sf_data_dir: D:\www\LocalUser\domain16\data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: D:\www\LocalUser\domain16\data\doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 4095
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 
sf_i18n_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\i18n
sf_lib_dir: D:\www\LocalUser\domain16\lib
sf_lib_dir_name: lib
sf_log_dir: D:\www\LocalUser\domain16\log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
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: D:\www\LocalUser\domain16\lib\model
sf_module_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\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: D:\www\LocalUser\domain16\plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: D:\www\LocalUser\domain16\cache
sf_root_dir: D:\www\LocalUser\domain16
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:\PHP\pear\data/symfony
sf_symfony_lib_dir: C:\PHP\pear/symfony
sf_template_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\template
sf_test: 
sf_test_cache_dir: D:\www\LocalUser\domain16\cache\frontend\dev\test
sf_test_dir: D:\www\LocalUser\domain16\test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1258768619.9805
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: D:\www\LocalUser\domain16\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:  &darr;&nbsp;
sf_validation_error_suffix:  &nbsp;&darr;
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: D:\www\LocalUser\domain16\web
sf_web_dir_name: web

Globals

---
cookie: 
  symfony: h9mmv12ksvk10lmjjhfcmjeu17
env: 
files: 
get: 
post: 
server: 
  ALL_HTTP: |
    HTTP_CACHE_CONTROL:no-cache
    HTTP_CONNECTION:close
    HTTP_PRAGMA:no-cache
    HTTP_ACCEPT:text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
    HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7
    HTTP_ACCEPT_ENCODING:gzip
    HTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5
    HTTP_COOKIE:symfony=h9mmv12ksvk10lmjjhfcmjeu17
    HTTP_HOST:sim.org
    HTTP_USER_AGENT:CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
    HTTP_X_CC_ID:ccc02-01
    
  APPL_MD_PATH: /LM/w3svc/1384502356/root
  APPL_PHYSICAL_PATH: D:\www\LocalUser\domain16\web\
  AUTH_PASSWORD: 
  AUTH_TYPE: 
  AUTH_USER: 
  CONTENT_LENGTH: 0
  CONTENT_TYPE: 
  DOCUMENT_ROOT: D:\www\LocalUser\domain16\web
  HTTPS: off
  HTTP_ACCEPT: text/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
  HTTP_CACHE_CONTROL: no-cache
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=h9mmv12ksvk10lmjjhfcmjeu17
  HTTP_HOST: sim.org
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc02-01
  INSTANCE_ID: 1384502356
  INSTANCE_META_PATH: /LM/W3SVC/1384502356
  LOGON_USER: 
  ORIG_PATH_INFO: /frontend_dev.php/project/country/GH
  ORIG_PATH_TRANSLATED: D:\www\LocalUser\domain16\web\frontend_dev.php\project\country\GH
  PATH_INFO: /project/country/GH
  PATH_TRANSLATED: D:\www\LocalUser\domain16\web\project\country\GH
  PHP_SELF: /frontend_dev.php
  QUERY_STRING: 
  REMOTE_ADDR: 38.107.191.92
  REMOTE_HOST: 38.107.191.92
  REMOTE_USER: 
  REQUEST_METHOD: GET
  REQUEST_TIME: 1258768620
  REQUEST_URI: /frontend_dev.php/project/country/GH
  SCRIPT_FILENAME: D:\www\LocalUser\domain16\web\frontend_dev.php
  SCRIPT_NAME: /frontend_dev.php
  SERVER_NAME: sim.org
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SOFTWARE: Microsoft-IIS/6.0
  URL: /frontend_dev.php/project/country/GH
session: 
  symfony/user/sfUser/attributes: 
  symfony/user/sfUser/authenticated: 
  symfony/user/sfUser/credentials: 
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1258768615

Php

---
php: 5.2.9-1
os: Windows NT U15301843 5.2 build 3790
extensions: 
  - bcmath
  - calendar
  - com_dotnet
  - ctype
  - session
  - filter
  - ftp
  - hash
  - iconv
  - json
  - odbc
  - pcre
  - Reflection
  - date
  - libxml
  - standard
  - tokenizer
  - zlib
  - SimpleXML
  - dom
  - SPL
  - wddx
  - xml
  - xmlreader
  - xmlwriter
  - ISAPI
  - curl
  - gd
  - mbstring
  - mcrypt
  - mysql
  - mysqli
  - xmlrpc
  - xsl

type	calls	time (ms)
Configuration	11	56.78
Action "project/list"	1	2609.54
Database	6	2478.32
View "Success" for "project/list"	1	174.36
Partial "global/_banner"	1	-2392.71
Component "hppage/prayer"	1	15.62
Partial "hppage/_prayer"	1	15.62
Partial "global/_languages"	1	0.00
Partial "global/_navigation"	1	15.62
Partial "country/_africa-europe"	1	-2441.92
Partial "project/_thermometer"	7	22.89
Partial "global/_donate-resources-email"	1	1.74

Ghana

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers