Yeah, everything looks great again. Thank you Tom for that excellent support. Greetings from Suedlohn (Germany). Berny
[email protected] schrieb am Donnerstag, 19. November 2020 um 17:56:56 UTC+1: > So, for some reason, the weighted sum (field 'wsum') has too high a value, > or the sum of observation time (field 'sumtime') has too low a value. > > The easiest fix is to just rebuild the daily summaries using the wee_database > utility <http://www.weewx.com/docs/utilities.htm#wee_database_utility>. > > Stop weewxd. then, > > *wee_database --drop-daily* > *wee_database --rebuild-daily* > > Restart weewxd > > For a database of your size, it shouldn't take more than a minute or two. > > It could take some time for the NOAA and html files to get corrected. You > can speed things up by deleting them and allowing weewx to regenerate them. > > -tk > > > > On Thu, Nov 19, 2020 at 8:48 AM Berny Cl <[email protected]> wrote: > >> sqlite> select sum(wsum)/sum(sumtime) from archive_day_outTemp where >> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11'; >> 60.1308595259353 >> >> Ok, that looks the same like the value in my history table. >> >> [email protected] schrieb am Donnerstag, 19. November 2020 um 17:13:38 >> UTC+1: >> >>> 1. That looks reasonable. One other query to try: >>> >>> sqlite> *select sum(wsum)/sum(sumtime) from archive_day_outTemp where >>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';* >>> >>> 2. If that doesn't reveal anything, I will send you an instrumented >>> version of xtypes.py that will log the calculation. >>> >>> >>> On Thu, Nov 19, 2020 at 6:44 AM Berny Cl <[email protected]> wrote: >>> >>>> sqlite> select avg(outTemp) from archive where strftime("%Y-%m", >>>> dateTime,'unixepoch','localtime')=='2020-11'; >>>> 51.117818676717 <(781)%20867-6717> >>>> sqlite> select sum(sum)/sum(count) from archive_day_outTemp where >>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11'; >>>> 51.114923603352 >>>> >>>> Thank you! >>>> OK, I did that. The two numbers are very close. I think they are >>>> correct (in Fahrenheit) but in my history table the temperature ist too >>>> high (in degree Celsius). >>>> >>>> [email protected] schrieb am Donnerstag, 19. November 2020 um 15:02:55 >>>> UTC+1: >>>> >>>>> Most likely it's some bad data. Let's check the database directly. >>>>> >>>>> First find the database. If you did a package install, it's most >>>>> likely at /var/lib/weewx/weewx.sdb. If you did a setup.py install, it's >>>>> at >>>>> /home/weewx/archive/weewx.sdb. Let's assume the former. >>>>> >>>>> Then, run two queries: >>>>> >>>>> *sqlite /var/lib/weewx/weewx.sdb* >>>>> sqlite> *select avg(outTemp) from archive where strftime("%Y-%m", >>>>> dateTime,'unixepoch','localtime')=='2020-11';* >>>>> sqlite> *select sum(sum)/sum(count) from archive_day_outTemp where >>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';* >>>>> >>>>> The first method calculates the average temperature for Nov 2020 by >>>>> using the main archive table. The second by using the daily summaries. >>>>> The >>>>> two numbers should be very close. See what you get and we'll take it from >>>>> there. >>>>> >>>>> -tk >>>>> >>>>> >>>>> On Thu, Nov 19, 2020 at 4:43 AM Berny Cl <[email protected]> wrote: >>>>> >>>>>> Hi everybody, >>>>>> since the last update to version 4.20, i have noticed an incorrect >>>>>> value for the monthly average temperature at the history table and also >>>>>> in >>>>>> the monthly NOAA table. >>>>>> I use the niculskin and my station is a FineOffset (WS 1080). >>>>>> >>>>>> See at: http://haus-volmering.de/history.html >>>>>> (Durchschnittstemperatur = Average Temperature for Nov is obviously >>>>>> incorrect) >>>>>> >>>>>> How can I fix that? >>>>>> >>>>>> -- >>>>>> 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 on the web visit >>>>>> https://groups.google.com/d/msgid/weewx-user/277ec811-21b4-41e9-8fc1-cda38d87014dn%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/weewx-user/277ec811-21b4-41e9-8fc1-cda38d87014dn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- >>>> 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 on the web visit >>>> https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >> 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 on the web visit >> https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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 on the web visit https://groups.google.com/d/msgid/weewx-user/4d1cf60d-c2ca-404e-b25e-42d5fd52ebdan%40googlegroups.com.
