College Match Application Bugs and Issues - Round Two

Add new issues to Open Issues section in the relevant application cateogory - include the "flow" to recreate the issue, the URL and exact error messages. When an issue is resolved, mark it with astrikethrough, note the SVN revision with the fix, and move it to Resolved Issues.

Open Issues

Pre-deployment Admin Tasks

• (paras) Software installed/configured on all front-end machines are installed/configured (Drupal, CiviCRM, Locker, etc.) and both DB servers online.
• (paras) Change Drupal Session table to INNODB engine
• (paras) Switch svn local repos from trunk to "quest" branch for production deployments.
• (paras) Rsync student_docs directory tree (student photo's etc.) across all 4 app servers

• (lobo) Analyze slow query log
• (lobo) Setup Nagios monitoring
• (?) Periodic cleanup of session and watchdog
• (paras) Testing sticky session config for load-balancing
• (paras) MySQL Dump of DBs (Drupal and CiviCRM)
• (paras) MySQL Replication of DBs

Locker

• (paras) Recommender Locker: Typo (missing space - or s/b paragraph break - between status and fixed sentence) in locker after submitting a recommendation: "Thank you for filling out recommendations.Below are recommendations you have been requested to write."
• (paras) Student Locker: Letter of Recommendation section shows Status: Completed when only ONE of the three recommendations is actually complete (the other 2 are Not Started). (dgg)

Resolved Issues

Recommender "Applications" (Teacher and Counselor)

• (lobo) The preview application doesn't work. Fixed rev 6628

Application Related

• (lobo) After submitting College Match>>Forwarding form - got this status + redirect to High School form: "The School section must be completed before you can submit the application". However, all forms in School section WERE complete and showed as valid in nav links. ?? (on civ1, 9:30pm 8/14). Fixed rev 6628

Migration Related

• Personal Information: Race/Ethnicity doesn't migrate over to new options. Cannot reproduce. Tested with contactID 22186. (dgg)
• High School Info: High school information didn't carry over. Cannot reproduce. Tested with contactID 22186. (dgg)
• Academic Information: GPA didn't carry over. Cannot reproduce. Tested with contactID 22186. (dgg)

Drupal Login and Lockers

• (paras) When recommender completes form last updated date is not shown in locker.
• (paras) Clicking user/validate link from the new registration email UNSETS the student role.
• (paras) Add logic to locker to determine and display status of entire CM process (e.g. check if "Submit Application" task + "Submit Partner" + "Submit Recommendation" (x3) are all "Completed".
• (paras) Add conditional links to Preview CM App, Preview Partner Supplement, and (for recommenders' locker) Preview Recommendation
• (lobo) User registration - profile fieldset (Personal Info) disappears if you have an error on form submit (i.e. enter a 5 character password).
• (lobo) Additional API needed - getPartnerSupplementStatus($contactID). Returns 1 (true) if student needs to complete the Partner Supplement forms (i.e. they have ranked/forwarded a "supplement" requiring college).
• When match app form is submited, status is updated to 'complete' but once you start partner application, status for match app changed to 'in progress' rev 6603

CM Application

• Click "Previous" button, then "Save and Continue" from previous page. Now Parent / Guardian Page loaded with vaidation errors. This is behavior on all forms and is acceptable to client. Won't fix (dgg).
• If two students have same recommenders, then when student clicks on recommender section, it throws fatal error "can not retrieve old recommenders..." rev 6003
• (lobo/dgg) Submit link is not working. S/b clickable at all times for all 3 apps).
• (lobo/dgg) Removed un-needed dependencies in Recommender (teacher/counselor) apps so users can move around between forms.

  Personal section

• There is no 'javascript event' to second race/ethnicity field.e.g: if selected 'other' option for 'additional race/ethnicity' field then textfield for other is not displayed. Won't fix. There is only one ethnicity_other column in quest_student. (dgg)

• As you start to fill this form, birthday field is Feb 13 -yearalthough in registration , I have set birthdate to 13-feb-1984- Won't fix: per spec the drop-down on the app only includes current year-20 (students won't be won't than 20 years old). dgg

• Error message for Approprimate time doesn't display in red. Won't fix. This applies to error messages any any field where we use crmReplace to change the field class (size). There is no easy fix for this at this time. (dgg)

• Can not view personal picture. I tested this with a non-admin student and got Access Denied - so I think the issue is that we need to set permissions for this path: civicrm/file?action=view&eid=2&id=1&quest=1 However, I'm not sure the correct way to do this (in Menu.php vs. some other way that makes it record/user specific)? (dgg) *rev 6603, added new permission: access uploaded files'. Probably need to add more security checks to this

Household section

Foster child option is not displayed by default when the relation is step-father... (Kurund - resolved revision no 6567)

Parent/Guardian Detail
1) "How long U hav lived with this person" - if selected from (years) , don't provide any value still the form works - fixed r6550 (kurund)

Sibling Info
1) If I pick "Not in School", then all of the college info pops up. Even after I pick "Never Attended School" for the "Highest level of schooling", there is still a box for entering a college name - fixed r6550 (kurund)
2) on default when form loads, none of the radio boxes for "How long have you lived with this person?" is selected, and the below section for "From Age" to "To Age" is displayed. - fixed r6550 (kurund)
3) There is no validation for From and To Age. - fixed r6550 (kurund)

