"An unknown error occurred while loading the data." while trying to access active clients

[Apple1]

Expected Behaviour:

Hi! I'm trying to view my active clients using Pi-hole, but it keeps giving me this really strange error. I've tried flushing all of my logs, but it doesn't seem to leave.

I was wondering if anyone from here had an idea as to why this could be happening.

For general information, I am running Pi-hole in Docker Desktop on Windows 10.
The machine itself is a Dell OptiPlex Micro with 8GBs of RAM, a 512GB HDD, and an Intel Core i5.

Thank you!

Actual Behaviour:

"An unknown error occurred while loading the data."*

Debug Token:

https://tricorder.pi-hole.net/BWVKq3CQ/

[rdwebdesign]

@Apple1

An unknown error occurred while loading the data

The message is just a consequence of a bad database file.

You database file is only 24Kb (smaller than an empty database, which is 80Kb):

*** [ DIAGNOSING ]: Pi-hole FTL Query Database
-rw-rw-r-- 1 pihole pihole 24K Apr 29 13:00 /etc/pihole/pihole-FTL.db

You didn't post your compose file (or docker run command) used to start the container, but I guess you are storing Pi-hole files in a bind mount or volume.

To fix the error, you need to stop the container, delete the database file (pihole-FTL.db) in the volume and restart the container. A new empty database should be created.

[Apple1]

To fix the error, you need to stop the container, delete the database file (pihole-FTL.db) in the volume and restart the container. A new empty database should be created.

Hey, that did the trick! Thank you!

Everything seems to be functioning normal now that I've deleted the previous database file. The size is now at the expected 80kB.

Here's the command that I used for future reference:

docker run -d --name pihole -e ServerIP=192.168.0.22 -e WEBPASSWORD=password -e TZ=America/Phoenix -e DNS1=1.1.1.1 -e DNS2=1.0.0.1 -v pihole:/etc/pihole -p 80:80 -p 53:53/tcp -p 53:53/udp -p 443:443 --restart=unless-stopped pihole/pihole:latest