From: Felix Dörre <felix@dogcraft.de>
Date: Thu, 16 Jun 2016 15:54:29 +0000 (+0200)
Subject: fix: problem with updating organisations.
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=ac2b3b4385c517269df9e52b2d09f25327607283

fix: problem with updating organisations.

Change-Id: Iac0ab134caf970dd2a7b1423f357aa70292500eb
---

diff --git a/src/org/cacert/gigi/dbObjects/Organisation.java b/src/org/cacert/gigi/dbObjects/Organisation.java
index f3bd822b..36119424 100644
--- a/src/org/cacert/gigi/dbObjects/Organisation.java
+++ b/src/org/cacert/gigi/dbObjects/Organisation.java
@@ -189,13 +189,14 @@ public class Organisation extends CertificateOwner {
                 cert.revoke();
             }
         }
-        try (GigiPreparedStatement ps = new GigiPreparedStatement("UPDATE `organisations` SET `name`=?, `state`=?, `province`=?, `city`=?, `contactEmail`=?")) {
+        try (GigiPreparedStatement ps = new GigiPreparedStatement("UPDATE `organisations` SET `name`=?, `state`=?, `province`=?, `city`=?, `contactEmail`=? WHERE `id`=?")) {
             ps.setString(1, o);
             ps.setString(2, c);
             ps.setString(3, st);
             ps.setString(4, l);
             ps.setString(5, mail);
-            ps.execute();
+            ps.setInt(6, getId());
+            ps.executeUpdate();
         }
         email = mail;
         name = o;