Thank you Michael - that was the tip I needed. I did already try searching in inches, to no avail - but as you say, I was looking in the wrong table entirely.
The offending row is attached. Epoch time 1745362800, which equates to the correct end of day with my DST offset. There are 3 values in the row: max - I guess this is the max per daily 5 minute segment (though obviously unrealistic given the contents of the other table all being zero) sum - This is the value in inches which converts neatly to 19.79cm wsum - not sure what this relates to as it doesn't look like a sum of anything, nor does it look like a metric view of the imperial values (too big). I'm thinking, based on looking at adjacent rows, that I should zero out all of these fields - is that what you'd recommend? >From etc/weewx/weewx.conf, it looks like I am on version 4.10.2 - so weectl is the right tool. What would you suggest I rebuild? Should I delete the NOAA report for April 2025 also to have that regenerated? Thank you again for all the pointers, John On Wednesday, 10 December 2025 at 04:17:44 UTC [email protected] wrote: There are several reasons why you mayy not find a 19.79 value in the database: - You are searching the wrong table: you won't find the highest daily rainfall in the archive table. (Unless all the rain was recorded in a single interval). Look for the table archive_day_rain and in there you should find a row with that value (in which unit it may be, I don't know) - Units: the database doesn't necessarily contain metric values. Especially if you haven't actively changed the default unit_system for the database. So the value you are looking for might be stored in inch A complete rebuild of your whole history might not be necessary, if such values aren't a repeating pattern. Which version are you on? wee_database is from before v5.0. So if you are on a newer version you should use weectl database - and refer to the docs for the version you use. JohnP schrieb am Dienstag, 9. Dezember 2025 um 22:04:09 UTC+1: 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/e561a9e2-f672-4d3b-8fd3-3df9f54838e2n%40googlegroups.com.
