From 08cf52eafbd690bbaa3c86e57cb02e7e82dc3159 Mon Sep 17 00:00:00 2001 From: Unknown Date: Tue, 11 Mar 2008 10:53:54 +0000 Subject: [PATCH] fixing upgrade script --- src/core/SQL/SQLite/10/upgrade_000_switch_to_msgid.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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 -- 2.20.1