Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.4.3
-
Fix Version/s: 4.4.4
-
Component/s: CiviReport
-
Labels:None
Description
Activities report throws fatal error (Unknown column 'civicrm_contact_contact_source' in 'field list) when trying to 'add contacts to group'.
My recommendation would be to stick with the 4.3 behavior which is to add the activity TARGET contacts to the group.
— original post ----
Thanks to the great work on CRM-13738 we can now easily choose to display any or all of the source, target or assigned contacts to an activity. However, this seems to be the source of the group add bug - which of the three contacts to add?
---- backtrace when using 'add to group ' ---------
#0 /Users/dgg/git/crm_v4.4/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /Users/dgg/git/crm_v4.4/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /Users/dgg/git/crm_v4.4/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...")
#4 /Users/dgg/git/crm_v4.4/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...")
#5 /Users/dgg/git/crm_v4.4/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...", "DB_Error", TRUE)
#6 /Users/dgg/git/crm_v4.4/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_contact_contact_source' in 'field list'")
#7 /Users/dgg/git/crm_v4.4/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /Users/dgg/git/crm_v4.4/packages/DB/common.php(1216): DB_mysql->simpleQuery("SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...")
#9 /Users/dgg/git/crm_v4.4/packages/DB/DataObject.php(2421): DB_common->query("SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...")
#10 /Users/dgg/git/crm_v4.4/packages/DB/DataObject.php(1613): DB_DataObject->_query("SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...")
#11 /Users/dgg/git/crm_v4.4/CRM/Core/DAO.php(160): DB_DataObject->query("SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...")
#12 /Users/dgg/git/crm_v4.4/CRM/Core/DAO.php(907): CRM_Core_DAO->query("SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...", TRUE)
#13 /Users/dgg/git/crm_v4.4/CRM/Report/Form.php(3446): CRM_Core_DAO::executeQuery("SELECT DISTINCT civicrm_contact_source.id AS addtogroup_contact_id, GROUP_CON...")
#14 /Users/dgg/git/crm_v4.4/CRM/Report/Form.php(2579): CRM_Report_Form->add2group("1")
#15 /Users/dgg/git/crm_v4.4/CRM/Report/Form/Activity.php(624): CRM_Report_Form->endPostProcess((Array:2))
#16 /Users/dgg/git/crm_v4.4/CRM/Core/Form.php(261): CRM_Report_Form_Activity->postProcess()
#17 /Users/dgg/git/crm_v4.4/CRM/Core/QuickForm/Action/Submit.php(73): CRM_Core_Form->mainProcess()
#18 /Users/dgg/git/crm_v4.4/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Activity), "submit")
#19 /Users/dgg/git/crm_v4.4/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Activity), "submit")
#20 /Users/dgg/git/crm_v4.4/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("submit")
#21 /Users/dgg/git/crm_v4.4/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#22 /Users/dgg/git/crm_v4.4/CRM/Report/Page/Instance.php(103): CRM_Utils_Wrapper->run("CRM_Report_Form_Activity", NULL, NULL)
#23 /Users/dgg/git/crm_v4.4/CRM/Core/Invoke.php(323): CRM_Report_Page_Instance->run((Array:4), NULL)
#24 /Users/dgg/git/crm_v4.4/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:14))
#25 /Users/dgg/git/crm_v4.4/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#26 /Users/dgg/git/crm_v4.4/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:4))
#27 [internal function](): civicrm_invoke("report", "instance", "3")
#28 /Users/dgg/htdocs/drupal7/includes/menu.inc(517): call_user_func_array("civicrm_invoke", (Array:3))
#29 /Users/dgg/htdocs/drupal7/index.php(21): menu_execute_active_handler()
#30