CiviCRM Community Forums (archive)

I upgraded a copy of our 4.2.7 to 4.4.1, which seemed to work smoothly.

However, the Activity Report fails if any of the filters for contacts is used. This includes Source, Assignee and Target Contacts Names as well as the "Limit to Current User".

I don't get this on the demo-installation, so I'm assuming this is something in our installation or the upgrade. We're running Joomla 2.5.14.

This is the backtrace:

backTrace

#0 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/Error.php(149): CRM_Core_Error::backtrace()
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/DB.php(969): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...")
#4 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...")
#5 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...", "DB_Error", TRUE)
#6 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(898): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'civicrm_contact_source.sort_name' in 'where clause'")
#7 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/DB/mysql.php(327): DB_mysql->mysqlRaiseError()
#8 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...")
#9 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(2421): DB_common->query("CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...")
#10 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/DB/DataObject.php(1613): DB_DataObject->_query("CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...")
#11 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(158): DB_DataObject->query("CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...")
#12 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/DAO.php(905): CRM_Core_DAO->query("CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...", TRUE)
#13 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Report/Form/Activity.php(533): CRM_Core_DAO::executeQuery("CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COL...")
#14 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/Form.php(261): CRM_Report_Form_Activity->postProcess()
#15 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/QuickForm/Action/Submit.php(73): CRM_Core_Form->mainProcess()
#16 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Submit->perform(Object(CRM_Report_Form_Activity), "submit")
#17 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Report_Form_Activity), "submit")
#18 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/Controller.php(345): HTML_QuickForm_Page->handle("submit")
#19 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Utils/Wrapper.php(117): CRM_Core_Controller->run()
#20 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Report/Page/Instance.php(103): CRM_Utils_Wrapper->run("CRM_Report_Form_Activity", NULL, NULL)
#21 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(323): CRM_Report_Page_Instance->run((Array:4), NULL)
#22 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(72): CRM_Core_Invoke::runItem((Array:14))
#23 /Library/WebServer/Documents/events/administrator/components/com_civicrm/civicrm/CRM/Core/Invoke.php(52): CRM_Core_Invoke::_invoke((Array:4))
#24 /Library/WebServer/Documents/events/administrator/components/com_civicrm/admin.civicrm.php(116): CRM_Core_Invoke::invoke((Array:4))
#25 /Library/WebServer/Documents/events/administrator/components/com_civicrm/admin.civicrm.php(40): civicrm_invoke()
#26 /Library/WebServer/Documents/events/libraries/joomla/application/component/helper.php(383): require_once("/Library/WebServer/Documents/events/administrator/components/com_civicrm/admi...")
#27 /Library/WebServer/Documents/events/libraries/joomla/application/component/helper.php(351): JComponentHelper::executeComponent("/Library/WebServer/Documents/events/administrator/components/com_civicrm/admi...")
#28 /Library/WebServer/Documents/events/administrator/includes/application.php(153): JComponentHelper::renderComponent("com_civicrm")
#29 /Library/WebServer/Documents/events/administrator/index.php(46): JAdministrator->dispatch()
#30 {main}
Sorry but we are not able to provide this at the moment.
DB Error: no such field
Totalt antal rader
Databasfelkod: Unknown column 'civicrm_contact_source.sort_name' in 'where clause', 1054
Ytterligare detaljer:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -19
    [message] => DB Error: no such field
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COLLATE utf8_unicode_ci AS
SELECT civicrm_contact_target.sort_name as civicrm_contact_contact_target, civicrm_contact_target.id as civicrm_contact_contact_target_id, activity_civireport.id as civicrm_activity_id, activity_civireport.source_record_id as civicrm_activity_source_record_id, activity_civireport.activity_type_id as civicrm_activity_activity_type_id, activity_civireport.subject as civicrm_activity_activity_subject, activity_civireport.activity_date_time as civicrm_activity_activity_date_time, activity_civireport.status_id as civicrm_activity_status_id 
        FROM civicrm_activity activity_civireport
             INNER JOIN civicrm_activity_contact  activity_contact_civireport
                    ON activity_civireport.id = activity_contact_civireport.activity_id AND
                       activity_contact_civireport.record_type_id = 3
             INNER JOIN civicrm_contact civicrm_contact_target
                    ON activity_contact_civireport.contact_id = civicrm_contact_target.id
             
                 LEFT JOIN civicrm_address address_civireport
                           ON (civicrm_contact_target.id =
                               address_civireport.contact_id) AND
                               address_civireport.is_primary = 1
  WHERE activity_civireport.is_test = 0 AND
                                activity_civireport.is_deleted = 0 AND
                                activity_civireport.is_current_revision = 1 AND ( civicrm_contact_source.sort_name = 'thomas' ) AND ( activity_civireport.subject LIKE '%thomas%' ) AND ( activity_civireport.activity_type_id IN (19) ) AND ( activity_civireport.status_id IN (1) ) AND ( address_civireport.country_id IN (1001) )  [nativecode=1054 ** Unknown column 'civicrm_contact_source.sort_name' in 'where clause']
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COLLATE utf8_unicode_ci AS
SELECT civicrm_contact_target.sort_name as civicrm_contact_contact_target, civicrm_contact_target.id as civicrm_contact_contact_target_id, activity_civireport.id as civicrm_activity_id, activity_civireport.source_record_id as civicrm_activity_source_record_id, activity_civireport.activity_type_id as civicrm_activity_activity_type_id, activity_civireport.subject as civicrm_activity_activity_subject, activity_civireport.activity_date_time as civicrm_activity_activity_date_time, activity_civireport.status_id as civicrm_activity_status_id 
        FROM civicrm_activity activity_civireport
             INNER JOIN civicrm_activity_contact  activity_contact_civireport
                    ON activity_civireport.id = activity_contact_civireport.activity_id AND
                       activity_contact_civireport.record_type_id = 3
             INNER JOIN civicrm_contact civicrm_contact_target
                    ON activity_contact_civireport.contact_id = civicrm_contact_target.id
             
                 LEFT JOIN civicrm_address address_civireport
                           ON (civicrm_contact_target.id =
                               address_civireport.contact_id) AND
                               address_civireport.is_primary = 1
  WHERE activity_civireport.is_test = 0 AND
                                activity_civireport.is_deleted = 0 AND
                                activity_civireport.is_current_revision = 1 AND ( civicrm_contact_source.sort_name = 'thomas' ) AND ( activity_civireport.subject LIKE '%thomas%' ) AND ( activity_civireport.activity_type_id IN (19) ) AND ( activity_civireport.status_id IN (1) ) AND ( address_civireport.country_id IN (1001) )  [nativecode=1054 ** Unknown column 'civicrm_contact_source.sort_name' in 'where clause']
    [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE civireport_activity_temp_target CHARACTER SET utf8 COLLATE utf8_unicode_ci AS
SELECT civicrm_contact_target.sort_name as civicrm_contact_contact_target, civicrm_contact_target.id as civicrm_contact_contact_target_id, activity_civireport.id as civicrm_activity_id, activity_civireport.source_record_id as civicrm_activity_source_record_id, activity_civireport.activity_type_id as civicrm_activity_activity_type_id, activity_civireport.subject as civicrm_activity_activity_subject, activity_civireport.activity_date_time as civicrm_activity_activity_date_time, activity_civireport.status_id as civicrm_activity_status_id 
        FROM civicrm_activity activity_civireport
             INNER JOIN civicrm_activity_contact  activity_contact_civireport
                    ON activity_civireport.id = activity_contact_civireport.activity_id AND
                       activity_contact_civireport.record_type_id = 3
             INNER JOIN civicrm_contact civicrm_contact_target
                    ON activity_contact_civireport.contact_id = civicrm_contact_target.id
             
                 LEFT JOIN civicrm_address address_civireport
                           ON (civicrm_contact_target.id =
                               address_civireport.contact_id) AND
                               address_civireport.is_primary = 1
  WHERE activity_civireport.is_test = 0 AND
                                activity_civireport.is_deleted = 0 AND
                                activity_civireport.is_current_revision = 1 AND ( civicrm_contact_source.sort_name = 'thomas' ) AND ( activity_civireport.subject LIKE '%thomas%' ) AND ( activity_civireport.activity_type_id IN (19) ) AND ( activity_civireport.status_id IN (1) ) AND ( address_civireport.country_id IN (1001) )  [nativecode=1054 ** Unknown column 'civicrm_contact_source.sort_name' in 'where clause']"]
)
Återvänd till startsidan.


Done. (http://issues.civicrm.org/jira/browse/CRM-13738)

(And thanks for checking the demo, I must have missed trying with filters...)