CiviCRM Community Forums (archive)

Hi,

I have created a profile for online registration its working fine. I copied that profile for other event and try to register online it is giving following error


Database Error Code: Unknown column 'civicrm_value_participant_information_12.id' in 'field list', 1054
Additional Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
• [1] => handle
          )
  
     

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT DISTINCT(contact_a.id) as contact_id, civicrm_participant.id as participant_id, civicrm_value_participant_information_12.id as civicrm_value_participant_information_12_id, civicrm_value_participant_information_12.paricipant_title_122 as custom_122, civicrm_value_participant_information_12.participant_middle_name_124 as custom_124, civicrm_value_participant_information_12.participani_first_name_125 as custom_125, civicrm_value_participant_information_12.name_on_badge__exactly_as_want_p_126 as custom_126, civicrm_value_participant_information_12.organisation_institution_127 as custom_127, civicrm_value_participant_information_12.participant_city_129 as custom_129, civicrm_value_participant_information_12.participant_country_130 as custom_130, civicrm_value_participant_information_12.participant_state_131 as custom_131, civicrm_value_participant_information_12.participant_zip_132 as custom_132, civicrm_value_participant_information_12.telephone_133 as custom_133, civicrm_value_participant_information_12.participant_fax_134 as custom_134, civicrm_value_participant_information_12.nationality_136 as custom_136, civicrm_value_participant_information_12.gender_137 as custom_137, civicrm_value_participant_information_12.passport_no_138 as custom_138, civicrm_value_place_where_visa_will_be_issued_13.id as civicrm_value_place_where_visa_will_be_issued_13_id, civicrm_value_place_where_visa_will_be_issued_13.visa_city_140 as custom_140, civicrm_value_accompanying_person_14.id as civicrm_value_accompanying_person_14_id, civicrm_value_accompanying_person_14.person_name_142 as custom_142, civicrm_value_accompanying_person_14.person_passport_no_143 as custom_143, civicrm_value_participant_information_12.place_where_visa_will_be_issued_147 as custom_147, civicrm_value_participant_information_12.accompanying_person_148 as custom_148, civicrm_value_place_where_visa_will_be_issued_13.visa_country_150 as custom_150, civicrm_value_participant_information_12.mailing_address_151 as custom_151, civicrm_value_abstract_submission_16.id as civicrm_value_abstract_submission_16_id, civicrm_value_abstract_submission_16.affiliation_hospital_university__204 as custom_204, civicrm_value_code_17.id as civicrm_value_code_17_id, civicrm_value_code_17.code_given_by_iapb2_237 as custom_237  FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id 
LEFT JOIN civicrm_value_abstract_submission_16 ON civicrm_value_abstract_submission_16.entity_id = civicrm_participant.id 
LEFT JOIN civicrm_value_code_17 ON civicrm_value_code_17.entity_id = civicrm_participant.id  WHERE  ( contact_a.id = 9670 AND civicrm_participant.id = 59 AND civicrm_participant.is_test = 0 )  AND  ( 1 )     [nativecode=1054 ** Unknown column 'civicrm_value_participant_information_12.id' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT(contact_a.id) as contact_id, civicrm_participant.id as participant_id, civicrm_value_participant_information_12.id as civicrm_value_participant_information_12_id, civicrm_value_participant_information_12.paricipant_title_122 as custom_122, civicrm_value_participant_information_12.participant_middle_name_124 as custom_124, civicrm_value_participant_information_12.participani_first_name_125 as custom_125, civicrm_value_participant_information_12.name_on_badge__exactly_as_want_p_126 as custom_126, civicrm_value_participant_information_12.organisation_institution_127 as custom_127, civicrm_value_participant_information_12.participant_city_129 as custom_129, civicrm_value_participant_information_12.participant_country_130 as custom_130, civicrm_value_participant_information_12.participant_state_131 as custom_131, civicrm_value_participant_information_12.participant_zip_132 as custom_132, civicrm_value_participant_information_12.telephone_133 as custom_133, civicrm_value_participant_information_12.participant_fax_134 as custom_134, civicrm_value_participant_information_12.nationality_136 as custom_136, civicrm_value_participant_information_12.gender_137 as custom_137, civicrm_value_participant_information_12.passport_no_138 as custom_138, civicrm_value_place_where_visa_will_be_issued_13.id as civicrm_value_place_where_visa_will_be_issued_13_id, civicrm_value_place_where_visa_will_be_issued_13.visa_city_140 as custom_140, civicrm_value_accompanying_person_14.id as civicrm_value_accompanying_person_14_id, civicrm_value_accompanying_person_14.person_name_142 as custom_142, civicrm_value_accompanying_person_14.person_passport_no_143 as custom_143, civicrm_value_participant_information_12.place_where_visa_will_be_issued_147 as custom_147, civicrm_value_participant_information_12.accompanying_person_148 as custom_148, civicrm_value_place_where_visa_will_be_issued_13.visa_country_150 as custom_150, civicrm_value_participant_information_12.mailing_address_151 as custom_151, civicrm_value_abstract_submission_16.id as civicrm_value_abstract_submission_16_id, civicrm_value_abstract_submission_16.affiliation_hospital_university__204 as custom_204, civicrm_value_code_17.id as civicrm_value_code_17_id, civicrm_value_code_17.code_given_by_iapb2_237 as custom_237  FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id 
LEFT JOIN civicrm_value_abstract_submission_16 ON civicrm_value_abstract_submission_16.entity_id = civicrm_participant.id 
LEFT JOIN civicrm_value_code_17 ON civicrm_value_code_17.entity_id = civicrm_participant.id  WHERE  ( contact_a.id = 9670 AND civicrm_participant.id = 59 AND civicrm_participant.is_test = 0 )  AND  ( 1 )     [nativecode=1054 ** Unknown column 'civicrm_value_participant_information_12.id' in 'field list']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT DISTINCT(contact_a.id) as contact_id, civicrm_participant.id as participant_id, civicrm_value_participant_information_12.id as civicrm_value_participant_information_12_id, civicrm_value_participant_information_12.paricipant_title_122 as custom_122, civicrm_value_participant_information_12.participant_middle_name_124 as custom_124, civicrm_value_participant_information_12.participani_first_name_125 as custom_125, civicrm_value_participant_information_12.name_on_badge__exactly_as_want_p_126 as custom_126, civicrm_value_participant_information_12.organisation_institution_127 as custom_127, civicrm_value_participant_information_12.participant_city_129 as custom_129, civicrm_value_participant_information_12.participant_country_130 as custom_130, civicrm_value_participant_information_12.participant_state_131 as custom_131, civicrm_value_participant_information_12.participant_zip_132 as custom_132, civicrm_value_participant_information_12.telephone_133 as custom_133, civicrm_value_participant_information_12.participant_fax_134 as custom_134, civicrm_value_participant_information_12.nationality_136 as custom_136, civicrm_value_participant_information_12.gender_137 as custom_137, civicrm_value_participant_information_12.passport_no_138 as custom_138, civicrm_value_place_where_visa_will_be_issued_13.id as civicrm_value_place_where_visa_will_be_issued_13_id, civicrm_value_place_where_visa_will_be_issued_13.visa_city_140 as custom_140, civicrm_value_accompanying_person_14.id as civicrm_value_accompanying_person_14_id, civicrm_value_accompanying_person_14.person_name_142 as custom_142, civicrm_value_accompanying_person_14.person_passport_no_143 as custom_143, civicrm_value_participant_information_12.place_where_visa_will_be_issued_147 as custom_147, civicrm_value_participant_information_12.accompanying_person_148 as custom_148, civicrm_value_place_where_visa_will_be_issued_13.visa_country_150 as custom_150, civicrm_value_participant_information_12.mailing_address_151 as custom_151, civicrm_value_abstract_submission_16.id as civicrm_value_abstract_submission_16_id, civicrm_value_abstract_submission_16.affiliation_hospital_university__204 as custom_204, civicrm_value_code_17.id as civicrm_value_code_17_id, civicrm_value_code_17.code_given_by_iapb2_237 as custom_237  FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id 
LEFT JOIN civicrm_value_abstract_submission_16 ON civicrm_value_abstract_submission_16.entity_id = civicrm_participant.id 
LEFT JOIN civicrm_value_code_17 ON civicrm_value_code_17.entity_id = civicrm_participant.id  WHERE  ( contact_a.id = 9670 AND civicrm_participant.id = 59 AND civicrm_participant.is_test = 0 )  AND  ( 1 )     [nativecode=1054 ** Unknown column 'civicrm_value_participant_information_12.id' in 'field list']"]
)

Can any body help me please. I struck out here.