CiviCRM Community Forums (archive)

Hello all,

I've recently begun having errors using activities (creating new, editing existing, and searching) in CiviCRM (3.3.5). I had previously created a couple of custom fields associated with new activities, but subsequently deleted them. The code below is what I received after trying to search activities (event with no criteria).

Any suggestions would be greatly appreciated!

Tara


Database Error Code: Unknown column 'civicrm_value_funding_available_12.funding_application_proceeding__81' 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 ( civicrm_activity.id ), contact_a.id as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, contact_a.display_name  as `display_name`, civicrm_activity.id as activity_id, activity_type.label as activity_type, civicrm_activity.subject as activity_subject, civicrm_activity.activity_date_time as activity_date_time, activity_status.label as activity_status, civicrm_activity.duration as activity_duration, civicrm_activity.location as activity_location, civicrm_activity.details as activity_details, civicrm_activity.source_record_id as source_record_id, civicrm_activity.is_test as activity_is_test, civicrm_activity.source_contact_id as `source_contact_id`, civicrm_value_fund_application_6.id as civicrm_value_fund_application_6_id, civicrm_value_fund_application_6.program_name_24 as custom_24, civicrm_value_fund_application_6.funder_program_name_29 as custom_29, civicrm_value_fund_application_6.program_39 as custom_39, civicrm_value_fund_application_6.application_amount_40 as custom_40, civicrm_value_fund_application_6.currency_41 as custom_41, civicrm_value_fund_application_6.funding_type_42 as custom_42, civicrm_value_fund_application_6.branch_43 as custom_43, civicrm_value_fund_application_6.successful__44 as custom_44, civicrm_value_fund_application_6.amount_promised_45 as custom_45, civicrm_value_fund_application_6.amount_received_46 as custom_46, civicrm_value_fund_application_6.letter_of_inquiry_47 as custom_47, civicrm_value_fund_application_6.application_48 as custom_48, civicrm_value_fund_application_6.application_submitted_49 as custom_49, civicrm_value_fund_application_6.award_notification_50 as custom_50, civicrm_value_fund_application_6.receipt_of_funds_51 as custom_51, civicrm_value_fund_application_6.application_reference_55 as custom_55, civicrm_value_fund_application_6.donation_type_detail_56 as custom_56, civicrm_value_fund_application_6.final_report_submitted_80 as custom_80, civicrm_value_funding_available_12.id as civicrm_value_funding_available_12_id, civicrm_value_funding_available_12.funder_program_name_58 as custom_58, civicrm_value_funding_available_12.application_deadline_59 as custom_59, civicrm_value_funding_available_12.maximum_application_60 as custom_60, civicrm_value_funding_available_12.previously_applied__61 as custom_61, civicrm_value_funding_available_12.received_funding_previously__62 as custom_62, civicrm_value_funding_available_12.letter_of_interest_required__65 as custom_65, civicrm_value_funding_available_12.loi_submission_date_66 as custom_66, civicrm_value_funding_available_12.for_more_information_67 as custom_67, civicrm_value_funding_available_12.areas_of_interest_68 as custom_68, civicrm_value_funding_available_12.development_director_review_71 as custom_71, civicrm_value_funding_available_12.funding_application_proceeding__81 as custom_81  FROM civicrm_contact contact_a LEFT JOIN civicrm_activity_target ON civicrm_activity_target.target_contact_id = contact_a.id  LEFT JOIN civicrm_activity ON ( civicrm_activity.id = civicrm_activity_target.activity_id
                             AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 ) LEFT JOIN civicrm_option_group option_group_activity_status ON (option_group_activity_status.name = 'activity_status') LEFT JOIN civicrm_option_value activity_status ON (civicrm_activity.status_id = activity_status.value
                               AND option_group_activity_status.id = activity_status.option_group_id )  LEFT JOIN civicrm_option_group option_group_activity_type ON (option_group_activity_type.name = 'activity_type') LEFT JOIN civicrm_option_value activity_type ON (civicrm_activity.activity_type_id = activity_type.value
                               AND option_group_activity_type.id = activity_type.option_group_id ) 
