Client Menu error on Web UI

Please follow the below template, it will help us to help you!

Expected Behaviour:

It shows each client in the drop-down menu

this was taken from (PIHOLE IP)/admin/groups-clients.php

Also tried restarting both lighttpd (sudo service lighttpd restart) and pihole (pihole restartdns)

Actual Behaviour:

odd menu items that seem out of place as shown in the screenshot

Debug Token:

https://tricorder.pi-hole.net/5uxqqladh9

EDIT: Also tried sudo service pihole-FTL restart with no change

Have you tried to clear your browser's cache?

Yes, i also tried on a different browser

Are there any errors in

/var/log/lighttpd/error.log?

Yes!

i have about 6 of these errors with different times but the error is the same

2020-06-23 10:18:59: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3::query(): Unable to prepare statement: 11, database disk image is malformed in /var/www/html/admin/scripts/pi-hole/php/groups.php on line 211

Somehow your database got corrupted (power outages?).
You could try to repair it (/etc/pihole/pihole-ftl.db)

Or (might be easier) delete/remove it and start fresh over:

sudo service pihole-FTL stop

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

sudo service pihole-FTL start

What is in the database that i am deleting?

i dont want to delete my adlists or custom blacklists and whitelists

It's the query history (long term database) and the network details (network overview). You adlists, black/whitelist will be preserved (stored in /etc/pihole/gravity.db)

Thanks, im trying it now

This fixed it for me

thank you!

Your welcome. Glad ist worked.

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