| # |
type |
message |
| 1 | PhpConfigHandler | php.ini "register_globals" key is better set to "false" (current value is "'1'" - php.ini location: "/usr/local/lib/php.ini") |
| 2 | Context | initialization |
| 3 | Controller | initialization |
| 4 | Routing | match route [search-results-state-program-slug] "/campus-schools/state/:state/program/:slug" |
| 5 | Request | request parameters array ( 'state' => 'connecticut-colleges', 'slug' => 'massage-healing-and-health', 'module' => 'search', 'action' => 'perma_state_program',) |
| 6 | Controller | dispatch request |
| 7 | Filter | executing filter "sfRenderingFilter" |
| 8 | Filter | executing filter "sfWebDebugFilter" |
| 9 | Filter | executing filter "sfCommonFilter" |
| 10 | Filter | executing filter "sfFlashFilter" |
| 11 | Filter | flag old flash messages ("zipCode", "program_id", "state_id", "degree_id") |
| 12 | Filter | executing filter "sfExecutionFilter" |
| 13 | Creole | connect(): DSN: array ( 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'username' => '****', ), FLAGS: 0 |
| 14 | Creole | prepareStatement(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? |
| 15 | Creole | applyLimit(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6, offset: 0, limit: 1 |
| 16 | Creole | executeQuery(): [0.36 ms] SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 LIMIT 1 |
| 17 | Action | call "searchActions->executePerma_state_program()" |
| 18 | Creole | prepareStatement(): SELECT state.ID, state.NAME FROM state WHERE state.NAME=? |
| 19 | Creole | applyLimit(): SELECT state.ID, state.NAME FROM state WHERE state.NAME='Connecticut', offset: 0, limit: 1 |
| 20 | Creole | executeQuery(): [0.66 ms] SELECT state.ID, state.NAME FROM state WHERE state.NAME='Connecticut' LIMIT 1 |
| 21 | Creole | prepareStatement(): SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL=? |
| 22 | Creole | applyLimit(): SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health', offset: 0, limit: 1 |
| 23 | Creole | executeQuery(): [0.33 ms] SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health' LIMIT 1 |
| 24 | Creole | prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 25 | Creole | executeQuery(): [5.72 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=62 AND college_program.PROGRAM_ID=113 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 26 | Creole | prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (?,?) ORDER BY UPPER(college.NAME) ASC |
| 27 | Creole | executeQuery(): [0.73 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (769,769) ORDER BY UPPER(college.NAME) ASC |
| 28 | Creole | prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 29 | Creole | executeQuery(): [5.28 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=62 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=769 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC |
| 30 | Creole | prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 31 | Creole | executeQuery(): [16.83 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=772 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 32 | Creole | prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 33 | Creole | executeQuery(): [4.99 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=773 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 34 | Action | change template to "myCampusSearchResults" |
| 35 | View | initialize view for "search/perma_state_program" |
| 36 | View | render "sf_app_dir/modules/search/templates/myCampusSearchResultsSuccess.php" |
| 37 | PartialHelper | set slot "side" |
| 38 | PartialHelper | call "search->executeCampusSearchRightNav()" |
| 39 | Creole | prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC |
| 40 | Creole | executeQuery(): [2.92 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=62 AND college_program.PROGRAM_ID=113 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC |
| 41 | View | initialize view for "search/_campusSearchRightNav" |
| 42 | View | render "sf_app_dir/modules/search/templates/_campusSearchRightNav.php" |
| 43 | PartialHelper | call "featured->executeFeaturedSites()" |
| 44 | Creole | prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 45 | Creole | executeQuery(): [0.39 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='site' AND content_module.NAME='layout' AND content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 AND content_page.ID=content_module.CONTENT_PAGE_ID |
| 46 | Creole | prepareStatement(): SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=? AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 47 | Creole | executeQuery(): [0.31 ms] SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=6 AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC |
| 48 | View | initialize view for "featured/_featuredSites" |
| 49 | View | render "sf_app_dir/modules/featured/templates/_featuredSites.php" |
| 50 | PartialHelper | call "search->executeSearchBoxSmall()" |
| 51 | Creole | prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC |
| 52 | Creole | executeQuery(): [1.41 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=62 AND college_program.PROGRAM_ID=103 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC |
| 53 | Creole | prepareStatement(): SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college_state.STATE_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC |
| 54 | Creole | executeQuery(): [4.84 ms] SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=62 AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC |
| 55 | View | initialize view for "search/_searchBoxSmall" |
| 56 | View | render "sf_app_dir/modules/search/templates/_searchBoxSmall.php" |
| 57 | View | decorate content with "sf_app_dir/templates/mySearchResultsLayout.php" |
| 58 | View | render "sf_app_dir/templates/mySearchResultsLayout.php" |
| 59 | View | initialize view for "global/_vista" |
| 60 | View | render "sf_app_dir/templates/_vista.php" |
| 61 | View | initialize view for "global/_header" |
| 62 | View | render "sf_app_dir/templates/_header.php" |
| 63 | View | initialize view for "global/_footer" |
| 64 | View | render "sf_app_dir/templates/_footer.php" |