LEFT JOIN civicrm_value_fund_application_6 ON civicrm_value_fund_application_6.entity_id = civicrm_activity.id 
LEFT JOIN civicrm_value_funding_available_12 ON civicrm_value_funding_available_12.entity_id = civicrm_activity.id  WHERE  (  civicrm_activity.status_id IN (1,2) AND civicrm_activity.is_test = 0 )  AND  ( 1 )  GROUP BY civicrm_activity.id   ORDER BY activity_date_time desc  LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_value_funding_available_12.funding_application_proceeding__81' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT DISTINCT ( civicrm_activity.id ), contact_a.id as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, contact_a.display_name  as `display_name`, civicrm_activity.id as activity_id, activity_type.label as activity_type, civicrm_activity.subject as activity_subject, civicrm_activity.activity_date_time as activity_date_time, activity_status.label as activity_status, civicrm_activity.duration as activity_duration, civicrm_activity.location as activity_location, civicrm_activity.details as activity_details, civicrm_activity.source_record_id as source_record_id, civicrm_activity.is_test as activity_is_test, civicrm_activity.source_contact_id as `source_contact_id`, civicrm_value_fund_application_6.id as civicrm_value_fund_application_6_id, civicrm_value_fund_application_6.program_name_24 as custom_24, civicrm_value_fund_application_6.funder_program_name_29 as custom_29, civicrm_value_fund_application_6.program_39 as custom_39, civicrm_value_fund_application_6.application_amount_40 as custom_40, civicrm_value_fund_application_6.currency_41 as custom_41, civicrm_value_fund_application_6.funding_type_42 as custom_42, civicrm_value_fund_application_6.branch_43 as custom_43, civicrm_value_fund_application_6.successful__44 as custom_44, civicrm_value_fund_application_6.amount_promised_45 as custom_45, civicrm_value_fund_application_6.amount_received_46 as custom_46, civicrm_value_fund_application_6.letter_of_inquiry_47 as custom_47, civicrm_value_fund_application_6.application_48 as custom_48, civicrm_value_fund_application_6.application_submitted_49 as custom_49, civicrm_value_fund_application_6.award_notification_50 as custom_50, civicrm_value_fund_application_6.receipt_of_funds_51 as custom_51, civicrm_value_fund_application_6.application_reference_55 as custom_55, civicrm_value_fund_application_6.donation_type_detail_56 as custom_56, civicrm_value_fund_application_6.final_report_submitted_80 as custom_80, civicrm_value_funding_available_12.id as civicrm_value_funding_available_12_id, civicrm_value_funding_available_12.funder_program_name_58 as custom_58, civicrm_value_funding_available_12.application_deadline_59 as custom_59, civicrm_value_funding_available_12.maximum_application_60 as custom_60, civicrm_value_funding_available_12.previously_applied__61 as custom_61, civicrm_value_funding_available_12.received_funding_previously__62 as custom_62, civicrm_value_funding_available_12.letter_of_interest_required__65 as custom_65, civicrm_value_funding_available_12.loi_submission_date_66 as custom_66, civicrm_value_funding_available_12.for_more_information_67 as custom_67, civicrm_value_funding_available_12.areas_of_interest_68 as custom_68, civicrm_value_funding_available_12.development_director_review_71 as custom_71, civicrm_value_funding_available_12.funding_application_proceeding__81 as custom_81  FROM civicrm_contact contact_a LEFT JOIN civicrm_activity_target ON civicrm_activity_target.target_contact_id = contact_a.id  LEFT JOIN civicrm_activity ON ( civicrm_activity.id = civicrm_activity_target.activity_id
                             AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 ) LEFT JOIN civicrm_option_group option_group_activity_status ON (option_group_activity_status.name = 'activity_status') LEFT JOIN civicrm_option_value activity_status ON (civicrm_activity.status_id = activity_status.value
                               AND option_group_activity_status.id = activity_status.option_group_id )  LEFT JOIN civicrm_option_group option_group_activity_type ON (option_group_activity_type.name = 'activity_type') LEFT JOIN civicrm_option_value activity_type ON (civicrm_activity.activity_type_id = activity_type.value
                               AND option_group_activity_type.id = activity_type.option_group_id ) 
