I noticed this mailing is missing & separately I noticed that a mailing with emjois in it the title won't save - creating this to track & address
SELECT count(*), m.id FROM civicrm_mailing_provider_data mp LEFT JOIN civicrm_mailing m ON m.hash = mp.mailing_identifier WHERE mp.mailing_identifier = 'sp60563358'; +----------+------+ | count(*) | id | +----------+------+ | 86186 | NULL |
| Project | Branch | Lines +/- | Subject | |
|---|---|---|---|---|
| wikimedia/fundraising/crm | master | +31 -6 | Strip emojis from imported mailings to prevent fatal errors. |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Eileenmcnaughton | T236855 Fix missing email recipient data | |||
| Resolved | Eileenmcnaughton | T238620 Figure out why sp60563358 is not imported - Emjois? |
Change 553234 had a related patch set uploaded (by Eileen; owner: Eileen):
[wikimedia/fundraising/crm@master] Strip emojis from imported mailings to prevent fatal errors.
Change 553234 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Strip emojis from imported mailings to prevent fatal errors.
@CCogdill_WMF I noticed when digging into other stuff that not all mailings were in CiviCRM - the one I was digging into turned out to be emjoi related & is hopefully sorted but at the time I noticed & logged this one too.
I can see recipients have taken actions related to mailing 60563358 (opens etc) but I can't seem to retrieve it and the report doesn't show it as sent - https://engage4.silverpop.com/reportsSummary.do?mailingId=60563358
However, I see the word 'control' in the mailing name (2019_France(FR)_French(fr)_Track1_Email2_Control (3)) - perhaps this is just how it is for control mailings? Any insight? I'm thinking I might close this as 'nothing to see here'
Hmm, that mailing is a remind me later mailing. Those are special cases
because they're sent as automated programs on timers based on user
behavior, rather than as bulk sends. We use different reports to get the
performance data for automated programs. Maybe that's why you can't see the
sent numbers?
@CCogdill_WMF I guess so - even the text doesn't get downloaded when I try - not sure how much it matters