From d762ad8d5eab470027fb1ac4c2f23b1e266642e6 Mon Sep 17 00:00:00 2001 From: jitendrapurohit Date: Sat, 18 Feb 2023 11:43:59 +0530 Subject: [PATCH] Fix DB syntax error on Parse address sched job --- CRM/Utils/Address/BatchUpdate.php | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/CRM/Utils/Address/BatchUpdate.php b/CRM/Utils/Address/BatchUpdate.php index d26d35941b..e00460b990 100644 --- a/CRM/Utils/Address/BatchUpdate.php +++ b/CRM/Utils/Address/BatchUpdate.php @@ -134,7 +134,10 @@ class CRM_Utils_Address_BatchUpdate { $clause[] = '( a.country_id is not null )'; } - $whereClause = implode(' AND ', $clause); + $whereClause = ''; + if (!empty($clause)) { + $whereClause = 'WHERE ' . implode(' AND ', $clause); + } $query = " SELECT c.id, @@ -152,7 +155,7 @@ class CRM_Utils_Address_BatchUpdate { ON a.country_id = o.id LEFT JOIN civicrm_state_province s ON a.state_province_id = s.id - WHERE {$whereClause} + {$whereClause} ORDER BY a.id "; -- 2.25.1