SQL Error on Network Table

When im going to System > Tools > Network i get the following Error Message

I cannot reproduce this locally. Does /var/log/pihole/FTL.log have any more context about the error?

coming back to this, this is the result:

2023-12-11 01:02:57.513 [172M] ERR: getAliasclientIDfromIP("10.1.0.6") - SQL error prepare: SQL logic error
2023-12-11 01:02:57.513 [172M] ERR: 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)
2023-12-11 01:02:57.513 [172M] ERR: getMACfromIP("10.1.0.6") - SQL error prepare: SQL logic error
2023-12-11 01:02:57.513 [172M] ERR: SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
2023-12-11 01:02:57.513 [172M] ERR: getNameFromIP("10.1.0.6") - SQL error prepare: SQL logic error
2023-12-11 01:02:57.514 [172M] ERR: SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
2023-12-11 01:02:57.514 [172M] ERR: getIfaceFromIP("10.1.0.6") - SQL error prepare: SQL logic error
2023-12-11 01:02:58.859 [172M] ERR: SQLite3 message: no such table: network in "SELECT aliasclient_id FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? AND aliasclient_id IS NOT NULL GROUP BY ip HAVING max(lastSeen));" (1)
2023-12-11 01:02:58.859 [172M] ERR: getAliasclientIDfromIP("192.168.10.115") - SQL error prepare: SQL logic error
2023-12-11 01:02:58.860 [172M] ERR: 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)
2023-12-11 01:02:58.861 [172M] ERR: getMACfromIP("192.168.10.115") - SQL error prepare: SQL logic error
2023-12-11 01:02:58.861 [172M] ERR: SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
2023-12-11 01:02:58.862 [172M] ERR: getNameFromIP("192.168.10.115") - SQL error prepare: SQL logic error
2023-12-11 01:02:58.863 [172M] ERR: SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
2023-12-11 01:02:58.863 [172M] ERR: getIfaceFromIP("192.168.10.115") - SQL error prepare: SQL logic error
2023-12-11 01:03:00.062 [172/T173] ERR: SQLite3 message: statement aborts at 1: [BEGIN TRANSACTION] cannot start a transaction within a transaction (1)
2023-12-11 01:03:00.062 [172/T173] ERR: ERROR: SQL query "BEGIN TRANSACTION" failed: SQL logic error (SQLITE_ERROR)
2023-12-11 01:03:00.063 [172/T173] ERR: export_queries_to_disk() failed!
2023-12-11 01:03:00.063 [172/T173] ERR: SQLite3 message: no such table: network_addresses in "DELETE FROM network_addresses WHERE lastSeen < 1694386980;" (1)
2023-12-11 01:03:00.063 [172/T173] ERR: ERROR: SQL query "DELETE FROM network_addresses WHERE lastSeen < 1694386980;" failed: SQL logic error (SQLITE_ERROR)
2023-12-11 01:03:16.197 [172M] ERR: SQLite3 message: no such table: network in "SELECT aliasclient_id FROM network WHERE id = (SELECT network_id FROM network_addresses WHERE ip = ? AND aliasclient_id IS NOT NULL GROUP BY ip HAVING max(lastSeen));" (1)
2023-12-11 01:03:16.197 [172M] ERR: getAliasclientIDfromIP("192.168.10.148") - SQL error prepare: SQL logic error
2023-12-11 01:03:16.198 [172M] ERR: 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)
2023-12-11 01:03:16.199 [172M] ERR: getMACfromIP("192.168.10.148") - SQL error prepare: SQL logic error
2023-12-11 01:03:16.199 [172M] ERR: SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
2023-12-11 01:03:16.200 [172M] ERR: getNameFromIP("192.168.10.148") - SQL error prepare: SQL logic error
2023-12-11 01:03:16.200 [172M] ERR: SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
2023-12-11 01:03:16.201 [172M] ERR: getIfaceFromIP("192.168.10.148") - SQL error prepare: SQL logic error
2023-12-11 01:03:58.373 [172M] ERR: 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)
2023-12-11 01:03:58.373 [172M] ERR: getMACfromIP("192.168.10.230") - SQL error prepare: SQL logic error
2023-12-11 01:03:58.374 [172M] ERR: SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
2023-12-11 01:03:58.374 [172M] ERR: getNameFromIP("192.168.10.230") - SQL error prepare: SQL logic error
2023-12-11 01:03:58.375 [172M] ERR: SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
2023-12-11 01:03:58.375 [172M] ERR: getIfaceFromIP("192.168.10.230") - SQL error prepare: SQL logic error
2023-12-11 01:04:00.016 [172/T173] ERR: SQLite3 message: statement aborts at 4: [ATTACH ? AS ?] database disk is already in use (1)
2023-12-11 01:04:00.016 [172/T173] ERR: attach_database(): Failed to attach database: SQL logic error
2023-12-11 01:04:00.016 [172/T173] ERR: SQLite3 message: no such table: network_addresses in "DELETE FROM network_addresses WHERE lastSeen < 1694387040;" (1)
2023-12-11 01:04:00.017 [172/T173] ERR: ERROR: SQL query "DELETE FROM network_addresses WHERE lastSeen < 1694387040;" failed: SQL logic error (SQLITE_ERROR)
2023-12-11 01:04:00.274 [172M] ERR: 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)
2023-12-11 01:04:00.274 [172M] ERR: getMACfromIP("192.168.10.168") - SQL error prepare: SQL logic error
2023-12-11 01:04:00.275 [172M] ERR: SQLite3 message: no such table: network_addresses in "SELECT name FROM network_addresses WHERE name IS NOT NULL AND ip = ?;" (1)
2023-12-11 01:04:00.275 [172M] ERR: getNameFromIP("192.168.10.168") - SQL error prepare: SQL logic error
2023-12-11 01:04:00.276 [172M] ERR: SQLite3 message: no such table: network in "SELECT interface FROM network JOIN network_addresses ON network_addresses.network_id = network.id WHERE network_addresses.ip = ? AND interface != 'N/A' AND interface IS NOT NULL;" (1)
2023-12-11 01:04:00.276 [172M] ERR: getIfaceFromIP("192.168.10.168") - SQL error prepare: SQL logic error

It seems your database is incomplete or corrupted.

What is the output of this command?

pihole-FTL sqlite3  /etc/pihole/pihole-FTL.db  "SELECT name FROM sqlite_schema WHERE type='table' ORDER BY name;"