Hey,
I'm using Pi-Hole in a docker container on a Synolog disk station. When I'm accessing Long-Term Data and select a time range I get this error: FAQ - Pi-hole documentation
/var/log/lighttpd/error-pihole.log has the following entries:
2023-03-16 15:22:44: 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
2023-03-16 15:22:44: mod_fastcgi.c.487) FastCGI-stderr:PHP Fatal error: Uncaught Error: Call to a member function bindValue() on bool in /var/www/html/admin/api_db.php:95
2023-03-16 15:22:44: mod_fastcgi.c.487) FastCGI-stderr:Stack trace:
2023-03-16 15:22:44: mod_fastcgi.c.487) FastCGI-stderr:#0 {main}
2023-03-16 15:22:44: mod_fastcgi.c.487) FastCGI-stderr: thrown in /var/www/html/admin/api_db.php on line 95
This hints to me as if there seems to be some database issues.
Debug log is here: https://tricorder.pi-hole.net/aAdJYd22/
Any help would be appreciated.
Expected behavior is being able to look at long-term data.