From d2e1ba6b9ab98f8bceea9c6349d7f6cb17bd2ce8 Mon Sep 17 00:00:00 2001 From: Rich Lott / Artful Robot Date: Tue, 5 Sep 2023 15:50:54 +0100 Subject: [PATCH] Fix upgrader SQL (5.60) that updates civicrm_job_log This upgrader has broken SQL, joining civicrm_job.id = civicrm_job_log.id causing crashes on upgrades. After: fixed the SQL --- CRM/Upgrade/Incremental/php/FiveSixty.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/php/FiveSixty.php b/CRM/Upgrade/Incremental/php/FiveSixty.php index 6b9a4dedea..00ef006fcc 100644 --- a/CRM/Upgrade/Incremental/php/FiveSixty.php +++ b/CRM/Upgrade/Incremental/php/FiveSixty.php @@ -56,7 +56,7 @@ class CRM_Upgrade_Incremental_php_FiveSixty extends CRM_Upgrade_Incremental_Base CRM_Core_DAO::executeQuery($commentQuery); // Set job_id = NULL for any that don't have matching jobs (ie. job was deleted). - $updateQuery = 'UPDATE civicrm_job_log job_log LEFT JOIN civicrm_job job ON job.id = job_log.id SET job_id = NULL WHERE job.id IS NULL'; + $updateQuery = 'UPDATE civicrm_job_log job_log LEFT JOIN civicrm_job job ON job.id = job_log.job_id SET job_id = NULL WHERE job.id IS NULL'; CRM_Core_DAO::executeQuery($updateQuery); // Add the foreign key -- 2.25.1