Client list section does not work

Help docker
1

Hi I installed pihole in docker on a qnap nas. Networking has been set on Bridge and pihole in fact works. However the "Clients" page does not seem to work.

  • clients list is empty
  • if I add an ip I receive an error, same if I add a MAC
  • the "list of configured clients" shows "loading..." and that's all

When I installed a "preconfigured" application it was working but was an older version of pihole...

pihole 5.17.1 ftl 5.23 web 5.20.1

2

Logs have this error

[2023-10-02 12:53:00.080 229/T260] SQLite3 message: no such column: name in "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715180;" (1)
[2023-10-02 12:53:00.081 229/T260] ERROR: SQL query "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715180;" failed: SQL logic error (SQLITE_ERROR)
[2023-10-02 12:54:00.086 229/T260] SQLite3 message: no such column: name in "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715240;" (1)
[2023-10-02 12:54:00.087 229/T260] ERROR: SQL query "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715240;" failed: SQL logic error (SQLITE_ERROR)
[2023-10-02 12:55:00.035 229/T260] SQLite3 message: no such column: name in "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715300;" (1)
[2023-10-02 12:55:00.035 229/T260] ERROR: SQL query "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715300;" failed: SQL logic error (SQLITE_ERROR)
[2023-10-02 12:56:00.067 229/T260] SQLite3 message: no such column: name in "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715360;" (1)
[2023-10-02 12:56:00.067 229/T260] ERROR: SQL query "UPDATE network_addresses SET name = NULL WHERE nameUpdated < 1664715360;" failed: SQL logic error (SQLITE_ERROR)

3

Please upload a debug log and post just the token URL that is generated after the log is uploaded by running the following command from the Pi-hole host terminal:

pihole -d

or do it through the Web interface:

Tools > Generate Debug Log