From 10f748c2454c48f92e28ed987430cb5846df456a Mon Sep 17 00:00:00 2001 From: George Hazan Date: Sun, 28 Jan 2024 14:11:41 +0300 Subject: fix for broken JSON functions in SQLITE 3.45 --- plugins/Dbx_sqlite/src/dbevents.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'plugins/Dbx_sqlite') diff --git a/plugins/Dbx_sqlite/src/dbevents.cpp b/plugins/Dbx_sqlite/src/dbevents.cpp index 81fc24fa39..55d4cd70aa 100644 --- a/plugins/Dbx_sqlite/src/dbevents.cpp +++ b/plugins/Dbx_sqlite/src/dbevents.cpp @@ -330,7 +330,7 @@ int CDbxSQLite::SetEventJson(MEVENT hDbEvent, const char *szSetting, DBVARIANT * CMStringA tmp(FORMAT, "$.%s", szSetting); { mir_cslock lock(m_csDbAccess); - sqlite3_stmt *stmt = InitQuery("UPDATE events SET data=json_set(data, ?, ?) WHERE id = ?;", qEvSetJson); + sqlite3_stmt *stmt = InitQuery("UPDATE events SET data=json_set(cast(data as text), ?, ?) WHERE id = ?;", qEvSetJson); sqlite3_bind_text(stmt, 1, tmp, tmp.GetLength(), nullptr); switch (dbv->type) { -- cgit v1.2.3