From: Felix Dörre <felix@dogcraft.de>
Date: Sat, 3 Sep 2016 14:12:57 +0000 (+0200)
Subject: fix: SQL query was wrong
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=e2877d04650363e6305da3293d5ea038d8355d46

fix: SQL query was wrong

Change-Id: I3637c59944fdd5fc2e61a991b51781b3b9d746db
---

diff --git a/src/org/cacert/gigi/dbObjects/CACertificate.java b/src/org/cacert/gigi/dbObjects/CACertificate.java
index 3e8af822..bc96a5a5 100644
--- a/src/org/cacert/gigi/dbObjects/CACertificate.java
+++ b/src/org/cacert/gigi/dbObjects/CACertificate.java
@@ -142,7 +142,7 @@ public class CACertificate implements IdCachable {
                             id = q2.lastInsertId();
                         }
                         if (self) {
-                            try (GigiPreparedStatement q3 = new GigiPreparedStatement("UPDATE `cacerts` SET `parentRoot`=?, `id`=?")) {
+                            try (GigiPreparedStatement q3 = new GigiPreparedStatement("UPDATE `cacerts` SET `parentRoot`=? WHERE `id`=?")) {
                                 q3.setInt(1, id);
                                 q3.setInt(2, id);
                                 q3.execute();