Network Overview does not load (log suggest SQLite3 problem)

The issue I am facing:
Network Overview does not show up "Unknown error occurred while loading data"

Details about my system:
Ubuntu 20.04.2 LTS (arm64) on a Raspberry Pi 4B with 2 GB of RAM

What I have changed since installing Pi-hole:
Apache2 instead of lighttpd

What I have already tried
Re-Install of SQLite3 and php-sqlite via:

sudo apt remove --purge sqlite3 php-sqlite
sudo apt autoremove --purge -y
sudo apt install sqlite3 php-sqlite

Delete your long term database and restart FTL.

When I click on "Flush Network Table" in the settings section on the pi-hole web interface I get the following message:

e[K [✗] Failed to truncate network_addresses table
Database location: /etc/pihole/pihole-FTL.db
Output: Error: database disk image is malformed

sudo service pihole-FTL stop

sudo rm /etc/pihole/pihole-FTL.db

sudo service pihole-FTL start
1 Like

Thank You, jfb and yubiuser! Now the Network-Table shows up again!

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.