From 1309637a5843403a75488052fc5287136639ffba 2015-11-25 16:23:13
From: Jan Kaluza <jkaluza@redhat.com>
Date: 2015-11-25 16:23:13
Subject: [PATCH] SQLite3Backend::setUser - use null for the 'id' when user.id is 0

---

diff --git a/src/SQLite3Backend.cpp b/src/SQLite3Backend.cpp
index 5567dcc833ad35837c45e603de66123293d16ba6..eedbf94c613e7567bc13a4c84a64a9cae69ba5b7 100644
--- a/src/SQLite3Backend.cpp
+++ b/src/SQLite3Backend.cpp
@@ -223,7 +223,12 @@ bool SQLite3Backend::exec(const std::string &query) {
 
 void SQLite3Backend::setUser(const UserInfo &user) {
 	sqlite3_reset(m_setUser);
-	sqlite3_bind_int(m_setUser, 1, user.id);
+	if (user.id == 0) {
+		sqlite3_bind_null(m_setUser, 1);
+	}
+	else {
+		sqlite3_bind_int(m_setUser, 1, user.id);
+	}
 	sqlite3_bind_text(m_setUser, 2, user.jid.c_str(), -1, SQLITE_STATIC);
 	sqlite3_bind_text(m_setUser, 3, user.uin.c_str(), -1, SQLITE_STATIC);
 	sqlite3_bind_text(m_setUser, 4, user.password.c_str(), -1, SQLITE_STATIC);