From 2846a105719bc82f5a63fbe39e9d271b53577ded Mon Sep 17 00:00:00 2001 From: =?utf8?q?Felix=20D=C3=B6rre?= Date: Thu, 18 Aug 2016 19:53:25 +0200 Subject: [PATCH] fix: allow searchUserIdByDomain to find re-added domains Change-Id: I23e433c32161aac2548855b25b3eda811740b415 --- src/org/cacert/gigi/dbObjects/Domain.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/org/cacert/gigi/dbObjects/Domain.java b/src/org/cacert/gigi/dbObjects/Domain.java index d4ffd8e2..f4a828c3 100644 --- a/src/org/cacert/gigi/dbObjects/Domain.java +++ b/src/org/cacert/gigi/dbObjects/Domain.java @@ -174,7 +174,7 @@ public class Domain implements IdCachable, Verifyable { } public static Domain searchUserIdByDomain(String domain) { - try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT `id` FROM `domains` WHERE `domain` = ?")) { + try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT `id` FROM `domains` WHERE `domain` = ? AND `deleted` IS NULL")) { ps.setString(1, domain); GigiResultSet res = ps.executeQuery(); if (res.next()) { -- 2.39.2