X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fpages%2Faccount%2FCertificates.java;h=37869f4ddf52714cef266ab05e9c750ef6debf76;hp=33118008cfc6fc19d2a8cd06840bacc23d4844bc;hb=b0a970a60d0001260594468f3ffffbf92a19bc44;hpb=923f09449b5bf1d4684216910988812ab7a7a163

diff --git a/src/org/cacert/gigi/pages/account/Certificates.java b/src/org/cacert/gigi/pages/account/Certificates.java
index 33118008..37869f4d 100644
--- a/src/org/cacert/gigi/pages/account/Certificates.java
+++ b/src/org/cacert/gigi/pages/account/Certificates.java
@@ -120,7 +120,7 @@ public class Certificates extends Page {
         HashMap<String, Object> vars = new HashMap<String, Object>();
         User us = LoginPage.getUser(req);
         try {
-            PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `emailcerts` WHERE `memid`=?");
+            PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT `id`, `CN`, `serial`, `revoked`, `expire`, `disablelogin` FROM `certs` WHERE `memid`=?");
             ps.setInt(1, us.getId());
             ResultSet rs = ps.executeQuery();
             vars.put("mailcerts", rs);