Thank you so much Michael - this worked perfectly. On Wednesday, 10 December 2025 at 10:53:53 UTC [email protected] wrote:
> The version in the config file should be the version the original config > was created with, during install. The version in the logs (5.2.0) is the > right version. > > JohnP schrieb am Mittwoch, 10. Dezember 2025 um 11:39:33 UTC+1: > >> Thanks again Michael, >> >> There might be some lint from older versions, because all the old scripts >> have had their execute attribs removed. >> >> weectl is definitely there and when I query -v, I get 5.20. >> >> When starting the daemon, it also calls out 5.20: weewxd[4170681]: INFO >> __main__: Starting up weewx version 5.2.0 >> >> It looks like the syntax is the same for wee_database vs weectl database >> too. >> >> I'll give it a go - thank you again. >> >> John >> >> >> >> >> >> On Wednesday, 10 December 2025 at 10:14:22 UTC [email protected] wrote: >> >>> With 4.10.2 wee_database ist the tool. Run wee_database --rebuild-daily >>> --date=YYYY-mm-dd where YYYY-mm-dd is whatever local date 1745362800 >>> translates to (my best guess 2025-04-23). Then delete the NOAA file for >>> April 2025. You may need a "sudo" before the command. >>> >>> If such values are not a repeating pattern, you should be done. >>> JohnP schrieb am Mittwoch, 10. Dezember 2025 um 10:46:46 UTC+1: >>> >>>> 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/42606a12-5b8f-4c87-96ec-92e10c9ad28an%40googlegroups.com.
