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

Survey Report returns Unknown Field if you include Interviewer Name

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Duplicate
    • Affects Version/s: 4.4.5
    • Fix Version/s: None
    • Component/s: CiviCampaign
    • Labels:
      None

      Description

      The full debug info is:

      [debug_info] => SELECT SQL_CALC_FOUND_ROWS civicrm_activity_assignment.assignee_contact_id as civicrm_activity_contact_contact_id,
      contact_civireport.id as civicrm_contact_id,
      contact_civireport.sort_name as civicrm_contact_sort_name,
      survey_activity_civireport.result as civicrm_activity_result FROM civicrm_contact contact_civireport INNER JOIN civicrm_activity_contact civicrm_activity_target ON
      ( contact_civireport.id = civicrm_activity_target.contact_id AND civicrm_activity_target.record_type_id = 3)
      INNER JOIN civicrm_activity survey_activity_civireport ON
      ( survey_activity_civireport.id = civicrm_activity_target.activity_id )
      INNER JOIN civicrm_activity_contact civicrm_activity_assignment ON
      ( survey_activity_civireport.id = civicrm_activity_assignment.activity_id AND civicrm_activity_assignment.record_type_id = 1 )
      LEFT JOIN civicrm_address address_civireport ON
      contact_civireport.id = address_civireport.contact_id AND address_civireport.is_primary = 1
      WHERE ( survey_activity_civireport.activity_type_id IN ( 28 , 29 , 30 , 31 ) ) AND ( survey_activity_civireport.is_deleted = 0 ) AND contact_civireport.is_deleted = 0 LIMIT 0, 50 [native
      code=1054 ** Unknown column 'civicrm_activity_assignment.assignee_contact_id' in 'field list']
      [type] => DB_Error
      [user_info] => SELECT SQL_CALC_FOUND_ROWS civicrm_activity_assignment.assignee_contact_id as civicrm_activity_contact_contact_id,
      contact_civireport.id as civicrm_contact_id,
      contact_civireport.sort_name as civicrm_contact_sort_name,
      survey_activity_civireport.result as civicrm_activity_result FROM civicrm_contact contact_civireport INNER JOIN civicrm_activity_contact civicrm_activity_target ON
      ( contact_civireport.id = civicrm_activity_target.contact_id AND civicrm_activity_target.record_type_id = 3)
      INNER JOIN civicrm_activity survey_activity_civireport ON
      ( survey_activity_civireport.id = civicrm_activity_target.activity_id )
      INNER JOIN civicrm_activity_contact civicrm_activity_assignment ON
      ( survey_activity_civireport.id = civicrm_activity_assignment.activity_id AND civicrm_activity_assignment.record_type_id = 1 )
      LEFT JOIN civicrm_address address_civireport ON
      contact_civireport.id = address_civireport.contact_id AND address_civireport.is_primary = 1
      WHERE ( survey_activity_civireport.activity_type_id IN ( 28 , 29 , 30 , 31 ) ) AND ( survey_activity_civireport.is_deleted = 0 ) AND contact_civireport.is_deleted = 0 LIMIT 0, 50 [native
      code=1054 ** Unknown column 'civicrm_activity_assignment.assignee_contact_id' 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 SQL_CALC_FOUND_ROWS civicrm_activity_assignment.as
      signee_contact_id as civicrm_activity_contact_contact_id,
      contact_civireport.id as civicrm_contact_id,
      contact_civireport.sort_name as civicrm_contact_sort_name,
      survey_activity_civireport.result as civicrm_activity_result FROM civicrm_contact contact_civireport INNER JOIN civicrm_activity_contact civicrm_activity_target ON
      ( contact_civireport.id = civicrm_activity_target.contact_id AND civicrm_activity_target.record_type_id = 3)
      INNER JOIN civicrm_activity survey_activity_civireport ON
      ( survey_activity_civireport.id = civicrm_activity_target.activity_id )
      INNER JOIN civicrm_activity_contact civicrm_activity_assignment ON
      ( survey_activity_civireport.id = civicrm_activity_assignment.activity_id AND civicrm_activity_assignment.record_type_id = 1 )
      LEFT JOIN civicrm_address address_civireport ON
      contact_civireport.id = address_civireport.contact_id AND address_civireport.is_primary = 1
      WHERE ( survey_activity_civireport.activity_type_id IN ( 28 , 29 , 30 , 31 ) ) AND ( survey_activity_civireport.is_deleted = 0 ) AND contact_civireport.is_deleted = 0 LIMIT 0, 50 [native
      code=1054 ** Unknown column 'civicrm_activity_assignment.assignee_contact_id' in 'field list']"]

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jamie Jamie McClelland
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: