Same issues here, no matter which browser (Safari, Firefox, Chrome): Browsing the dashboard works without issues but doing any queries from the "Long term data" ("Graphics", "Query Log" or "Top Lists") never finish (just the spinning loading icon) even when just picking yesterday to show/query.
I'm running on a Raspberry 3B+ and attached SSD (USB/SATA converter cable) with Raspbian Stretch latest version and all updates applied.
Recent Pi-Hole with FTL 4.2.3 installed on April 4th.
Hi, Yes, it's running on Apache (not conflicting with lighttpd as lighttpd is not installed) and almost everything is working (admin page, blocking, statistics, 404-document etc.) but all long-term-data functions fail.
The Apache-logfile says: [Thu Apr 11 16:36:18.878103 2019] [:error] [pid 2473] [client 192.168.10.50:50359] PHP Fatal error: Uncaught Error: Class 'SQLite3' not found in /var/www/html/admin/api_db.php:71\nStack trace:\n#0 /var/www/html/admin/api_db.php(86): SQLite3_connect(true)\n#1 {main}\n thrown in /var/www/html/admin/api_db.php on line 71, referer: http://192.168.1.3/admin/db_graph.php
You can still use lighttpd alongside Apache, but they can't both be on port 80. You can change the port for lighttpd in /etc/lighttpd/lighttpd.conf, but this custom setting will be overwritten with each update or repair; you would need to re-enter the change after each update or repair.
Got it working. The PHP-SQLite was not installed...
After a "sudo apt-get install php7.0-sqlite3" and reload of Apache everything works as expected.
No need for ligttpd.
Only change for apache2 was a line ErrorDocument 404 /pihole/index.php
in the 000-default-conf (for VirtualHost *:80)