From 4e5f302958000f3f5623b3d8d82744e5f36db855 Mon Sep 17 00:00:00 2001 From: Evgeny Zinoviev Date: Sun, 5 Feb 2023 03:01:58 +0300 Subject: ipcam_server: sqlite fix --- src/ipcam_server.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/ipcam_server.py b/src/ipcam_server.py index f15363e..bf796dd 100755 --- a/src/ipcam_server.py +++ b/src/ipcam_server.py @@ -79,7 +79,7 @@ class IPCamServerDatabase(SQLiteBase): cursor.execute("ALTER TABLE motion_failures ADD COLUMN message TEXT NOT NULL DEFAULT ''") if version < 4: - cursor.execute("ALTER TABLE timestamps ADD COLUMN motion_start_time INTEGER NOT NULL") + cursor.execute("ALTER TABLE timestamps ADD COLUMN motion_start_time INTEGER NOT NULL DEFAULT 0") cursor.execute("UPDATE timestamps SET motion_start_time=motion_time") self.commit() -- cgit v1.2.3