Custom Field Tables Missing

[markandphil]

I've upgraded all the way from CiviCRM 3.3.6 on Drupal to CiviCRM 4.5.1 on Wordpress.

EVERYTHING is working except for some reason there are no custom field tables which is causing us to get a "DB Error: no such table".

I looked in the error logs and this is the thing that pops out most at me.

Code: [Select]

Nov 05 10:56:59  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
      SELECT civicrm_value_major_donor_info_5.id as civicrm_value_major_donor_info_5_id, civicrm_value_major_donor_info_5.entity_id as civicrm_value_major_donor_info_5_entity_id, civicrm_value_major_donor_info_5.phase_18 as civicrm_value_major_donor_info_5_phase_18, civicrm_value_major_donor_info_5.last_move_19 as civicrm_value_major_donor_info_5_last_move_19, civicrm_value_major_donor_info_5.last_move_date_20 as civicrm_value_major_donor_info_5_last_move_date_20, civicrm_value_major_donor_info_5.next_move_21 as civicrm_value_major_donor_info_5_next_move_21, civicrm_value_major_donor_info_5.next_move_date_22 as civicrm_value_major_donor_info_5_next_move_date_22, civicrm_value_major_donor_info_5.interest_area_23 as civicrm_value_major_donor_info_5_interest_area_23, civicrm_value_major_donor_info_5.donation_capacity_24 as civicrm_value_major_donor_info_5_donation_capacity_24, civicrm_value_major_donor_info_5.other_notes_26 as civicrm_value_major_donor_info_5_other_notes_26, civicrm_value_learning_tech_info_2.id as civicrm_value_learning_tech_info_2_id, civicrm_value_learning_tech_info_2.entity_id as civicrm_value_learning_tech_info_2_entity_id, civicrm_value_learning_tech_info_2.are_you_a_teacher__5 as civicrm_value_learning_tech_info_2_are_you_a_teacher__5, civicrm_value_learning_tech_info_2.what_subjects_do_you_teach__6 as civicrm_value_learning_tech_info_2_what_subjects_do_you_teach__6, civicrm_value_learning_tech_info_2.what_age_groups_do_you_teach__7 as civicrm_value_learning_tech_info_2_what_age_groups_do_you_teach__7, civicrm_value_learning_tech_info_2.what_state_do_you_teach_in__10 as civicrm_value_learning_tech_info_2_what_state_do_you_teach_in__10, civicrm_value_learning_tech_info_2.i_would_be_willing_to_evaluate_y_11 as civicrm_value_learning_tech_info_2_i_would_be_willing_to_evaluate_y_11, civicrm_value_learning_tech_info_2.comments__ltp__9 as civicrm_value_learning_tech_info_2_comments__ltp__9, civicrm_value_political_demographics_6.id as civicrm_value_political_demographics_6_id, civicrm_value_political_demographics_6.entity_id as civicrm_value_political_demographics_6_entity_id, civicrm_value_political_demographics_6.congressional_district_27 as civicrm_value_political_demographics_6_congressional_district_27, civicrm_value_political_demographics_6.cong_district_manual_override_28 as civicrm_value_political_demographics_6_cong_district_manual_override_28, civicrm_value_occupation_7.id as civicrm_value_occupation_7_id, civicrm_value_occupation_7.entity_id as civicrm_value_occupation_7_entity_id, civicrm_value_occupation_7.occupation_31 as civicrm_value_occupation_7_occupation_31, civicrm_value_occupation_7.employer_32 as civicrm_value_occupation_7_employer_32, civicrm_value_individual_prefix_8.id as civicrm_value_individual_prefix_8_id, civicrm_value_individual_prefix_8.entity_id as civicrm_value_individual_prefix_8_entity_id, civicrm_value_individual_prefix_8.mr__33 as civicrm_value_individual_prefix_8_mr__33, civicrm_value_individual_prefix_8.mrs__34 as civicrm_value_individual_prefix_8_mrs__34
      FROM  (SELECT 51441 as entity_id ) as first
