dbx_sqlite: fix events queries

1 files changed, 5 insertions, 2 deletions

diff --git a/plugins/Dbx_sqlite/src/dbevents.cpp b/plugins/Dbx_sqlite/src/dbevents.cpp
index bff8362c41..d131681409 100644
--- a/plugins/Dbx_sqlite/src/dbevents.cpp
+++ b/plugins/Dbx_sqlite/src/dbevents.cpp
@@ -20,8 +20,8 @@ enum {
 };
 
 static char *evt_stmts[SQL_EVT_STMT_NUM] = {
-	"select count(1) from events limit 1;",
-	"insert into events values (null, ?, ?, ?, ?, ?, ?, ?);",
+	"select count(1) from events where contactid = ? limit 1;",
+	"insert into events(contactid, module, timestamp, type, flags, size, blob) values (?, ?, ?, ?, ?, ?, ?);",
 	"delete from events where id = ?;",
 	"select size from events where id = ? limit 1;",
 	"select module, timestamp, flags, type, size, blob from events where id = ? limit 1;",
@@ -132,6 +132,9 @@ BOOL CDbxSQLite::DeleteEvent(MCONTACT hContact, MEVENT hDbEvent)
 
 LONG CDbxSQLite::GetBlobSize(MEVENT hDbEvent)
 {
+	if (hDbEvent == 0)
+		return -1;
+
 	mir_cslock lock(m_csDbAccess);
 	sqlite3_stmt *stmt = evt_stmts_prep[SQL_EVT_STMT_BLOBSIZE];
 	sqlite3_bind_int(stmt, 1, hDbEvent);