CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Contacts error
Pages: [1]

Author Topic: Contacts error  (Read 656 times)

macp0004

  • Guest
Contacts error
October 29, 2009, 09:08:23 am
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
            )

       
Code: [Select]
=> -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']"]
)

macp0004

  • Guest
Re: Contacts error
October 29, 2009, 09:28:16 am
Ah I think it is working now - I went to the Constituent Information and and disabled it and now it seems to work...

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Contacts error
October 29, 2009, 10:10:53 am
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).
Protect your investment in CiviCRM by  becoming a Member!

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • Contacts error

This forum was archived on 2017-11-26.