From d4ef7d8b8abd34a92c70b0097c358e1e94bde0b5 Mon Sep 17 00:00:00 2001 From: Tim Otten Date: Mon, 16 Jan 2023 19:00:41 -0800 Subject: [PATCH] CRM_Queue_Queue_SqlTrait - Prefer operations using Unix epoch format --- CRM/Queue/Queue/SqlTrait.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Queue/Queue/SqlTrait.php b/CRM/Queue/Queue/SqlTrait.php index 69f5cf2206..8fc9275e51 100644 --- a/CRM/Queue/Queue/SqlTrait.php +++ b/CRM/Queue/Queue/SqlTrait.php @@ -59,12 +59,12 @@ trait CRM_Queue_Queue_SqlTrait { switch ($name) { case 'ready': return (int) CRM_Core_DAO::singleValueQuery( - 'SELECT count(*) FROM civicrm_queue_item WHERE queue_name = %1 AND (release_time is null OR release_time <= FROM_UNIXTIME(%2))', + 'SELECT count(*) FROM civicrm_queue_item WHERE queue_name = %1 AND (release_time is null OR UNIX_TIMESTAMP(release_time) <= %2)', [1 => [$this->getName(), 'String'], 2 => [CRM_Utils_Time::time(), 'Int']]); case 'blocked': return (int) CRM_Core_DAO::singleValueQuery( - 'SELECT count(*) FROM civicrm_queue_item WHERE queue_name = %1 AND release_time > FROM_UNIXTIME(%2)', + 'SELECT count(*) FROM civicrm_queue_item WHERE queue_name = %1 AND UNIX_TIMESTAMP(release_time) > %2', [1 => [$this->getName(), 'String'], 2 => [CRM_Utils_Time::time(), 'Int']]); case 'total': -- 2.25.1