You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Jul 20, 2022. It is now read-only.
I have run into an issue under CiviCRM 4.7.21 where the Mail Opened Report returns DB Error: no such field. The problem appears to me to be connected to line 495 in mte.php. That line adds
count(DISTINCT(civicrm_mailing_event_opened.id)) as opened_count
to the query. However in the full query for that report civicrm_mailing_event_opened.id gets assigned to civicrm_mailing_event_opened_id, so the line actually needs to read
count(DISTINCT(civicrm_mailing_event_opened_id)) as opened_count
I tested this doing the query directly on the database and it works and adjusting the mte.php code file fixes the error. However, am I missing a better fix?
The text was updated successfully, but these errors were encountered:
I have run into an issue under CiviCRM 4.7.21 where the Mail Opened Report returns DB Error: no such field. The problem appears to me to be connected to line 495 in mte.php. That line adds
count(DISTINCT(civicrm_mailing_event_opened.id)) as opened_count
to the query. However in the full query for that report civicrm_mailing_event_opened.id gets assigned to civicrm_mailing_event_opened_id, so the line actually needs to read
count(DISTINCT(civicrm_mailing_event_opened_id)) as opened_count
I tested this doing the query directly on the database and it works and adjusting the mte.php code file fixes the error. However, am I missing a better fix?
The text was updated successfully, but these errors were encountered: