Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-8227

SQL error on contact dashboard

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Cannot Reproduce
    • Affects Version/s: 3.3.6
    • Fix Version/s: 3.4.2
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      When a website visitor goes to their personal dashboard ( URL: /civicrm/user?reset=1)

      There is an SQL error, pasted below. This started happening after a custom field for participants was deleted.

      Additional Details:

      Array
      (
      [callback] => Array
      (
      [0] => CRM_Core_Error
      [1] => handle
      )

      [code] => -19
      [message] => DB Error: no such field
      [mode] => 16
      [debug_info] => SELECT DISTINCT(civicrm_participant.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_event.id as event_id, civicrm_event.title as event_title, civicrm_event.start_date as event_start_date, civicrm_event.end_date as event_end_date, civicrm_participant.id as participant_id, civicrm_participant.fee_level as participant_fee_level, civicrm_participant.fee_amount as participant_fee_amount, civicrm_participant.fee_currency as participant_fee_currency, event_type.label as event_type, participant_status.label as participant_status, participant_status.id as participant_status_id, civicrm_participant.role_id as participant_role_id, civicrm_participant.register_date as participant_register_date, civicrm_participant.source as participant_source, civicrm_note.note as participant_note, civicrm_participant.is_pay_later as participant_is_pay_later, civicrm_participant.is_test as participant_is_test, civicrm_participant.registered_by_id as participant_registered_by_id, discount_name.label as participant_discount_name, civicrm_value_extra_participant_info_12.id as civicrm_value_extra_participant_info_12_id, civicrm_value_extra_participant_info_12.note_14 as custom_14, civicrm_value_extra_participant_info_12.number_of_bracelets_35 as custom_35, civicrm_value_extra_participant_info_12.number_of_tickets_36 as custom_36, civicrm_value_extra_participant_info_12.do_you_require_vegetarian_option_37 as custom_37, civicrm_value_extra_participant_info_12.meal_choice_38 as custom_38, civicrm_value_extra_participant_info_12.number_of_children_tickets_39 as custom_39, civicrm_value_extra_participant_info_12.how_many_additional_passengers_a_41 as custom_41, civicrm_value_extra_participant_info_12.do_you_need_a_ride__42 as custom_42, civicrm_value_extra_participant_info_12.any_dietary_restrictions_if_so_p_44 as custom_44 FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
      LEFT JOIN civicrm_value_extra_participant_info_12 ON civicrm_value_extra_participant_info_12.entity_id = civicrm_participant.id LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id ) LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id ) LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_participant' AND
      civicrm_participant.id = civicrm_note.entity_id ) LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
      AND option_group_participant_role.id = participant_role.option_group_id ) LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id) WHERE ( contact_a.id = 1 AND civicrm_participant.is_test = 0 ) AND ( 1 ) ORDER BY participant_register_date desc LIMIT 0, 50 [nativecode=1054 ** Unknown column 'civicrm_value_extra_participant_info_12.meal_choice_38' in 'field list']

      [type] => DB_Error

      [user_info] => SELECT DISTINCT(civicrm_participant.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_event.id as event_id, civicrm_event.title as event_title, civicrm_event.start_date as event_start_date, civicrm_event.end_date as event_end_date, civicrm_participant.id as participant_id, civicrm_participant.fee_level as participant_fee_level, civicrm_participant.fee_amount as participant_fee_amount, civicrm_participant.fee_currency as participant_fee_currency, event_type.label as event_type, participant_status.label as participant_status, participant_status.id as participant_status_id, civicrm_participant.role_id as participant_role_id, civicrm_participant.register_date as participant_register_date, civicrm_participant.source as participant_source, civicrm_note.note as participant_note, civicrm_participant.is_pay_later as participant_is_pay_later, civicrm_participant.is_test as participant_is_test, civicrm_participant.registered_by_id as participant_registered_by_id, discount_name.label as participant_discount_name, civicrm_value_extra_participant_info_12.id as civicrm_value_extra_participant_info_12_id, civicrm_value_extra_participant_info_12.note_14 as custom_14, civicrm_value_extra_participant_info_12.number_of_bracelets_35 as custom_35, civicrm_value_extra_participant_info_12.number_of_tickets_36 as custom_36, civicrm_value_extra_participant_info_12.do_you_require_vegetarian_option_37 as custom_37, civicrm_value_extra_participant_info_12.meal_choice_38 as custom_38, civicrm_value_extra_participant_info_12.number_of_children_tickets_39 as custom_39, civicrm_value_extra_participant_info_12.how_many_additional_passengers_a_41 as custom_41, civicrm_value_extra_participant_info_12.do_you_need_a_ride__42 as custom_42, civicrm_value_extra_participant_info_12.any_dietary_restrictions_if_so_p_44 as custom_44 FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
      LEFT JOIN civicrm_value_extra_participant_info_12 ON civicrm_value_extra_participant_info_12.entity_id = civicrm_participant.id LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id ) LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id ) LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_participant' AND
      civicrm_participant.id = civicrm_note.entity_id ) LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
      AND option_group_participant_role.id = participant_role.option_group_id ) LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id) WHERE ( contact_a.id = 1 AND civicrm_participant.is_test = 0 ) AND ( 1 ) ORDER BY participant_register_date desc LIMIT 0, 50 [nativecode=1054 ** Unknown column 'civicrm_value_extra_participant_info_12.meal_choice_38' 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_participant.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_event.id as event_id, civicrm_event.title as event_title, civicrm_event.start_date as event_start_date, civicrm_event.end_date as event_end_date, civicrm_participant.id as participant_id, civicrm_participant.fee_level as participant_fee_level, civicrm_participant.fee_amount as participant_fee_amount, civicrm_participant.fee_currency as participant_fee_currency, event_type.label as event_type, participant_status.label as participant_status, participant_status.id as participant_status_id, civicrm_participant.role_id as participant_role_id, civicrm_participant.register_date as participant_register_date, civicrm_participant.source as participant_source, civicrm_note.note as participant_note, civicrm_participant.is_pay_later as participant_is_pay_later, civicrm_participant.is_test as participant_is_test, civicrm_participant.registered_by_id as participant_registered_by_id, discount_name.label as participant_discount_name, civicrm_value_extra_participant_info_12.id as civicrm_value_extra_participant_info_12_id, civicrm_value_extra_participant_info_12.note_14 as custom_14, civicrm_value_extra_participant_info_12.number_of_bracelets_35 as custom_35, civicrm_value_extra_participant_info_12.number_of_tickets_36 as custom_36, civicrm_value_extra_participant_info_12.do_you_require_vegetarian_option_37 as custom_37, civicrm_value_extra_participant_info_12.meal_choice_38 as custom_38, civicrm_value_extra_participant_info_12.number_of_children_tickets_39 as custom_39, civicrm_value_extra_participant_info_12.how_many_additional_passengers_a_41 as custom_41, civicrm_value_extra_participant_info_12.do_you_need_a_ride__42 as custom_42, civicrm_value_extra_participant_info_12.any_dietary_restrictions_if_so_p_44 as custom_44 FROM civicrm_contact contact_a LEFT JOIN civicrm_participant ON civicrm_participant.contact_id = contact_a.id INNER JOIN civicrm_event ON civicrm_participant.event_id = civicrm_event.id
      LEFT JOIN civicrm_value_extra_participant_info_12 ON civicrm_value_extra_participant_info_12.entity_id = civicrm_participant.id LEFT JOIN civicrm_option_group option_group_event_type ON (option_group_event_type.name = 'event_type') LEFT JOIN civicrm_option_value event_type ON (civicrm_event.event_type_id = event_type.value AND option_group_event_type.id = event_type.option_group_id ) LEFT JOIN civicrm_discount discount ON ( civicrm_participant.discount_id = discount.id ) LEFT JOIN civicrm_option_group discount_name ON ( discount_name.id = discount.option_group_id ) LEFT JOIN civicrm_note ON ( civicrm_note.entity_table = 'civicrm_participant' AND
      civicrm_participant.id = civicrm_note.entity_id ) LEFT JOIN civicrm_option_group option_group_participant_role ON (option_group_participant_role.name = 'participant_role') LEFT JOIN civicrm_option_value participant_role ON (civicrm_participant.role_id = participant_role.value
      AND option_group_participant_role.id = participant_role.option_group_id ) LEFT JOIN civicrm_participant_status_type participant_status ON (civicrm_participant.status_id = participant_status.id) WHERE ( contact_a.id = 1 AND civicrm_participant.is_test = 0 ) AND ( 1 ) ORDER BY participant_register_date desc LIMIT 0, 50 [nativecode=1054 ** Unknown column 'civicrm_value_extra_participant_info_12.meal_choice_38' in 'field list']"]
      )

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              sgladstone Sarah Gladstone
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: