Error in log file error-pihole.log and FTL.log

Help Community Help
1

The issue I am facing:
Errors in log files
Details about my system:
running on Raspberry Pi
What I have changed since installing Pi-hole:
started using pi-hole as dhcp server and name server
https://tricorder.pi-hole.net/zCnJcxIg/

2

What are the specific errors you are seeing?

3

in FTL.log:
[2022-12-16 22:32:00.075 22641/T22657] SQLite3 message: no such table: network_addresses in "DELETE FROM network_addresses WHERE lastSeen < 1639715520;" (1)
[2022-12-16 22:32:00.075 22641/T22657] ERROR: SQL query "DELETE FROM network_addresses WHERE lastSeen < 1639715520;" failed: SQL logic error

error-pihole.log:
2022-12-16 16:04:59: mod_fastcgi.c.487) FastCGI-stderr:PHP Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: message in /var/www/html/admin/api_db.php on line 385

4

Also having an issue with "Add a new client" where when trying it only list
0
Success
mesage (error while querying FTL's database: not an error)

...meanwhile the "List of configured clients" just says "Loading..."

5

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
1 Like
6

Thank you for all the help. Recreating the FTL database fixed the issue.

7

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