PiHole Network and Clients list empty, but seems to be working?

[Mogga]

Hi,
I've just set up my Raspberry Pi 5 with PiHole which seems to be working. However, my network and client lists don't populate.

I can see the top clients on my network and their IP addresses on the dashboard, but otherwise the network and clients list do not appear to be working.

I've tried to flush my network table as suggested via results from Google searches and I've made sure my router (Asus Zenwifi Pro ET12) is using the Rasberry Pi as the DNS/DCHP.

So I'm not sure why this behaviour is occurring.

Here's my Debug Token:
https://tricorder.pi-hole.net/ruxwCwNH/

Thanks in advance for any help!

[rdwebdesign]

This page is part of Group Management.

It is usually initially empty.
It should only contain clients manually inserted by you, when you want to add a device to a specific Group.

If you are only using Default group, this will be empty.

[Mogga]

That doesn't sound right, so I think there's been a misunderstanding in what I'm asking because surely the Network Overview is supposed to show all the clients connected?

This shows 10, but when I go to view it, none of them show up:

Whereas back on the dashboard, the Top Clients (total) and Top Clients (blocked only) both show IP addresses on my network.

Client Group management however doesn't even pick them up.

[rdwebdesign]

Hmmm... this is a database error (I missed that when I read the log for the first time).

You database is malformed and nothing is being saved to the disk (without the database, Network page is broken).

An empty database must be at least 80Kb in size. Yours is only 44Kb:

*** [ DIAGNOSING ]: Pi-hole FTL Query Database
-rw-rw-r-- 1 pihole pihole 44K Jan 29 12:08 /etc/pihole/pihole-FTL.db

To fix the issue, run these commands to move the existing database to a new file name and create a fresh database:

sudo service pihole-FTL stop

sudo mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL-old.db

sudo service pihole-FTL start

[Mogga]

No worries there haha.

Awesome, this fixed it thank you!