From 2eae29a94017197946f0c216e03367247c6e36be Mon Sep 17 00:00:00 2001
From: Marcus Eggenberger <egs@quassel-irc.org>
Date: Mon, 29 Dec 2008 21:24:56 +0100
Subject: [PATCH] changes to identities are now saved again properly

---
 src/core/SQL/SQLite/13/delete_nicks.sql    | 2 +-
 src/core/SQL/SQLite/13/update_identity.sql | 2 +-
 src/core/sqlitestorage.cpp                 | 3 +++
 3 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/src/core/SQL/SQLite/13/delete_nicks.sql b/src/core/SQL/SQLite/13/delete_nicks.sql
index 8018d631..8aac5997 100644
--- a/src/core/SQL/SQLite/13/delete_nicks.sql
+++ b/src/core/SQL/SQLite/13/delete_nicks.sql
@@ -1,2 +1,2 @@
 DELETE FROM identity_nick
-WHERE userid = :userid
+WHERE identityid = :identityid;
diff --git a/src/core/SQL/SQLite/13/update_identity.sql b/src/core/SQL/SQLite/13/update_identity.sql
index 1087e595..c25a708c 100644
--- a/src/core/SQL/SQLite/13/update_identity.sql
+++ b/src/core/SQL/SQLite/13/update_identity.sql
@@ -1,6 +1,6 @@
 UPDATE identity
 SET    identityname = :identityname,
-       relname = :realname,
+       realname = :realname,
        awaynick = :awaynick,
        awaynickenabled = :awaynickenabled,
        awayreason = :awayreason,
diff --git a/src/core/sqlitestorage.cpp b/src/core/sqlitestorage.cpp
index 718dc59d..2876d5c6 100644
--- a/src/core/sqlitestorage.cpp
+++ b/src/core/sqlitestorage.cpp
@@ -283,11 +283,13 @@ bool SqliteStorage::updateIdentity(UserId user, const CoreIdentity &identity) {
 #endif
   query.bindValue(":identityid", identity.id().toInt());
   safeExec(query);
+  watchQuery(query);
 
   QSqlQuery deleteNickQuery(logDb());
   deleteNickQuery.prepare(queryString("delete_nicks"));
   deleteNickQuery.bindValue(":identityid", identity.id().toInt());
   safeExec(deleteNickQuery);
+  watchQuery(deleteNickQuery);
 
   QSqlQuery insertNickQuery(logDb());
   insertNickQuery.prepare(queryString("insert_nick"));
@@ -295,6 +297,7 @@ bool SqliteStorage::updateIdentity(UserId user, const CoreIdentity &identity) {
     insertNickQuery.bindValue(":identityid", identity.id().toInt());
     insertNickQuery.bindValue(":nick", nick);
     safeExec(insertNickQuery);
+    watchQuery(insertNickQuery);
   }
 
   return true;
-- 
2.20.1