From 11bbb5d05db46bc8a11d2aa3aa05f126c24cd10c Mon Sep 17 00:00:00 2001 From: Mathieu Lutfy Date: Tue, 28 Nov 2017 22:23:27 -0500 Subject: [PATCH] CRM-21480 FourSeven/updateContributionInvoiceNumber: fix for MariaDB 10.2. --- CRM/Upgrade/Incremental/php/FourSeven.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Upgrade/Incremental/php/FourSeven.php b/CRM/Upgrade/Incremental/php/FourSeven.php index 8ed19c988b..63e9dc6334 100644 --- a/CRM/Upgrade/Incremental/php/FourSeven.php +++ b/CRM/Upgrade/Incremental/php/FourSeven.php @@ -627,7 +627,7 @@ class CRM_Upgrade_Incremental_php_FourSeven extends CRM_Upgrade_Incremental_Base public static function updateContributionInvoiceNumber(CRM_Queue_TaskContext $ctx, $startID, $endID, $invoicePrefix) { CRM_Core_DAO::executeQuery(" UPDATE `civicrm_contribution` SET `invoice_number` = CONCAT(%1, `id`) - WHERE `id` BETWEEN (%2 AND %3) AND `invoice_number` IS NOT NULL ", + WHERE `id` >= %2 AND `id` <= %3 AND `invoice_number` IS NOT NULL", array( 1 => array($invoicePrefix, 'String'), 2 => array($startID, 'Integer'), -- 2.25.1