LEFT JOIN civicrm_value_fund_application_6 ON civicrm_value_fund_application_6.entity_id = civicrm_activity.id 
LEFT JOIN civicrm_value_funding_available_12 ON civicrm_value_funding_available_12.entity_id = civicrm_activity.id  WHERE  (  civicrm_activity.status_id IN (1,2) AND civicrm_activity.is_test = 0 )  AND  ( 1 )  GROUP BY civicrm_activity.id   ORDER BY activity_date_time desc  LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_value_funding_available_12.funding_application_proceeding__81' 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 ( civicrm_activity.id ), contact_a.id as contact_id, contact_a.contact_type  as `contact_type`, contact_a.contact_sub_type  as `contact_sub_type`, contact_a.sort_name  as `sort_name`, contact_a.display_name  as `display_name`, civicrm_activity.id as activity_id, activity_type.label as activity_type, civicrm_activity.subject as activity_subject, civicrm_activity.activity_date_time as activity_date_time, activity_status.label as activity_status, civicrm_activity.duration as activity_duration, civicrm_activity.location as activity_location, civicrm_activity.details as activity_details, civicrm_activity.source_record_id as source_record_id, civicrm_activity.is_test as activity_is_test, civicrm_activity.source_contact_id as `source_contact_id`, civicrm_value_fund_application_6.id as civicrm_value_fund_application_6_id, civicrm_value_fund_application_6.program_name_24 as custom_24, civicrm_value_fund_application_6.funder_program_name_29 as custom_29, civicrm_value_fund_application_6.program_39 as custom_39, civicrm_value_fund_application_6.application_amount_40 as custom_40, civicrm_value_fund_application_6.currency_41 as custom_41, civicrm_value_fund_application_6.funding_type_42 as custom_42, civicrm_value_fund_application_6.branch_43 as custom_43, civicrm_value_fund_application_6.successful__44 as custom_44, civicrm_value_fund_application_6.amount_promised_45 as custom_45, civicrm_value_fund_application_6.amount_received_46 as custom_46, civicrm_value_fund_application_6.letter_of_inquiry_47 as custom_47, civicrm_value_fund_application_6.application_48 as custom_48, civicrm_value_fund_application_6.application_submitted_49 as custom_49, civicrm_value_fund_application_6.award_notification_50 as custom_50, civicrm_value_fund_application_6.receipt_of_funds_51 as custom_51, civicrm_value_fund_application_6.application_reference_55 as custom_55, civicrm_value_fund_application_6.donation_type_detail_56 as custom_56, civicrm_value_fund_application_6.final_report_submitted_80 as custom_80, civicrm_value_funding_available_12.id as civicrm_value_funding_available_12_id, civicrm_value_funding_available_12.funder_program_name_58 as custom_58, civicrm_value_funding_available_12.application_deadline_59 as custom_59, civicrm_value_funding_available_12.maximum_application_60 as custom_60, civicrm_value_funding_available_12.previously_applied__61 as custom_61, civicrm_value_funding_available_12.received_funding_previously__62 as custom_62, civicrm_value_funding_available_12.letter_of_interest_required__65 as custom_65, civicrm_value_funding_available_12.loi_submission_date_66 as custom_66, civicrm_value_funding_available_12.for_more_information_67 as custom_67, civicrm_value_funding_available_12.areas_of_interest_68 as custom_68, civicrm_value_funding_available_12.development_director_review_71 as custom_71, civicrm_value_funding_available_12.funding_application_proceeding__81 as custom_81  FROM civicrm_contact contact_a LEFT JOIN civicrm_activity_target ON civicrm_activity_target.target_contact_id = contact_a.id  LEFT JOIN civicrm_activity ON ( civicrm_activity.id = civicrm_activity_target.activity_id
                             AND civicrm_activity.is_deleted = 0 AND civicrm_activity.is_current_revision = 1 ) LEFT JOIN civicrm_option_group option_group_activity_status ON (option_group_activity_status.name = 'activity_status') LEFT JOIN civicrm_option_value activity_status ON (civicrm_activity.status_id = activity_status.value
                               AND option_group_activity_status.id = activity_status.option_group_id )  LEFT JOIN civicrm_option_group option_group_activity_type ON (option_group_activity_type.name = 'activity_type') LEFT JOIN civicrm_option_value activity_type ON (civicrm_activity.activity_type_id = activity_type.value
                               AND option_group_activity_type.id = activity_type.option_group_id ) 
LEFT JOIN civicrm_value_fund_application_6 ON civicrm_value_fund_application_6.entity_id = civicrm_activity.id 
LEFT JOIN civicrm_value_funding_available_12 ON civicrm_value_funding_available_12.entity_id = civicrm_activity.id  WHERE  (  civicrm_activity.status_id IN (1,2) AND civicrm_activity.is_test = 0 )  AND  ( 1 )  GROUP BY civicrm_activity.id   ORDER BY activity_date_time desc  LIMIT 0, 50  [nativecode=1054 ** Unknown column 'civicrm_value_funding_available_12.funding_application_proceeding__81' in 'field list']"]
)