diff options
author | Christian König <ckoenig@posteo.de> | 2022-02-13 01:33:19 +0300 |
---|---|---|
committer | Christian König <ckoenig@posteo.de> | 2022-02-13 01:33:19 +0300 |
commit | f4286a4d1256d2629272d7286a4ad12bbe4aef24 (patch) | |
tree | 5ffffde3d848b38813c14efc82db1e24b5dd4420 | |
parent | e9250d62c562a2a174e2768f0b2513f68f264746 (diff) |
Fix log flush with new query database schemafix/flush
Signed-off-by: Christian König <ckoenig@posteo.de>
-rwxr-xr-x | advanced/Scripts/piholeLogFlush.sh | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/advanced/Scripts/piholeLogFlush.sh b/advanced/Scripts/piholeLogFlush.sh index 7547a5fd..57f901f5 100755 --- a/advanced/Scripts/piholeLogFlush.sh +++ b/advanced/Scripts/piholeLogFlush.sh @@ -63,7 +63,7 @@ else fi fi # Delete most recent 24 hours from FTL's database, leave even older data intact (don't wipe out all history) - deleted=$(pihole-FTL sqlite3 "${DBFILE}" "DELETE FROM queries WHERE timestamp >= strftime('%s','now')-86400; select changes() from queries limit 1") + deleted=$(pihole-FTL sqlite3 "${DBFILE}" "DELETE FROM query_storage WHERE timestamp >= strftime('%s','now')-86400; select changes() from query_storage limit 1") # Restart pihole-FTL to force reloading history sudo pihole restartdns |