Log and debug messages

#	type	message
1	Context	initialization
2	Controller	initialization
3	Routing	match route [opportunityCountry] "/opportunity/country/:country_code"
4	Request	request parameters array ( 'country_code' => 'GH', 'module' => 'opportunity', 'action' => 'country',)
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 "opportunityActions->executeCountry()"
12	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'socket' => '', 'username' => '**', ), FLAGS: 0
13	Creole	prepareStatement(): SELECT opportunity.PRF_NUMBER, opportunity.WEBREGION_ID, opportunity.COUNTRY_CODE, opportunity.TITLE, opportunity.NPL_CODE, opportunity.DESCRIPTION, opportunity.TERM, opportunity.WEBSITE, opportunity.PRIORITY, opportunity.DATE_MODIFIED, opportunity.DATE_CREATED, UPPER(career.TITLE), UPPER(opportunity.TITLE) FROM opportunity LEFT JOIN career ON (opportunity.NPL_CODE=career.NPL_CODE) WHERE opportunity.COUNTRY_CODE=? ORDER BY UPPER(career.TITLE) ASC,UPPER(opportunity.TITLE) ASC
14	Creole	executeQuery(): [61.08 ms] SELECT opportunity.PRF_NUMBER, opportunity.WEBREGION_ID, opportunity.COUNTRY_CODE, opportunity.TITLE, opportunity.NPL_CODE, opportunity.DESCRIPTION, opportunity.TERM, opportunity.WEBSITE, opportunity.PRIORITY, opportunity.DATE_MODIFIED, opportunity.DATE_CREATED, UPPER(career.TITLE), UPPER(opportunity.TITLE) FROM opportunity LEFT JOIN career ON (opportunity.NPL_CODE=career.NPL_CODE) WHERE opportunity.COUNTRY_CODE='GH' ORDER BY UPPER(career.TITLE) ASC,UPPER(opportunity.TITLE) ASC
15	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=?
16	Creole	executeQuery(): [0.95 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'
17	View	initialize view for "opportunity/country"
18	View	render "sf_app_dir\modules/opportunity/templates/countrySuccess.php"
19	View	initialize view for "global/_banner"
20	View	render "sf_app_dir\templates/_banner.php"
21	PartialHelper	call "hppage->executePrayer()"
22	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,hpcontent.CREATED_ON DESC
23	Creole	executeQuery(): [1.04 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,hpcontent.CREATED_ON DESC
24	View	initialize view for "hppage/_prayer"
25	View	render "sf_app_dir\modules/hppage/templates/_prayer.php"
26	View	initialize view for "global/_languages"
27	View	render "sf_app_dir\templates/_languages.php"
28	View	initialize view for "global/_navigation"
29	View	render "sf_app_dir\templates/_navigation.php"
30	Creole	prepareStatement(): SELECT region.CODE, region.TITLE, region.WEBREGION_ID FROM region WHERE region.CODE=?
31	Creole	executeQuery(): [0.60 ms] SELECT region.CODE, region.TITLE, region.WEBREGION_ID FROM region WHERE region.CODE='AF'
32	Creole	prepareStatement(): SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.ID=?
33	Creole	executeQuery(): [0.44 ms] SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.ID=1
34	View	initialize view for "country/_africa-europe"
35	View	render "sf_app_dir\modules/country/templates/_africa-europe.php"
36	Creole	prepareStatement(): SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE=?
37	Creole	executeQuery(): [0.45 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='A'
38	Creole	prepareStatement(): SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE=?
39	Creole	executeQuery(): [0.42 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='Y'
40	Creole	prepareStatement(): SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE=?
41	Creole	executeQuery(): [0.41 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='F'
42	Creole	prepareStatement(): SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE=?
43	Creole	executeQuery(): [0.40 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='C'
44	Creole	prepareStatement(): SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE=?
45	Creole	executeQuery(): [46.48 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='H'
46	Creole	prepareStatement(): SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE=?
47	Creole	executeQuery(): [0.61 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='Q'
48	Creole	prepareStatement(): SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE=?
49	Creole	executeQuery(): [0.43 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='S'
50	View	initialize view for "global/_donate-resources-email"
51	View	render "sf_app_dir\templates/_donate-resources-email.php"
52	View	decorate content with "sf_app_dir\templates/layout.php"
53	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: country
    country_code: GH
    module: opportunity
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: Opportunities in Ghana
  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_opportunity_enabled: 1
mod_opportunity_is_internal: 
mod_opportunity_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: myErrors
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: 1369440068.129
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: 
env: 
files: 
get: 
post: 
server: 
  ALLUSERSPROFILE: C:\Documents and Settings\All Users
  APPL_MD_PATH: /LM/w3svc/1384502356/root
  APPL_PHYSICAL_PATH: D:\www\LocalUser\domain16\web\
  APP_POOL_ID: DefaultAppPool
  AUTH_PASSWORD: 
  AUTH_TYPE: 
  AUTH_USER: 
  CERT_COOKIE: 
  CERT_FLAGS: 
  CERT_ISSUER: 
  CERT_SERIALNUMBER: 
  CERT_SUBJECT: 
  COMPUTERNAME: U15301843
  CONTENT_LENGTH: 0
  CONTENT_TYPE: 
  ClusterLog: C:\WINDOWS\Cluster\cluster.log
  ComSpec: C:\WINDOWS\system32\cmd.exe
  CommonProgramFiles: C:\Program Files\Common Files
  DOCUMENT_ROOT: D:\www\LocalUser\domain16\web
  FCGI_ROLE: RESPONDER
  FP_NO_HOST_CHECK: NO
  GATEWAY_INTERFACE: CGI/1.1
  HTTPS: off
  HTTPS_KEYSIZE: 
  HTTPS_SECRETKEYSIZE: 
  HTTPS_SERVER_ISSUER: 
  HTTPS_SERVER_SUBJECT: 
  HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
  HTTP_ACCEPT_ENCODING: x-gzip, gzip, deflate
  HTTP_ACCEPT_LANGUAGE: en-us,en-gb,en;q=0.7,*;q=0.3
  HTTP_HOST: www.sim.org
  HTTP_USER_AGENT: CCBot/2.0
  INSTANCE_ID: 1384502356
  INSTANCE_META_PATH: /LM/W3SVC/1384502356
  LOCAL_ADDR: 74.208.112.55
  LOGON_USER: 
  NUMBER_OF_PROCESSORS: 2
  ORIG_PATH_INFO: /frontend_dev.php/opportunity/country/GH
  OS: Windows_NT
  PATHEXT: .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH
  PATH_INFO: /opportunity/country/GH
  PATH_TRANSLATED: D:\www\LocalUser\domain16\web\frontend_dev.php\opportunity\country\GH
  PHP_FCGI_MAX_REQUESTS: 10000
  PHP_SELF: /frontend_dev.php/opportunity/country/GH
  PROCESSOR_ARCHITECTURE: x86
  PROCESSOR_IDENTIFIER: x86 Family 15 Model 107 Stepping 2, AuthenticAMD
  PROCESSOR_LEVEL: 15
  PROCESSOR_REVISION: 6b02
  Path: C:\Program Files\Windows Resource Kits\Tools\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files\Microsoft SQL Server\90\Tools\binn\;C:\PHP;D:\MySQL\MySQL Server 5.1\bin
  ProgramFiles: C:\Program Files
  QUERY_STRING: 
  REMOTE_ADDR: 23.22.76.170
  REMOTE_HOST: 23.22.76.170
  REMOTE_PORT: 58277
  REMOTE_USER: 
  REQUEST_METHOD: GET
  REQUEST_TIME: 1369440068
  REQUEST_URI: /frontend_dev.php/opportunity/country/GH
  SCRIPT_FILENAME: D:\www\LocalUser\domain16\web\frontend_dev.php
  SCRIPT_NAME: /frontend_dev.php
  SERVER_NAME: www.sim.org
  SERVER_PORT: 80
  SERVER_PORT_SECURE: 0
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SOFTWARE: Microsoft-IIS/6.0
  SystemDrive: C:
  SystemRoot: C:\WINDOWS
  TEMP: C:\WINDOWS\TEMP
  TMP: C:\WINDOWS\TEMP
  URL: /frontend_dev.php
  USERPROFILE: C:\Documents and Settings\Default User
  _FCGI_X_PIPE_: \\.\pipe\IISFCGI-ca5e2f5e-43b9-4eb4-8e01-2a2a1f0a089e
  windir: C:\WINDOWS
session:

Php

---
php: 5.2.5
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
  - cgi-fcgi
  - curl
  - gd
  - mbstring
  - mcrypt
  - mysql
  - mysqli
  - xmlrpc
  - xsl

SQL queries

[61.08 ms] SELECT opportunity.PRF_NUMBER, opportunity.WEBREGION_ID, opportunity.COUNTRY_CODE, opportunity.TITLE, opportunity.NPL_CODE, opportunity.DESCRIPTION, opportunity.TERM, opportunity.WEBSITE, opportunity.PRIORITY, opportunity.DATE_MODIFIED, opportunity.DATE_CREATED, UPPER(career.TITLE), UPPER(opportunity.TITLE) FROM opportunity LEFT JOIN career ON (opportunity.NPL_CODE=career.NPL_CODE) WHERE opportunity.COUNTRY_CODE='GH' ORDER BY UPPER(career.TITLE) ASC,UPPER(opportunity.TITLE) ASC
[0.95 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'
[1.04 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,hpcontent.CREATED_ON DESC
[0.60 ms] SELECT region.CODE, region.TITLE, region.WEBREGION_ID FROM region WHERE region.CODE='AF'
[0.44 ms] SELECT webregion.ID, webregion.TITLE, webregion.STRIPPED_TITLE, webregion.SUMMARY, webregion.BODY, webregion.SIDEBAR, webregion.BANNER_URL FROM webregion WHERE webregion.ID=1
[0.45 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='A'
[0.42 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='Y'
[0.41 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='F'
[0.40 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='C'
[46.48 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='H'
[0.61 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='Q'
[0.43 ms] SELECT career.NPL_CODE, career.TITLE, career.STRIPPED_TITLE, career.BODY, career.BANNER_URL FROM career WHERE career.NPL_CODE='S'

type	calls	time (ms)
Configuration	11	37.22
Action "opportunity/country"	1	101.82
Database	12	113.30
View "Success" for "opportunity/country"	1	129.50
Partial "global/_banner"	1	49.43
Component "hppage/prayer"	1	27.09
Partial "hppage/_prayer"	1	2.73
Partial "global/_languages"	1	1.44
Partial "global/_navigation"	1	16.20
Partial "country/_africa-europe"	1	5.02
Partial "global/_donate-resources-email"	1	2.81

Business Ministries/Administration/Leadership

Children and Youth

Community Education

Evangelism/Church Growth

Medical and Health Ministry

Teams

Technical Services

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers