We added the field but until we are on 5.67 new rows probably won't be populated (unless we take some other action)
This should run clean (currently 3327 rows)
select count(*) FROM civicrm_mailing_event_queue WHERE mailing_id IS NULL LIMIT 50;
If we get to this soonish can just do a single query - ie
UPDATE civicrm_mailing_event_queue SET mailing_id = 1 WHERE job_id = 1 AND mailing_id IS NULL
| Subject | Repo | Branch | Lines +/- | |
|---|---|---|---|---|
| Clean up mailing_event_queue entries created during maintenance window | wikimedia/fundraising/crm | master | +27 -0 |
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | None | T337579 FR-Tech FY2324Q2 maintenance window | |||
| Resolved | Eileenmcnaughton | T350208 CiviCRM point release | |||
| Resolved | Eileenmcnaughton | T350209 Fix any rows that do not have the new mailing_id field populated |
Change 972072 had a related patch set uploaded (by Eileen; author: Eileen):
[wikimedia/fundraising/crm@master] Clean up mailing_event_queue entries created during maintenance window
Change 972072 merged by jenkins-bot:
[wikimedia/fundraising/crm@master] Clean up mailing_event_queue entries created during maintenance window