Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 4.7.22
-
Fix Version/s: 4.7.23
-
Component/s: None
-
Labels:
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:User and Admin Doc
-
Funding Source:Contributed Code
-
Verified?:No
Description
There is a DB syntax error on the Mailing Opened Report when pie chart display is selected.
Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') as civicrm_mailing_opened_count FROM civicrm_contact contact_civirepor' at line 1, 1064
Offending line: COUNT(.id) as civicrm_mailing_opened_count
I will be submitting a patch for this.