From: Unknown <dev@quassel-irc.org>
Date: Tue, 11 Mar 2008 10:53:54 +0000 (+0000)
Subject: fixing upgrade script
X-Git-Tag: 0.2.0-alpha3~12
X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=commitdiff_plain;h=08cf52eafbd690bbaa3c86e57cb02e7e82dc3159

fixing upgrade script
---

diff --git a/src/core/SQL/SQLite/10/upgrade_000_switch_to_msgid.sql b/src/core/SQL/SQLite/10/upgrade_000_switch_to_msgid.sql
index fa40d084..de1b9bfa 100644
--- a/src/core/SQL/SQLite/10/upgrade_000_switch_to_msgid.sql
+++ b/src/core/SQL/SQLite/10/upgrade_000_switch_to_msgid.sql
@@ -1,3 +1,3 @@
 UPDATE buffer
-SET lastseen = (SELECT messageid FROM backlog WHERE backlog.bufferid = bufferid AND backlog.time = lastseen LIMIT 1)
+SET lastseen = (SELECT messageid FROM backlog WHERE backlog.bufferid = buffer.bufferid AND backlog.time = buffer.lastseen UNION SELECT 0 ORDER BY messageid DESC LIMIT 1)
 WHERE lastseen != 0