From d653166c6ee7345b8858e17bcc07a03229b23131 Mon Sep 17 00:00:00 2001 From: George Hazan Date: Sun, 10 Jan 2021 18:40:42 +0300 Subject: fixes #2121 ([dbx_sqlite] Event updates do not work properly) --- plugins/Dbx_sqlite/src/dbevents.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'plugins') diff --git a/plugins/Dbx_sqlite/src/dbevents.cpp b/plugins/Dbx_sqlite/src/dbevents.cpp index 170f5ab15f..1ae0fb0663 100755 --- a/plugins/Dbx_sqlite/src/dbevents.cpp +++ b/plugins/Dbx_sqlite/src/dbevents.cpp @@ -36,7 +36,7 @@ static CQuery evt_stmts[] = { "SELECT COUNT(1) FROM events_srt WHERE contact_id = ? LIMIT 1;" }, { "INSERT INTO events(contact_id, module, timestamp, type, flags, data, server_id) VALUES (?, ?, ?, ?, ?, ?, ?);" }, { "DELETE FROM events WHERE id = ?;" }, - { "UPDATE events SET module = ?, timestamp = ?, type = ?, flags = ?, blob = ? WHERE id = ?;" }, + { "UPDATE events SET module = ?, timestamp = ?, type = ?, flags = ?, data = ? WHERE id = ?;" }, { "SELECT LENGTH(data) FROM events WHERE id = ? LIMIT 1;" }, { "SELECT module, timestamp, type, flags, length(data), data FROM events WHERE id = ? LIMIT 1;" }, { "SELECT flags FROM events WHERE id = ? LIMIT 1;" }, -- cgit v1.2.3