BirdNET-Pi icon indicating copy to clipboard operation
BirdNET-Pi copied to clipboard

Published 20 hours ago • verified publisher icon mcguirepr89

Species Stats page not updating with latest date

Open pddpauw opened this issue 1 year ago • 2 comments

the tabsheet "Species Stats" on the PiBirdnet webpage is not updating with the latest available date. Latest date available, is the day of restart. In below example; last recordings are till 13-11, but I can only select until 11-11. Expected behavior would be that the day you can select should equal today.

A restart (in this case full Pi restart) changed the latest available date to the date of the restart, but not resolving the issue.

image image

Sysinfo: image image

Date of the PI: image

Database has the correct dates: image

Pieter

pddpauw avatar Nov 13 '23 20:11 pddpauw

I've corrected this in the plotly_streamlit.py, by adding st.cache_resource.clear() before connecting to the DB. So adding this on line 53 (before conn = get_connection(URI_SQLITE_DB)) resolves this issue. @mcguirepr89 can we add this in the code?

pddpauw avatar Nov 29 '23 19:11 pddpauw

Also seeing this issue. Will try your fix @pddpauw . Thanks!

kspearrin avatar Jan 03 '24 15:01 kspearrin