Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Minor
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7
-
Fix Version/s: 4.7.16
-
Component/s: CiviReport
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Contributed Code
Description
I have recently added some code to fix an error in the Activity Summary report. This error was caused by a potential difference in character set and collation between the CiviCRM tables and the temporary tables created by the report.
See: https://issues.civicrm.org/jira/browse/CRM-19503
It is likely that other reports (and possibly other parts of CiviCRM) will suffer from the same problem.
It should be fairly straightforward to fix this by searching for "CREATE TEMPORARY TABLE" and adding
$this->_databaseAttributes
to the SQL statement - as per my pull request: https://github.com/civicrm/civicrm-core/pull/9264
