X-Git-Url: https://git.quassel-irc.org/?p=quassel.git;a=blobdiff_plain;f=src%2Fcore%2FSQL%2FSQLite%2F10%2Fupgrade_000_switch_to_msgid.sql;h=de1b9bfabcb92c283ae282d3f481601dd916b795;hp=fa40d08451c8b125ba66e8951da9ed2c46408862;hb=08cf52eafbd690bbaa3c86e57cb02e7e82dc3159;hpb=f66bc9ecb5ebde376da256035db425d7dc0c74d0

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