From f0733867ad8bc9310ad9d709c327008170cd0d59 Mon Sep 17 00:00:00 2001 From: Rich Lott / Artful Robot Date: Tue, 8 Oct 2019 06:53:05 +0100 Subject: [PATCH] Fix queue code to use CiviCRM's version of what the time is, instead of server's. --- CRM/Queue/Queue/Sql.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/CRM/Queue/Queue/Sql.php b/CRM/Queue/Queue/Sql.php index 90bad01cbd..28f13506de 100644 --- a/CRM/Queue/Queue/Sql.php +++ b/CRM/Queue/Queue/Sql.php @@ -137,10 +137,11 @@ class CRM_Queue_Queue_Sql extends CRM_Queue_Queue { ORDER BY weight ASC, id ASC LIMIT 1 ) first_in_queue - WHERE release_time IS NULL OR release_time < NOW() + WHERE release_time IS NULL OR release_time < %2 "; $params = [ 1 => [$this->getName(), 'String'], + 2 => [CRM_Utils_Time::getTime(), 'Timestamp'], ]; $dao = CRM_Core_DAO::executeQuery($sql, $params, TRUE, 'CRM_Queue_DAO_QueueItem'); if (is_a($dao, 'DB_Error')) { -- 2.25.1