Running pihole on a QNAP in a docker. Was fine prior to updating the qnap os.
Expected Behaviour:
Long term data should load
Actual Behaviour:
An unknown error occurred while loading the data.
The debug log shows PHP and FTL errors:
PHP:
2023-07-29 23:49:42: mod_fastcgi.c.487) FastCGI-stderr:PHP Warning: SQLite3::prepare(): Unable to prepare statement: 1, no such table: query_storage in /var/www/html/admin/api_db.php on line 94
FTL:
[2023-07-29 23:49:13.075 222M] SQLite3 message: no such column: aliasclient_id 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)
...
This usually means Pi-hole found a database corruption.
Are you using volumes for your containers? Can you please post your compose file or docker run command used to start the container?
So the version that was working didn’t work even after a fresh install, i went back to a version from December and it seems to be working, didn’t have time to try and update the container now thats its functioning but will. Yes, i am using volumes for the container. I’ll do some more debugging on the new version but here is my token for the current install that is working. Keep in mind, using the same mappings i was using. I just deleted the files that were there. Only weird thing i see is in the tail ftl log. SQLite3 message: multiple links to file: /macvendor.db (28)
https://tricorder.pi-hole.net/2lmwSu4q/
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.