After you clear out the bad records in the archive table, the official way to rebuild the daily summary table would be to run weectl database with the rebuild-daily option and specify just the date in question. My example kinda slam dunks the value an unofficial way.
Official docs are at https://weewx.com/docs/5.1/utilities/weectl-database/#rebuild-the-daily-summaries On Monday, August 4, 2025 at 4:33:30 PM UTC-7 [email protected] wrote: > ! I have been researching this and found just what you suggest: I need to > install sqlite3. Not knowing much I have been concerned that sqlite3 will > interfere with the weewx database. From what I see it is a stand alone > utility that I can use to access weewx.sdb AND not a database installer. > THANKS Vince, a project for tomorrow. Wish me luck. > > On Monday, August 4, 2025 at 6:29:05 PM UTC-4 vince wrote: > >> You likely need to install the sqlite3 utility. >> >> On Monday, August 4, 2025 at 1:16:39 PM UTC-7 [email protected] wrote: >> >>> Thank you for the quick reply... I am sure my lack of Pi / SQLite >>> knowledge is at issue here. >>> I pasted: >>> *echo "select >>> datetime(dateTime,'unixepoch','localtime'),dateTime,rain,rainRate from >>> archive order by rowid desc limit 20;" | sqlite3 weewx.sdb* >>> into the terminal as the user Pi (pi@raspberrypi:) and get back: >>> *bash: sqlite3: command not found.* >>> >>> Adding the preface *sudo* did not change the response. >>> >>> If more explicit instructions would help, please advise. >>> Den >>> On Monday, August 4, 2025 at 3:43:25 PM UTC-4 vince wrote: >>> >>>> >>>> https://github.com/vinceskahan/weewx-odds-and-ends/blob/master/fix-bad-rain.md >>>> >>>> is one way to do it >>>> >>>> On Monday, August 4, 2025 at 10:13:29 AM UTC-7 [email protected] wrote: >>>> >>>>> Hardware maintenance resulted in 1.63" of daily rain data that is not >>>>> real. Is there an easy way to correct this error? >>>>> I am running WeeWX 5.0 on a Raspberry Pi. >>>>> Thanks, >>>>> Den >>>>> >>>> -- 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/61da61c6-d6f1-483e-aeb8-3cf26d941c92n%40googlegroups.com.
