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

activities report fails to add contacts to group - fatal error

    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

      {main}

        Attachments

          Activity

            People

            • Assignee:
              monish.deb Monish Deb
              Reporter:
              jamie Jamie McClelland
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: