# Pi hole stock in dashboard query log

**URL:** <https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517>\
**Category:** Help\
**Created:** [April 2, 2018, 8:47pm UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517 "2018-04-02T20:47:37Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabo\_CO2](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/gabo_co2/32/3291_2.png) [@Gabo\_CO2](https://discourse.pi-hole.net/u/Gabo_CO2)\
**Post date:** [April 2, 2018, 8:47pm UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/1 "2018-04-02T20:47:37Z")

</div>

![sdfdsds](https://discourse.pi-hole.net/uploads/default/original/2X/8/8fcea2092a03b9220c9f1a41bc59daa7aca907f7.PNG)

Hi! I updated to version 3.3 (Pi-hole Version v3.3 Web Interface Version v3.3 FTL Version v3.0) yesterday. But the graph is stock, it doesn't show new data. As you can see on the image, that same graph have been displayed since I update Pi hole (about 20 hours ago). In other words, there is no live graph.

I've tried pihole -d, pihole -r, flushing logs, restarting Rasp. Pi, F5, cleaning the browser cache and cookies, and updating both Pi hole and Rasp. Pi. Still no idea how to fix it.

Thanks for your time and help.

---

<div class="post-metadata">

**Author:** ![jacob.salmela](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/jacob.salmela/32/8_2.png) [@jacob.salmela](https://discourse.pi-hole.net/u/jacob.salmela)\
**Post date:** [April 3, 2018, 11:47am UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/2 "2018-04-03T11:47:38Z")

</div>

Do you see new queries when you watch the log file?

> [@How do I watch and interpret the pihole.log file?](https://discourse.pi-hole.net/t/how-do-i-watch-and-interpret-the-pihole-log-file/276):
>
> Use this [command](https://discourse.pi-hole.net/t/the-pihole-command-with-examples/738) to watch the log file in real time: pihole -t which is just a short version of sudo tail -F /var/log/pihole.log You can also do it on the web interface: [image] When your Pi-hole first starts up, it will read your hosts file as well as /etc/pihole/gravity.list, which is where your list of ad-serving domains is. So one of the first log entries will read like this: Nov 13 07:45:04 dnsmasq[1055]: read /etc/hosts - 5 addresses Nov 13 07:45:06 dnsmasq[1055]: read /etc/pihole/g…

---

<div class="post-metadata">

**Author:** ![Gabo\_CO2](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/gabo_co2/32/3291_2.png) [@Gabo\_CO2](https://discourse.pi-hole.net/u/Gabo_CO2)\
**Post date:** [April 3, 2018, 4:48pm UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/3 "2018-04-03T16:48:39Z")

</div>

Hi Jacob, thanks for the reply.  
I already executed the command "pihole -t" and is working properly (it shows in real time all the queries and those that are piholed).

It's curious because running the command "pihole -g" does works and the Dashboards updates "Domains on Blocklist"

Still, this didn't fix the problem.

---

<div class="post-metadata">

**Author:** ![nero355](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/nero355/32/54774_2.png) [@nero355](https://discourse.pi-hole.net/u/nero355)\
**Post date:** [April 3, 2018, 7:39pm UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/4 "2018-04-03T19:39:03Z")

</div>

- Delete database.
- Delete log files.
- Reboot

Done! 🙂

I had the same issue on the day that 3.3 was released!

---

<div class="post-metadata">

**Author:** ![Gabo\_CO2](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/gabo_co2/32/3291_2.png) [@Gabo\_CO2](https://discourse.pi-hole.net/u/Gabo_CO2)\
**Post date:** [April 4, 2018, 12:14am UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/5 "2018-04-04T00:14:16Z")

</div>

Thanks nero! Umm can you tell me which commands I need to run in order to delete database and log files?  
Also, how to export/import those files (bonus).

Cheers.

---

<div class="post-metadata">

**Author:** ![jacob.salmela](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/jacob.salmela/32/8_2.png) [@jacob.salmela](https://discourse.pi-hole.net/u/jacob.salmela)\
**Post date:** [April 4, 2018, 12:22am UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/6 "2018-04-04T00:22:56Z")

</div>

```auto
sudo service pihole-FTL stop
sudo mv /etc/pihole/pihole-FTL.db /etc/pihole/pihole-FTL.db_
sudo service pihole-FTL start

```

---

<div class="post-metadata">

**Author:** ![Gabo\_CO2](https://discourse-cdn.pi-hole.net/user_avatar/discourse.pi-hole.net/gabo_co2/32/3291_2.png) [@Gabo\_CO2](https://discourse.pi-hole.net/u/Gabo_CO2)\
**Post date:** [April 4, 2018, 12:31am UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/7 "2018-04-04T00:31:39Z")

</div>

it worked!! Thanks so much 😃

---

<div class="post-metadata">

**Author:** ![system](https://discourse.pi-hole.net/uploads/default/original/3X/7/c/7c8792f649eeb921c5d2b4c41564ffa873d9a2b8.png) [@system](https://discourse.pi-hole.net/u/system)\
**Post date:** [April 25, 2018, 12:31am UTC](https://discourse.pi-hole.net/t/pi-hole-stock-in-dashboard-query-log/8517/8 "2018-04-25T00:31:55Z")

</div>

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.