Household Income
1) It allows to enter additional income amount, without 'Additional income type'. - fixed r6550 (kurund)
2) If an 'additional income source' is entered without 'Additional income type' then page doesn't show 'additional income source' expanded by default - fixed r6550 (kurund)

Household Information
1) in 1st Block, I choose Step Father n you lived in this household? > 5years n in 2nd block, then I check 'Same person as in current household above' checkbox n change Family Member drop down to step mother and save d/b error comes.(resolved - Anil- rev 6544)

School Info section

High School Information
1) select ST FRANCIS SCHOOL from "Find your school" but on saving it shows "WEST HEAVEN HIGH SCHOOL" kurund - can not reproduce
2) Entered School Information for "FOOTHILL HIGH SCHOOL". Then added one more High School "WEST HAVEN HIGH SCHOOL". Then "Save and Continue". Then logout and login. When again came back to High School Information, only "WEST HAVEN HIGH SCHOOL" present. Now again added HIgh School "FOOTHILL HIGH SCHOOL", and then "Save and Continue"; now page shows validation error "You cannot change school details if you have found your school"  - fixed r6568 (kurund)

Testing

• (kurund) Please add a section for entering TOEFL scores. mockup has been updated
  (http://www.questbridge.org/app_staging/cm/appl/tests.html) - fixed r6604

Additional Info

• In "contact information for current juniors", fill First Name, Last Name, School (keep email field empty).Now click "Save Draft".Again see the Additional Information page and the email for "contact information for current juniors" is set to null. (if saved the information using "save and continue" instaed of "Save Draft" then email field empty) Fix r6546. Added formRule to require email address if referral student row is populated (this column is NOT NULL in quest_referral, so it must be populated). (dgg)

• In "relatives who are alumni/ae at any of our partner colleges/universities" and "family members or relatives", fill information for Last Name, First Name, Class Year etc. and click "save draft". Now again go back to the Additional information section, the information filled before is not present. Could not recreate this BUT added formRules to require Relationship if row is populated as this column is NOT NULL in schema. r6546 (dgg)

• the checkboxes for "How did you hear about QuestBridge" should be reformatted into two columns rev: 6566 (deepak)

Extracurric

• Extracurricular activity: 'Describe a single event ...' and 'List and describe your activities ...' shouldn't be required.  This is a change in quest_data_cm.mysql
• Approximate Time spent is accepted -ve also rev: 6558 (deepak)
• 'Describe which single ...' and 'List and describe your activities ...' shouldn't be required- changed quest_data_cm.mysql: rev 190 (deepak)

• Post process for "Decribe which single Activity..." and "List and describe your activities..." is broken (Resolved - Anil- rev 6542)

Work-Experience

• Start Date > End Date is allowed rev: 6558 (deepak)
• In end date dropdown, dont select month, submit, throws no error and when you view, it shows bydefault january set rev: 6558 (deepak)

Essays section

Transcript - 10th grade

• Dont fill Course tilte; enter information for 2nd Term Grade, 3rd Term Grade, 4th Term Grade, after that "Save Draft" doesnot report any of the validation errors rev: 6563 (deepak)

Transcript - 11th grade:

• Dont fill Academic Subjects; Fill information for rest of the fields, Now "Save Draft". Again come back to Transcript - 11 th grade - values entered previously are not saved. rev: 6563 (deepak)

Transcript - Summer School

• If "Term System" is not selcted, then the database error is thrown. can't replicate: (deepak)

School Info section

• If I revisit the Recommendations section, the 'school' drop-down doesn't remember previous selection. Can't reproduce (dgg)
• -Academic Information: 'Did any school you attended throughout ....' shouldn't have an answer pre-selected.-Modified xml schema for quest_student.is_alternate_grading SET default = NULL (was 0). Behavior will be fixed next time DB is rebuilt (or you can do an alter column manually). Rev 6536 (dgg)
• If I revisit the Recommendations section, the 'school' drop-down doesn't remember previous selection.
• Academic Information
  1) checkbox for "My HighSchool uses all Grading System" is missing.(insted of checkbox added yes/no radio)

