Hi, I'm hoping for some pointers to eradicate an erroneous 'Highest Daily Rainfall' value (see attached image).
I have 19.79cm of rain registered on 22/April/2025 - a day where there was no rain at all. I've tried to follow some of the steps from other threads, querying the database for erroneous looking data both from the CLI and by searching with DB Browser, however I conclude that I am probably looking for the wrong value in the wrong place! Here's what I returned from the database: sqlite> select datetime(dateTime,'unixepoch','localtime'),dateTime,rain,rainRate from archive where dateTime > 1745276400 and dateTime <= 1745366400; 2025-04-22 00:05:00|1745276700|0.0|0.0 2025-04-22 00:10:00|1745277000|0.0|0.0 2025-04-22 00:15:00|1745277300|0.0|0.0 <---snip - all zero data for every 5 minute interval ---> 2025-04-23 00:45:00|1745365500|0.0|0.0 2025-04-23 00:50:00|1745365800|0.0|0.0 2025-04-23 00:55:00|1745366100|0.0|0.0 2025-04-23 01:00:00|1745366400|0.0|0.0 I can't find a '19.79' in the database (or 1978 in case of a round up), and the sum of the values above would clearly be zero. I looked at this post: https://groups.google.com/g/weewx-user/c/pQohXWFsEjk Which talks about dropping the daily database and rebuilding it - however /etc/weewx/scripts/wee_database (and all scripts in that folder) are not executable, so I am a little concerned they are orphans from an older version and are superseded by newer utilities in a different location. Any pointers would be much appreciated, thanks in advance. J -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/a563946c-967a-4736-a643-5d22da8174abn%40googlegroups.com.