LEFT JOIN civicrm_value_major_donor_info_5 USING (entity_id)
LEFT JOIN civicrm_value_learning_tech_info_2 USING (entity_id)
LEFT JOIN civicrm_value_political_demographics_6 USING (entity_id)
LEFT JOIN civicrm_value_occupation_7 USING (entity_id)
LEFT JOIN civicrm_value_individual_prefix_8 USING (entity_id)
      WHERE first.entity_id = 51441
     [nativecode=1146 ** Table 'knjewfmedu.civicrm_value_major_donor_info_5' doesn't exist]
    [type] => DB_Error
    [user_info] =>
      SELECT civicrm_value_major_donor_info_5.id as civicrm_value_major_donor_info_5_id, civicrm_value_major_donor_info_5.entity_id as civicrm_value_major_donor_info_5_entity_id, civicrm_value_major_donor_info_5.phase_18 as civicrm_value_major_donor_info_5_phase_18, civicrm_value_major_donor_info_5.last_move_19 as civicrm_value_major_donor_info_5_last_move_19, civicrm_value_major_donor_info_5.last_move_date_20 as civicrm_value_major_donor_info_5_last_move_date_20, civicrm_value_major_donor_info_5.next_move_21 as civicrm_value_major_donor_info_5_next_move_21, civicrm_value_major_donor_info_5.next_move_date_22 as civicrm_value_major_donor_info_5_next_move_date_22, civicrm_value_major_donor_info_5.interest_area_23 as civicrm_value_major_donor_info_5_interest_area_23, civicrm_value_major_donor_info_5.donation_capacity_24 as civicrm_value_major_donor_info_5_donation_capacity_24, civicrm_value_major_donor_info_5.other_notes_26 as civicrm_value_major_donor_info_5_other_notes_26, civicrm_value_learning_tech_info_2.id as civicrm_value_learning_tech_info_2_id, civicrm_value_learning_tech_info_2.entity_id as civicrm_value_learning_tech_info_2_entity_id, civicrm_value_learning_tech_info_2.are_you_a_teacher__5 as civicrm_value_learning_tech_info_2_are_you_a_teacher__5, civicrm_value_learning_tech_info_2.what_subjects_do_you_teach__6 as civicrm_value_learning_tech_info_2_what_subjects_do_you_teach__6, civicrm_value_learning_tech_info_2.what_age_groups_do_you_teach__7 as civicrm_value_learning_tech_info_2_what_age_groups_do_you_teach__7, civicrm_value_learning_tech_info_2.what_state_do_you_teach_in__10 as civicrm_value_learning_tech_info_2_what_state_do_you_teach_in__10, civicrm_value_learning_tech_info_2.i_would_be_willing_to_evaluate_y_11 as civicrm_value_learning_tech_info_2_i_would_be_willing_to_evaluate_y_11, civicrm_value_learning_tech_info_2.comments__ltp__9 as civicrm_value_learning_tech_info_2_comments__ltp__9, civicrm_value_political_demographics_6.id as civicrm_value_political_demographics_6_id, civicrm_value_political_demographics_6.entity_id as civicrm_value_political_demographics_6_entity_id, civicrm_value_political_demographics_6.congressional_district_27 as civicrm_value_political_demographics_6_congressional_district_27, civicrm_value_political_demographics_6.cong_district_manual_override_28 as civicrm_value_political_demographics_6_cong_district_manual_override_28, civicrm_value_occupation_7.id as civicrm_value_occupation_7_id, civicrm_value_occupation_7.entity_id as civicrm_value_occupation_7_entity_id, civicrm_value_occupation_7.occupation_31 as civicrm_value_occupation_7_occupation_31, civicrm_value_occupation_7.employer_32 as civicrm_value_occupation_7_employer_32, civicrm_value_individual_prefix_8.id as civicrm_value_individual_prefix_8_id, civicrm_value_individual_prefix_8.entity_id as civicrm_value_individual_prefix_8_entity_id, civicrm_value_individual_prefix_8.mr__33 as civicrm_value_individual_prefix_8_mr__33, civicrm_value_individual_prefix_8.mrs__34 as civicrm_value_individual_prefix_8_mrs__34
      FROM  (SELECT 51441 as entity_id ) as first
LEFT JOIN civicrm_value_major_donor_info_5 USING (entity_id)
LEFT JOIN civicrm_value_learning_tech_info_2 USING (entity_id)
LEFT JOIN civicrm_value_political_demographics_6 USING (entity_id)
LEFT JOIN civicrm_value_occupation_7 USING (entity_id)
LEFT JOIN civicrm_value_individual_prefix_8 USING (entity_id)
      WHERE first.entity_id = 51441
     [nativecode=1146 ** Table 'knjewfmedu.civicrm_value_major_donor_info_5' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="
      SELECT civicrm_value_major_donor_info_5.id as civicrm_value_major_donor_info_5_id, civicrm_value_major_donor_info_5.entity_id as civicrm_value_major_donor_info_5_entity_id, civicrm_value_major_donor_info_5.phase_18 as civicrm_value_major_donor_info_5_phase_18, civicrm_value_major_donor_info_5.last_move_19 as civicrm_value_major_donor_info_5_last_move_19, civicrm_value_major_donor_info_5.last_move_date_20 as civicrm_value_major_donor_info_5_last_move_date_20, civicrm_value_major_donor_info_5.next_move_21 as civicrm_value_major_donor_info_5_next_move_21, civicrm_value_major_donor_info_5.next_move_date_22 as civicrm_value_major_donor_info_5_next_move_date_22, civicrm_value_major_donor_info_5.interest_area_23 as civicrm_value_major_donor_info_5_interest_area_23, civicrm_value_major_donor_info_5.donation_capacity_24 as civicrm_value_major_donor_info_5_donation_capacity_24, civicrm_value_major_donor_info_5.other_notes_26 as civicrm_value_major_donor_info_5_other_notes_26, civicrm_value_learning_tech_info_2.id as civicrm_value_learning_tech_info_2_id, civicrm_value_learning_tech_info_2.entity_id as civicrm_value_learning_tech_info_2_entity_id, civicrm_value_learning_tech_info_2.are_you_a_teacher__5 as civicrm_value_learning_tech_info_2_are_you_a_teacher__5, civicrm_value_learning_tech_info_2.what_subjects_do_you_teach__6 as civicrm_value_learning_tech_info_2_what_subjects_do_you_teach__6, civicrm_value_learning_tech_info_2.what_age_groups_do_you_teach__7 as civicrm_value_learning_tech_info_2_what_age_groups_do_you_teach__7, civicrm_value_learning_tech_info_2.what_state_do_you_teach_in__10 as civicrm_value_learning_tech_info_2_what_state_do_you_teach_in__10, civicrm_value_learning_tech_info_2.i_would_be_willing_to_evaluate_y_11 as civicrm_value_learning_tech_info_2_i_would_be_willing_to_evaluate_y_11, civicrm_value_learning_tech_info_2.comments__ltp__9 as civicrm_value_learning_tech_info_2_comments__ltp__9, civicrm_value_political_demographics_6.id as civicrm_value_political_demographics_6_id, civicrm_value_political_demographics_6.entity_id as civicrm_value_political_demographics_6_entity_id, civicrm_value_political_demographics_6.congressional_district_27 as civicrm_value_political_demographics_6_congressional_district_27, civicrm_value_political_demographics_6.cong_district_manual_override_28 as civicrm_value_political_demographics_6_cong_district_manual_override_28, civicrm_value_occupation_7.id as civicrm_value_occupation_7_id, civicrm_value_occupation_7.entity_id as civicrm_value_occupation_7_entity_id, civicrm_value_occupation_7.occupation_31 as civicrm_value_occupation_7_occupation_31, civicrm_value_occupation_7.employer_32 as civicrm_value_occupation_7_employer_32, civicrm_value_individual_prefix_8.id as civicrm_value_individual_prefix_8_id, civicrm_value_individual_prefix_8.entity_id as civicrm_value_individual_prefix_8_entity_id, civicrm_value_individual_prefix_8.mr__33 as civicrm_value_individual_prefix_8_mr__33, civicrm_value_individual_prefix_8.mrs__34 as civicrm_value_individual_prefix_8_mrs__34
      FROM  (SELECT 51441 as entity_id ) as first
LEFT JOIN civicrm_value_major_donor_info_5 USING (entity_id)
LEFT JOIN civicrm_value_learning_tech_info_2 USING (entity_id)
LEFT JOIN civicrm_value_political_demographics_6 USING (entity_id)
LEFT JOIN civicrm_value_occupation_7 USING (entity_id)
LEFT JOIN civicrm_value_individual_prefix_8 USING (entity_id)
      WHERE first.entity_id = 51441
     [nativecode=1146 ** Table 'knjewfmedu.civicrm_value_major_donor_info_5' doesn't exist]"]
)
I've looked back at the SQL before we upgraded everything and I don't see these tables in there either. So I'm pretty stumped as to what is going on. I also searched online and through the forums but didn't see anyone mentioning a problem like this.

Is there someway we can create these tables correctly?

Thanks!

[Michael McAndrew]

Those tables you are missing at the tables that store your custom data.

I've looked back at the SQL before we upgraded everything and I don't see these tables in there either.

If you had custom data in your old DB, then you also had those tables.

Is there someway we can create these tables correctly?

It doesn't really make sense to talk about *creating* those tables at this stage, since theortically, you could create new empty tables, but they wouldn't have your data in. What you need to do is find them (they were there at some point) and make sure they go through the upgrade as well.

Michael

[markandphil]

Thanks so much Michael! All set now. Found them in an old SQL backup we had.

Cheers!

[Michael McAndrew]

Good work making the backup in the first place