From 3f547195c9617ba918c78354e88c37702c4f5008 Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Tue, 26 Sep 2023 14:08:11 +1300 Subject: [PATCH] Add upgrade script to mailing-queue-table alter --- CRM/Upgrade/Incremental/php/FiveSixtySeven.php | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/CRM/Upgrade/Incremental/php/FiveSixtySeven.php b/CRM/Upgrade/Incremental/php/FiveSixtySeven.php index 4ed4c2b2e3..0cb680c709 100644 --- a/CRM/Upgrade/Incremental/php/FiveSixtySeven.php +++ b/CRM/Upgrade/Incremental/php/FiveSixtySeven.php @@ -85,6 +85,11 @@ class CRM_Upgrade_Incremental_php_FiveSixtySeven extends CRM_Upgrade_Incremental FOREIGN KEY (`job_id`) REFERENCES `civicrm_mailing_job`(`id`) ON DELETE SET NULL ', [], FALSE, FALSE, FALSE, FALSE); + CRM_Core_DAO::executeQuery(' +UPDATE civicrm_mailing_event_queue q +INNER JOIN civicrm_mailing_job job ON job.id = q.job_id +SET q.mailing_id = job.mailing_id, q.is_test=job.is_test +WHERE q.mailing_id IS NULL'); } catch (\Civi\Core\Exception\DBQueryException $e) { throw new CRM_Core_Exception( -- 2.25.1