PiHole on RPI4 connected by Ethernet into a Asus RT-AC3200 router running stock firmware. All firmware updated (PiHole v 5.10). PiHole set as the DNS and DHCP server. VPN configured on the router, but this issue seems to happen regardless of VPN status.
Expect dashboards and all functions to work
Actual Behaviour:
Queries are managed, DNS and DHCP are working, query log works, but dashboard graphics are not visible. Client Group Management and List of Configured Clients is blank. When I click Tools>Network I get a pop-up message, "An unknown error occurred while loading data", and Network Overview is blank
Your debug log suggests your Pi-hole's query database to be severely damaged ; it's missing basic tables:
*** [ DIAGNOSING ]: contents of /var/log
-rw-r--r-- 1 pihole pihole 314K May 1 12:30 /var/log/pihole-FTL.log
-----tail of pihole-FTL.log------
[2022-05-01 12:30:41.228 557M] SQLite3 message: no such table: network in "SELECT hwaddr FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? GROUP BY ip HAVING max(lastSeen));" (1)
[2022-05-01 12:30:41.229 557M] SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
[2022-05-01 12:30:43.421 557M] SQLite3 message: no such table: message in "INSERT INTO message (timestamp,type,message,blob1,blob2,blob3,blob4,blob5) VALUES ((cast(strftime('%s', 'now') as int)),?,?,?,?,?,?,?);" (1)
And suddenly, the dashboard is working. Maybe my repair earlier today accomplished something. Unfortunately, there is still nothing on the network overview page. I'll post another Debug Token.