Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.5.4
-
Fix Version/s: 4.6
-
Component/s: CiviReport
-
Labels:None
-
Documentation Required?:None
Description
Two issues with the Activity Report:
1. Sort by Activity Type does not work in 4.6 (it seems to be ignored)
2. Both 4.5 and 4.6 throw a fatal if you check 'Section Header' in the Order By Columns section for sort by Activity Type (and maybe for any sort choice)
------fatal when section header is checked —
#6 /Users/dgg/git/crm_v4.5/packages/DB/mysql.php(899): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_contact_contact_assignee' in 'field list'")
#7 /Users/dgg/git/crm_v4.5/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /Users/dgg/git/crm_v4.5/packages/DB/common.php(1216): DB_mysql->simpleQuery("select ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_acti...")
#9 /Users/dgg/git/crm_v4.5/packages/DB/DataObject.php(2442): DB_common->query("select ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_acti...")
#10 /Users/dgg/git/crm_v4.5/packages/DB/DataObject.php(1634): DB_DataObject->_query("select ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_acti...")
#11 /Users/dgg/git/crm_v4.5/CRM/Core/DAO.php(325): DB_DataObject->query("select ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_acti...")
#12 /Users/dgg/git/crm_v4.5/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("select ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_acti...", TRUE)
#13 /Users/dgg/git/crm_v4.5/CRM/Report/Form.php(2503): CRM_Core_DAO::executeQuery("select ifnull(civicrm_activity_activity_type_id, '') as civicrm_activity_acti...")