Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.4.3, 4.4.4
-
Fix Version/s: 4.5
-
Component/s: Core CiviCRM
-
Labels:None
Description
While logging is enabled, changed activities won't be loaded in the change-log-tab of a contact, if they has been added by this contact.
The SQL-query to load those activities is build as 'log_civicrm_activity_for_source'-query in the code.
The FROM-Clause of that query seems to be wrong.
I think it should be:
"FROM `civicrm`.log_civicrm_activity entity_log_civireport"
instead of
"FROM `civicrm`.log_civicrm_activity_contact entity_log_civireport".
On a big database this query lasts up to 3 minutes, which makes working with the change-log-tab of contacts impossible at all.
I've added a patch.