Compute graphical statistics displaying same data

[mayk]

Please follow the below template, it will help us to help you!

Expected Behaviour:

Statistics being displayed over the in the dates selected period, or in the range of the predefined last month, last year etc.

Actual Behaviour:

The same graph is being displayed with the exception of the overall selection. Also the time-scale is not adjusted below the graph.

Running on an Pi3 , stretch, latest updates as of time of writing.
Pi-hole version 3.3.1 , timesynct with the debian servers using chrony

Change of browser does not resolve ( Chromium, Firefox and Midori );
Flushing logs on pi-hole ftl
Clearing Cache did not resolve;
Reboot did not resolve;

I suspect the image/png that is being generated in the background is not overwritten/refreshed.

Debug Token: tzkeh4zl9u

Thank you in advance !

Greets

Mayk

[RamSet]

Could you post a screenshot of what you are experiencing?

[mayk]

Hi,

thank you for your reply. Attached are screenshots from last moth, 30days, 7 days and yesterJunday.. The strange thing is, the yesterday selection does adjust the graph. Other preselected timeframes don't and manually entered selections also fail.

[RamSet]

What day(date or time) does it give you when you hover your mouse over the highest and lowest point of the slope ?

[mayk]

Hi Ramset,

In the period of last 30 days, the date on the most left is of 4-6 ( 2days ago). This is consistant over all the broken timeframes.

See screenshots..

thank you for the support so far.. Just made a donation

[RamSet]

Your LTD (Long term database /etc/pihole/pihole-FTL.db) most likely does not have data prior to 2018-06-04.

This can be due to several factors (re-installing pi-hole, pihole-FTL.db file overwrites or deletion)

@mayk

thank you for the support so far… Just made a donation

Thank you !

[RamSet]

This however doesn't look right to me ...

[mayk]

Hi,

The pi-hole is running for a few weeks.. ( this was a re-install since the upgrade broke more then alcohol could fix) .

This behavior was present before i flushed all the logs.. When i run the query logs over the all time range it produces stats that are not possible in a time-frame of 2 days 173k+ in queries. A quick sum of today and yesterday does not exceed 15k in queries ( since the graph hover date displays 4-6 as in 2 days ago ) .

I wil check tomorrow if the time-frame shifts, i suspect it to do.

if it is advisable to do a full reset of pi-hole, pls inform me how to do this.

thank you in advance.

greets

Mayk

[technicalpyro]

to fully flush out FTL and the long term data use the following commands one at a time

sudo service pihole-FTL stop
sudo rm /etc/pihole/pihole-FTL.db
sudo service pihole-FTL start

[mayk]

Thanks all.. the period in the graph where Ramset also notes that it's not right is still visable, but everything is logging correct again. I think i will follow technicalpyro's suggestion and remove the FTL db to flush the data and start gathering again.

Thank you for the support,awesome project so i became a patron..

This thread can be closed.