From 691de38ac2ca6c54b37feb50e1332bab6268773f Mon Sep 17 00:00:00 2001
From: Ivan Kohler <ivan@freeside.biz>
Date: Wed, 7 Sep 2022 16:50:33 -0700
Subject: [PATCH] fix password_history upgrade on new DBs

---
 FS/FS/password_history.pm | 1 +
 1 file changed, 1 insertion(+)

diff --git a/FS/FS/password_history.pm b/FS/FS/password_history.pm
index 13d16010d..1915a2185 100644
--- a/FS/FS/password_history.pm
+++ b/FS/FS/password_history.pm
@@ -173,6 +173,7 @@ sub _upgrade_schema {
     push @where, "
       ( $fk IS NOT NULL AND NOT EXISTS(SELECT 1 FROM $table WHERE $table.$key = $fk) )";
   }
+  return '' unless @where;
   my @recs = qsearch({
       'table'     => 'password_history',
       'extra_sql' => ' WHERE ' . join(' AND ', @where),
-- 
2.11.0