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 3e8af82274704ffe728f9463c8d18004b80c1fe1..bc96a5a5f3db89b0188e2d9075ac068c2b77fa2d 100644 (file)
--- 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();