I'm a little lost for direction on an issue I'm having with this module. I've created a fairly long webform and then discovered I can't use it with Views (to filter the submissions by a specific field value). This module provides some hope, however when I try to activate the webform using admin/content/webform/mysql I get this error message:
Any ideas?
user warning: Incorrect column name 'i_wish_for_my_application_to_be_made_available_for_other_suitable_positions' query: CREATE OR REPLACE VIEW webform_views_application_for_employment AS SELECT parent.sid, s.uid,(SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 1) AS `position_applying_for`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 3) AS `type_of_employment`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 4) AS `application_prelude_blurb`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 5) AS `i_wish_for_my_application_to_be_made_available_for_other_suitable_positions`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 6) AS `note_of_what_to_bring_to_interview`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 8) AS `first_name`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 9) AS `surname`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 19) AS `resume`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 128) AS `page_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 10) AS `address`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 11) AS `address2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 22) AS `are_you_legally_able_to_work_in_australia`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 2) AS `state`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 23) AS `medical_conditions_that_will_affect_your_ability_to_perform_the_role`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 30) AS `australian_recognised_qualifications_achievements`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 12) AS `postcode`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 26) AS `medical_issue_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 32) AS `objections_to_complying_with_a_federal_police_check`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 13) AS `email`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 25) AS `workers_compensation_or_disability_claim`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 33) AS `criminal_convictions`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 38) AS `current_drivers_license`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 27) AS `workers_comp_disability_claim_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 34) AS `criminal_convictions_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 45) AS `i_have_not_worked_previously`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 28) AS `has_the_claim_been_finalised`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 35) AS `prosecution_pending`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 64) AS `extra_info_from_referees`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 36) AS `prosecution_pending_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 46) AS `company_name_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 65) AS `referee_instructions`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 49) AS `period_of_employment_from_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 83) AS `do_you_have_any_reason_to_require_annual_leave_in_the_next_12_months`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 52) AS `period_of_employment_to_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 55) AS `position_held_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 66) AS `referee_name_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 84) AS `annual_leave_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 58) AS `reason_for_leaving_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 47) AS `company_name_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 50) AS `period_of_employment_from_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 129) AS `medical_questionnaire`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 132) AS `declaration_blurb`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 53) AS `period_of_employment_to_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 85) AS `medical_questionnaire_blurb`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 134) AS `privacy_blurb`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 56) AS `position_held_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 59) AS `reason_for_leaving_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 130) AS `submission`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 48) AS `company_name_3`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 51) AS `period_of_employment_from_3`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 67) AS `referee_name_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 39) AS `drivers_license_expiration`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 54) AS `period_of_employment_to_3`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 68) AS `referee_title_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 57) AS `position_held_3`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 69) AS `referee_title_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 60) AS `reason_for_leaving_3`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 70) AS `referee_company_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 61) AS `previously_employed_by_jft`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 71) AS `referee_company_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 40) AS `category_of_drivers_license`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 62) AS `previously_employed_by_jft_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 72) AS `referee_contact_number_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 73) AS `referee_contact_number_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 74) AS `referee_relationship_1`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 75) AS `referee_relationship_2`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 41) AS `drivers_license_cancelled_or_suspended`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 42) AS `if_yes_please_give_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 43) AS `forklift_certificate`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 20) AS `cover_letter`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 15) AS `phone_home`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 16) AS `phone_business`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 17) AS `phone_mobile`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 77) AS `skills_and_competency_testing`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 78) AS `skills_training`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 79) AS `work_heights`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 80) AS `confined_spaces`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 81) AS `abide_by_safety_rules`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 87) AS `are_you_being_treated`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 135) AS `are_you_being_treated_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 88) AS `have_you_been_hospitalised`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 136) AS `have_you_been_hospitalised_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 89) AS `family_history_illness`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 137) AS `family_history_illness_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 90) AS `regular_illness_monitoring`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 138) AS `regular_illness_monitoring_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 91) AS `safety_equipment_impediment`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 139) AS `safety_equipment_impediment_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 92) AS `glasses`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 140) AS `glasses_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 93) AS `do_you_have_prescription_safety_glasses`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 141) AS `do_you_have_prescription_safety_glasses_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 94) AS `have_you_any_current_medical_or_surgical_condition`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 142) AS `have_you_any_current_medical_or_surgical_condition_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 95) AS `do_you_have_any_occupational_allergies`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 143) AS `do_you_have_any_occupational_allergies_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 96) AS `do_you_have_difficulty_understanding_english`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 144) AS `do_you_have_difficulty_understanding_english_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 100) AS `do_you_have_or_have_you_ever_had_any_of_the_following`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 97) AS `lung_problems_asthma_bronchitis`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 145) AS `lung_problems_asthma_bronchitis_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 98) AS `suffered_high_blood_pressure_or_heart_trouble`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 146) AS `suffered_high_blood_pressure_or_heart_trouble_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 99) AS `stomach_problems_ulcers`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 147) AS `stomach_problems_ulcers_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 101) AS `epilepsy_or_blackouts`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 148) AS `epilepsy_or_blackouts_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 102) AS `joint_or_muscular_injuries`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 149) AS `joint_or_muscular_injuries_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 103) AS `back_or_neck_pain`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 150) AS `back_or_neck_pain_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 104) AS `repetitive_strain_overuse_injury`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 151) AS `repetitive_strain_overuse_injury_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 105) AS `hernia`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 152) AS `hernia_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 106) AS `loss_of_hearing_or_ear_infections`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 153) AS `loss_of_hearing_or_ear_infections_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 107) AS `persistent_headaches_or_migraines`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 154) AS `persistent_headaches_or_migraines_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 108) AS `tuberculosis`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 155) AS `tuberculosis_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 109) AS `hepatitis`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 156) AS `hepatitis_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 110) AS `diabetes`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 157) AS `diabetes_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 111) AS `have_you_had_exposure_to_any_of_the_following_in_your_past_positions`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 112) AS `loud_noise_explosives`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 158) AS `loud_noise_explosives_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 113) AS `asbestos_dust`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 159) AS `asbestos_dust_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 114) AS `chemicals`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 160) AS `chemicals_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 115) AS `radiation`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 161) AS `radiation_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 116) AS `physical_action_issues`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 117) AS `walking_on_rough_ground`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 162) AS `walking_on_rough_ground_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 118) AS `standing_or_sitting_for_two_hours_or_more`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 163) AS `standing_or_sitting_for_two_hours_or_more_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 119) AS `turning_your_head_rapidly`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 164) AS `turning_your_head_rapidly_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 120) AS `hearing_a_normal_conversation`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 165) AS `hearing_a_normal_conversation_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 121) AS `climbing_any_ladders`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 166) AS `climbing_any_ladders_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 122) AS `crouching_squatting_lifting`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 167) AS `crouching_squatting_lifting_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 123) AS `kneeling_or_bending`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 168) AS `kneeling_or_bending_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 124) AS `gripping_firmly_with_one_or_both_of_your_hands`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 169) AS `gripping_firmly_with_one_or_both_of_your_hands_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 125) AS `reading_ordinary_print_text_safety_signs`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 170) AS `reading_ordinary_print_text_safety_signs_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 126) AS `repetitive_movements_of_the_hands_or_arms`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 171) AS `repetitive_movements_of_the_hands_or_arms_details`, (SELECT GROUP_CONCAT(data) FROM webform_submitted_data AS child WHERE child.sid = parent.sid AND cid = 127) AS `pre_employment_medical`, FROM_UNIXTIME(s.submitted) AS submitted, s.remote_addr FROM webform_submitted_data AS parent JOIN webform_submissions s ON s.sid = parent.sid WHERE parent.nid = 21 GROUP BY parent.sid ORDER BY parent.sid DESC; in /Web Files/JFT - John Farraghers Transport/website/farragher.com.au/version 1 (Drupal 6)/website/sites/default/modules/webform_mysql_views/webform_mysql_views.module on line 121.
Data module was unable to adopt view webform_views_application_for_employment.
Comments
Comment #1
mpavankumar commentedwere you able to solve this issue?
Comment #2
cafuego commentedThe view uses the value of a field key as column name, and in this case that key is longer than the 64 character mysql allows. Change the form key on the i_wish_for_my_application_to_be_made_available_for_other_suitable_positions form item and you should be fine.
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html
Comment #3
cafuego commentedThe patch on comment #1 in issue #1434764: Duplicate field names prevent MySQL view from being created should solve your problem without you needing to change form fields.
Comment #4
sydneyshan commentedHi cafuego,
I ended up using http://drupal.org/project/webform_views_submitted due to a tight turnaround on this project, which worked perfectly. If the suggested fix works in your tests feel free to mark this issue as resolved.
Comment #5
cafuego commentedFix for this has been applied to 6.x-2.x, please test.