search

jakenology / Public_Pi-hole

Public Pi-hole Project
The Unlicense
3 stars 0 forks source link

Error: cannot modify queries because it is a view #4

Open p1r473 opened 1 year ago

p1r473 commented 1 year ago

For the rmclients script: Ever seen this error? Error: cannot modify queries because it is a view

p1r473 commented 1 year ago

Looks like the script is outdated now with current SQL structure

This should work: 

sqlite3 /etc/pihole/pihole-FTL.db "DELETE from query_storage where client in (SELECT id from client_by_id where ip like '10.97.209')"

systemctl restart pihole-FTL

https://discourse.pi-hole.net/t/using-sqlite3-to-remove-entries-for-pihole-ftl-db-is-not-longer-working/58321/8