Partner Supplements

• Ahmerst: In the Essay section, I can submit the main essay without selecting one of the 6 essay options. Fixed rev 6628
• Princeton: In the Essay section, I can submit the essay without selecting one of the 4 essay options. Fixed rev 6628
• Stanford: In the Essay section, I can select the photograph essay and it doesn't require me to attach the file. Fixed rev 6628

• (lobo) Submit Partner Supplement - throws fatal error - "Cannot add or update a child row: a foreign key constraint fails" (query is missing civicrm_contact.id): "INSERT INTO quest_student (is_partner_supplement_share ) VALUES ( 1 )" Fixed Rev 6622.

• Stanford university : Form not getting displayed even after clicking the link for "Standford University" from left navigation menu. Fixed rev 6606 (lobo).
• (lobo) If you click on the Submit Partner Supplement link (civicrm/quest/matchapp/partner?_qf_PartnerSubmit_display=true) when the Partner sections are not yet complete it SHOULD just take you to the first incomplete Partner page (as the Submit Application link does in MatchApp). Fixed Rev 6539.
• Submit Partner Supplement link shows even though user hasn't completed all sections. Submit links will be visible and active at all times for all 3 apps.
• When I 'Submit Partner Supplement' it takes to my CM application, displaying errors on the CM application. Bug. Fixed in rev 6535 (lobo).
• (lobo) Fixed?? When checked in? (dgg) Enter information for the University(ies), and in between submit the application, then error ".. section must be completed before you can submit the application". But this error is on "College Match Section" rather than "Partner Supplement Application section"

Princeton university

• Engineering Essay

• This form (section) gets displayed even if user selects any option other than 'B.S.E - Bachelor of Science in Engineering (engineering and applied sciences)' for question 'Which degree would you most likely pursue at Princeton' (in section Princeton University - Applicant Information) fixed in rev: 6599 (deepak)

Amherst College

• Athletics Supplement
  --"Please list any times, events, records, awards, etc. (150 words max)" and "Additional Comments (150 words -
  max)" have javascrpt error : Error: count_element has no properties Source File:http://application5.questbridge.org/modules/civicrm/js/Common.js] Line: 568 (This is common for most of the essay sections in Partner Supplements) (manish : fixed with revision 6565)

• Essay
  Even though "Amherst College - Essay" field has been marked required, no required rule applied to it. (manish: can not reproduce, rule is already present)

Rice University

• Field "What contacts have you had with Rice (check all that apply)?" has been marked as required field but no required rule applied to it. (manish: resolved with revision no 6569)
• Essays displayed after applicant selects 'Architecture' for 'academic school you are applying to' field, are marked as required in mock up. but no required rule applied. (manish: resolved with revision no 6569)

Wellesley College

• Applicant form
  Reuired rule not applied to "Please indicate no more than two areas of academic interest". (manish: cannot reproduce, rule is already present)

Recommender "Applications" (Teacher and Counselor)

      
*Counselor - Evaluation
1)"Is there a broader context in which we should consider the candidate's performance and involvements?" and "To the best of your knowledge, has the student ever violated an Honor Code or been suspended or subjected to any school-related or legal disciplinary action?" are not editing the values(fixed in revision 6591.) (Anil)

*Teacher - Student Ranking (onwords)
1) top Display (Welcome) Name is incorrect.  (Anil)

 Application Related

• -With the 'Submit Application' link not active, user can't tell it there are any errors on the application.-Changed code so that this link is always active. User is taken to first incomplete section with a message if they are not finished. Rev 6537(dgg)
• 'Submit Application' link doesn't point to right URL. Rev 6537 (dgg)