| # |
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 [lead-form-slug] "/info/college/:slug" |
| 5 | Request | request parameters array ( 'slug' => 'american-intercontinental-university', 'module' => 'info', 'action' => 'perma_college',) |
| 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", "degree_id", "program_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='info' AND content_page.ACTION_NAME='perma_college' AND content_page.SITE_ID=6, offset: 0, limit: 1 |
| 16 | Creole | executeQuery(): [1.49 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='info' AND content_page.ACTION_NAME='perma_college' AND content_page.SITE_ID=6 LIMIT 1 |
| 17 | Action | call "infoActions->executePerma_college()" |
| 18 | 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 FROM college WHERE college.SEO_URL=? |
| 19 | Creole | applyLimit(): 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 FROM college WHERE college.SEO_URL='american-intercontinental-university', offset: 0, limit: 1 |
| 20 | Creole | executeQuery(): [9.92 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 FROM college WHERE college.SEO_URL='american-intercontinental-university' LIMIT 1 |
| 21 | Creole | prepareStatement(): SELECT college_form.ID, college_form.COLLEGE_ID, college_form.POSTING, college_form.DESCRIPTION, college_form.PRE_TEXT, college_form.POST_TEXT, college_form.EMAIL FROM college_form WHERE college_form.COLLEGE_ID=? |
| 22 | Creole | executeQuery(): [13.19 ms] SELECT college_form.ID, college_form.COLLEGE_ID, college_form.POSTING, college_form.DESCRIPTION, college_form.PRE_TEXT, college_form.POST_TEXT, college_form.EMAIL FROM college_form WHERE college_form.COLLEGE_ID=3036 |
| 23 | Creole | prepareStatement(): SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=? |
| 24 | Creole | executeQuery(): [0.42 ms] SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=183 |
| 25 | Action | change template to "leadForm" |
| 26 | View | initialize view for "info/perma_college" |
| 27 | View | render "sf_app_dir/modules/info/templates/leadFormSuccess.php" |
| 28 | PartialHelper | call "info->executePrograms()" |
| 29 | Creole | prepareStatement(): SELECT DISTINCT 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 WHERE college_program.DESCRIPTION IS NOT NULL AND college_program.COLLEGE_ID=? ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 30 | Creole | executeQuery(): [12.54 ms] SELECT DISTINCT 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 WHERE college_program.DESCRIPTION IS NOT NULL AND college_program.COLLEGE_ID=3036 ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC |
| 31 | Creole | prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL FROM degree WHERE degree.ID IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) |
| 32 | Creole | executeQuery(): [11.71 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL FROM degree WHERE degree.ID IN (40,40,40,40,40,40,40,41,41,41,41,41,41,40,41,41,41,41,41,41,41,41,40,40,40,42,42,42,42,42,42,42,41,41,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42) |
| 33 | View | initialize view for "info/_programs" |
| 34 | View | render "sf_app_dir/modules/info/templates/_programs.php" |
| 35 | PartialHelper | call "info->executeLeadForm()" |
| 36 | Creole | prepareStatement(): SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=? ORDER BY college_form_field.ID DESC |
| 37 | Creole | executeQuery(): [0.42 ms] SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=183 ORDER BY college_form_field.ID DESC |
| 38 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? ORDER BY college_form_select.ID ASC |
| 39 | Creole | executeQuery(): [0.40 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4509 ORDER BY college_form_select.ID ASC |
| 40 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? ORDER BY college_form_select.ID ASC |
| 41 | Creole | executeQuery(): [0.77 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4508 ORDER BY college_form_select.ID ASC |
| 42 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? ORDER BY college_form_select.ID ASC |
| 43 | Creole | executeQuery(): [0.32 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4507 ORDER BY college_form_select.ID ASC |
| 44 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? ORDER BY college_form_select.ID ASC |
| 45 | Creole | executeQuery(): [0.36 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4504 ORDER BY college_form_select.ID ASC |
| 46 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? ORDER BY college_form_select.ID ASC |
| 47 | Creole | executeQuery(): [0.42 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4501 ORDER BY college_form_select.ID ASC |
| 48 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? ORDER BY college_form_select.ID ASC |
| 49 | Creole | executeQuery(): [0.41 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4500 ORDER BY college_form_select.ID ASC |
| 50 | Creole | prepareStatement(): SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=? ORDER BY college_form_field.ID DESC |
| 51 | Creole | executeQuery(): [0.35 ms] SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=183 ORDER BY college_form_field.ID DESC |
| 52 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? |
| 53 | Creole | executeQuery(): [0.35 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4509 |
| 54 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? |
| 55 | Creole | executeQuery(): [0.37 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4508 |
| 56 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? |
| 57 | Creole | executeQuery(): [0.31 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4507 |
| 58 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? |
| 59 | Creole | executeQuery(): [0.31 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4504 |
| 60 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? |
| 61 | Creole | executeQuery(): [0.50 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4501 |
| 62 | Creole | prepareStatement(): SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=? |
| 63 | Creole | executeQuery(): [0.39 ms] SELECT college_form_select.ID, college_form_select.COLLEGE_FORM_FIELD_ID, college_form_select.DISPLAY, college_form_select.VALUE, college_form_select.PROGRAM_GROUP, college_form_select.EDUCATION_MINLEVEL, college_form_select.INVALIDZIP FROM college_form_select WHERE college_form_select.COLLEGE_FORM_FIELD_ID=4500 |
| 64 | Creole | prepareStatement(): SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=? ORDER BY college_form_field.ID DESC |
| 65 | Creole | executeQuery(): [0.34 ms] SELECT college_form_field.ID, college_form_field.COLLEGE_FORM_ID, college_form_field.FIELD, college_form_field.FIELD_LABEL, college_form_field.MAX_SIZE, college_form_field.TYPE, college_form_field.REQUIRED, college_form_field.NOTES, college_form_field.VALUE, college_form_field.PARENT_ID, college_form_field.FORM_SELECTS_ID FROM college_form_field WHERE college_form_field.COLLEGE_FORM_ID=183 ORDER BY college_form_field.ID DESC |
| 66 | View | initialize view for "info/_leadForm" |
| 67 | View | render "sf_app_dir/modules/info/templates/_leadForm.php" |
| 68 | PartialHelper | call "info->executeValidate()" |
| 69 | View | initialize view for "info/_validate" |
| 70 | View | render "sf_app_dir/modules/info/templates/_validate.php" |
| 71 | View | decorate content with "sf_app_dir/templates/leadFormLayout.php" |
| 72 | View | render "sf_app_dir/templates/leadFormLayout.php" |
| 73 | View | initialize view for "global/_vista" |
| 74 | View | render "sf_app_dir/templates/_vista.php" |
| 75 | PartialHelper | call "info->executeCollege_header()" |
| 76 | View | initialize view for "info/_college_header" |
| 77 | View | render "sf_app_dir/modules/info/templates/_college_header.php" |
| 78 | View | initialize view for "global/_footerlead" |
| 79 | View | render "sf_app_dir/templates/_footerlead.php" |
| 80 | Filter | remove old flash messages ("zipCode", "degree_id", "program_id") |