Skip to content
GitLab
Projects Groups Topics Snippets
  • /
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • CiviCRM Core CiviCRM Core
  • Project information
    • Project information
    • Activity
    • Labels
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Graph
    • Compare revisions
  • Issues 1.1k
    • Issues 1.1k
    • List
    • Boards
    • Service Desk
    • Milestones
  • Deployments
    • Deployments
    • Releases
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Commits
  • Issue Boards
Collapse sidebar
  • DevelopmentDevelopment
  • CiviCRM CoreCiviCRM Core
  • Issues
  • #1095
Closed
Open
Issue created Jul 02, 2019 by Pradeep Nayak@pradeepDeveloper

Activity Details report: Sorting by the “Source Email” field: DB Error: no such field.

Steps to replicate:

  1. Click "Reports" > "Contact Reports"
  2. Open the "Activity Details" report
  3. Open the "Sorting" tab
  4. Set following sorting options :
  • Column: Source Email
  • Order: Ascending
  • Section Header / Group By: check box selected
  1. Click "Refresh Results"

Actual result: DB Error: no such field.

Expected result: The user can group the “Activity Details” report by the “Source Email” field

Query:

Jul 02 11:00:54  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']
    [type] => DB_Error
    [user_info] => SELECT ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' 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 ifnull(civicrm_email_source_contact_email, '') as civicrm_email_source_contact_email, ifnull(civicrm_contact_contact_assignee, '') as civicrm_contact_contact_assignee, ifnull(civicrm_contact_contact_target, '') as civicrm_contact_contact_target, ifnull(civicrm_contact_contact_source_id, '') as civicrm_contact_contact_source_id, ifnull(civicrm_contact_contact_assignee_id, '') as civicrm_contact_contact_assignee_id, ifnull(civicrm_contact_contact_target_id, '') as civicrm_contact_contact_target_id, ifnull(civicrm_activity_id, '') as civicrm_activity_id, ifnull(civicrm_activity_source_record_id, '') as civicrm_activity_source_record_id, ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_activity_type_id, ifnull(civicrm_activity_activity_subject, '') as civicrm_activity_activity_subject, ifnull(civicrm_activity_activity_date_time, '') as civicrm_activity_activity_date_time, ifnull(civicrm_activity_status_id, '') as civicrm_activity_status_id , count(DISTINCT civicrm_activity_id) as ct from civicrm_tmp_e_dflt_8ce364900bed80d360a3cf2827858c9a group by civicrm_email_source_contact_email [nativecode=1054 ** Unknown column 'civicrm_email_source_contact_email' in 'field list']"]
)
Edited Jul 02, 2019 by Pradeep Nayak
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information
Assignee
Assign to
Time tracking