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']"]