CiviCRM Community Forums (archive)

Hey guys - first post - if this is the wrong place for it appologies in advance and admins please move.

I am getting a error when I try and view contacts.

I think it is b/c I deleted the default CIVICRM profiles but not sure.

Here is the error code I am getting.

Any assistance greatly appreciated.

Sorry. A non-recoverable error has occurred.
DB Error: no such field

Database Error Code: Unknown column 'civicrm_value_constituent_information_1.date_of_birth_6' in 'field list', 1054

Return to home page.

Error Details:

Array
(
    [callback] => Array
        (
           

• => CRM_Core_Error
[1] => handle
        )

   

=> -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] =>
SELECT civicrm_value_constituent_information_1.id as civicrm_value_constituent_information_1_id, civicrm_value_constituent_information_1.entity_id as civicrm_value_constituent_information_1_entity_id, civicrm_value_constituent_information_1.telephone_number_4 as civicrm_value_constituent_information_1_telephone_number_4, civicrm_value_constituent_information_1.mobile_phone_number_5 as civicrm_value_constituent_information_1_mobile_phone_number_5, civicrm_value_constituent_information_1.desired_military_occupation_spec_7 as civicrm_value_constituent_information_1_desired_military_occupation_spec_7, civicrm_value_constituent_information_1.date_of_birth_6 as civicrm_value_constituent_information_1_date_of_birth_6, civicrm_value_constituent_information_1.marital_status_2 as civicrm_value_constituent_information_1_marital_status_2, civicrm_value_constituent_information_1.marriage_date_3 as civicrm_value_constituent_information_1_marriage_date_3, civicrm_value_test_hmsg_members_info_3.id as civicrm_value_test_hmsg_members_info_3_id, civicrm_value_test_hmsg_members_info_3.entity_id as civicrm_value_test_hmsg_members_info_3_entity_id, civicrm_value_test_hmsg_members_info_3.rank_13 as civicrm_value_test_hmsg_members_info_3_rank_13, civicrm_value_test_hmsg_members_info_3.duty_stations_and_assignments_8 as civicrm_value_test_hmsg_members_info_3_duty_stations_and_assignments_8, civicrm_value_test_hmsg_members_info_3.training_and_qualifications_9 as civicrm_value_test_hmsg_members_info_3_training_and_qualifications_9, civicrm_value_test_hmsg_members_info_3.awards_and_medals_10 as civicrm_value_test_hmsg_members_info_3_awards_and_medals_10, civicrm_value_test_hmsg_members_info_3.disciplinary_actions_11 as civicrm_value_test_hmsg_members_info_3_disciplinary_actions_11, civicrm_value_test_hmsg_members_info_3.administrative_remarks_12 as civicrm_value_test_hmsg_members_info_3_administrative_remarks_12, civicrm_value_test_hmsg_members_info_3.date_of_birth_14 as civicrm_value_test_hmsg_members_info_3_date_of_birth_14
  FROM civicrm_value_constituent_information_1
LEFT JOIN civicrm_value_test_hmsg_members_info_3 USING (entity_id)
 WHERE civicrm_value_constituent_information_1.entity_id = 102
 [nativecode=1054 ** Unknown column 'civicrm_value_constituent_information_1.date_of_birth_6' in 'field list']
    [type] => DB_Error
    [user_info] =>
SELECT civicrm_value_constituent_information_1.id as civicrm_value_constituent_information_1_id, civicrm_value_constituent_information_1.entity_id as civicrm_value_constituent_information_1_entity_id, civicrm_value_constituent_information_1.telephone_number_4 as civicrm_value_constituent_information_1_telephone_number_4, civicrm_value_constituent_information_1.mobile_phone_number_5 as civicrm_value_constituent_information_1_mobile_phone_number_5, civicrm_value_constituent_information_1.desired_military_occupation_spec_7 as civicrm_value_constituent_information_1_desired_military_occupation_spec_7, civicrm_value_constituent_information_1.date_of_birth_6 as civicrm_value_constituent_information_1_date_of_birth_6, civicrm_value_constituent_information_1.marital_status_2 as civicrm_value_constituent_information_1_marital_status_2, civicrm_value_constituent_information_1.marriage_date_3 as civicrm_value_constituent_information_1_marriage_date_3, civicrm_value_test_hmsg_members_info_3.id as civicrm_value_test_hmsg_members_info_3_id, civicrm_value_test_hmsg_members_info_3.entity_id as civicrm_value_test_hmsg_members_info_3_entity_id, civicrm_value_test_hmsg_members_info_3.rank_13 as civicrm_value_test_hmsg_members_info_3_rank_13, civicrm_value_test_hmsg_members_info_3.duty_stations_and_assignments_8 as civicrm_value_test_hmsg_members_info_3_duty_stations_and_assignments_8, civicrm_value_test_hmsg_members_info_3.training_and_qualifications_9 as civicrm_value_test_hmsg_members_info_3_training_and_qualifications_9, civicrm_value_test_hmsg_members_info_3.awards_and_medals_10 as civicrm_value_test_hmsg_members_info_3_awards_and_medals_10, civicrm_value_test_hmsg_members_info_3.disciplinary_actions_11 as civicrm_value_test_hmsg_members_info_3_disciplinary_actions_11, civicrm_value_test_hmsg_members_info_3.administrative_remarks_12 as civicrm_value_test_hmsg_members_info_3_administrative_remarks_12, civicrm_value_test_hmsg_members_info_3.date_of_birth_14 as civicrm_value_test_hmsg_members_info_3_date_of_birth_14
  FROM civicrm_value_constituent_information_1
LEFT JOIN civicrm_value_test_hmsg_members_info_3 USING (entity_id)
 WHERE civicrm_value_constituent_information_1.entity_id = 102
 [nativecode=1054 ** Unknown column 'civicrm_value_constituent_information_1.date_of_birth_6' 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 civicrm_value_constituent_information_1.id as civicrm_value_constituent_information_1_id, civicrm_value_constituent_information_1.entity_id as civicrm_value_constituent_information_1_entity_id, civicrm_value_constituent_information_1.telephone_number_4 as civicrm_value_constituent_information_1_telephone_number_4, civicrm_value_constituent_information_1.mobile_phone_number_5 as civicrm_value_constituent_information_1_mobile_phone_number_5, civicrm_value_constituent_information_1.desired_military_occupation_spec_7 as civicrm_value_constituent_information_1_desired_military_occupation_spec_7, civicrm_value_constituent_information_1.date_of_birth_6 as civicrm_value_constituent_information_1_date_of_birth_6, civicrm_value_constituent_information_1.marital_status_2 as civicrm_value_constituent_information_1_marital_status_2, civicrm_value_constituent_information_1.marriage_date_3 as civicrm_value_constituent_information_1_marriage_date_3, civicrm_value_test_hmsg_members_info_3.id as civicrm_value_test_hmsg_members_info_3_id, civicrm_value_test_hmsg_members_info_3.entity_id as civicrm_value_test_hmsg_members_info_3_entity_id, civicrm_value_test_hmsg_members_info_3.rank_13 as civicrm_value_test_hmsg_members_info_3_rank_13, civicrm_value_test_hmsg_members_info_3.duty_stations_and_assignments_8 as civicrm_value_test_hmsg_members_info_3_duty_stations_and_assignments_8, civicrm_value_test_hmsg_members_info_3.training_and_qualifications_9 as civicrm_value_test_hmsg_members_info_3_training_and_qualifications_9, civicrm_value_test_hmsg_members_info_3.awards_and_medals_10 as civicrm_value_test_hmsg_members_info_3_awards_and_medals_10, civicrm_value_test_hmsg_members_info_3.disciplinary_actions_11 as civicrm_value_test_hmsg_members_info_3_disciplinary_actions_11, civicrm_value_test_hmsg_members_info_3.administrative_remarks_12 as civicrm_value_test_hmsg_members_info_3_administrative_remarks_12, civicrm_value_test_hmsg_members_info_3.date_of_birth_14 as civicrm_value_test_hmsg_members_info_3_date_of_birth_14
  FROM civicrm_value_constituent_information_1
LEFT JOIN civicrm_value_test_hmsg_members_info_3 USING (entity_id)
 WHERE civicrm_value_constituent_information_1.entity_id = 102
 [nativecode=1054 ** Unknown column 'civicrm_value_constituent_information_1.date_of_birth_6' in 'field list']"]
)

Would be good to know the steps that got you to the error condition. You shouldn't wind up with a DB error like that from deleting sample Profiles or sample custom fields (unless perhaps you did some modifications directly to the database and not through the user interface).