You're on the right track: there must be an bad value in your database. Did you, by any chance, use a visual sql editor? They often put null strings in the database.
In any case, the field 'wsquaresum' and 'sumtime' are used by rms. So, try this: *sqlite3 /var/lib/weewx/weewx.sdb* sqlite> *SELECT datetime(dateTime, 'unixepoch','localtime'), wsquaresum, sumtime FROM archive_day_wind WHERE dateTime > 1533081600;* This will show all values from (roughly) 1-August (about 45 values). If the bad value is before that, we'll have to use a different strategy, rather than go looking for a needle in a haystack. -tk On Thu, Sep 13, 2018 at 11:35 PM Rahul Bedi <[email protected]> wrote: > I found rms used in the statictics.ico and hilo.ico files in the Seasons > directory. removed those segments. Diff as follows: > > $ diff statistics.14092018.inc statistics.inc > > 134,140d133 > < <tr> > < <td class="label">$obs.label.wind_rms</td> > < <td class="units">$unit.label.wind</td> > < #for $archive in $archive_data > < <td class="data new_row">$archive.wind.rms.formatted</td> > < #end for > < </tr> > > $ diff hilo.inc hilo.14092018.inc > > 132a133,140 > > <tr> > > <td class="label">$obs.label.wind_rms</td> > > #for $archive in $archive_data > > <td class="data new_row hilo_$archive[0]"> > > $archive[1].wind.rms.formatted</td> > > #end for > > <td class="units">$unit.label.wind</td> > > </tr> > > Apart from this any file referring to rms were exactly the same as the > original install. Attaching skin.conf with this message. > > As expected the problem is gone but rms is not getting reported. Which > means the issue still stays. > > Could you help me with what fields in the archive are referred to by rms ? > I can try to manually check for any value discrepancy. > > Thanks. > > - Rahul > > > On Fri, Sep 14, 2018 at 9:14 AM Rahul Bedi <[email protected]> > wrote: > >> Thanks Gary. >> >> Charges were done about a month ago but have seen no errors till this >> episode. I will do a diff with the original skin files and post it here. >> >> Thanks. >> >> - Rahul >> >> On Fri 14 Sep, 2018, 7:35 AM gjr80, <[email protected]> wrote: >> >>> On Friday, 14 September 2018 11:30:42 UTC+10, Rahul Bedi wrote: >>>> >>>> As I have made no code or config changes since the day before, I >>>> believe it doing this for the right data. >>>> >>> >>> This sounds to me like you have changed some of the seasons skin files. >>> The error is coming form the use of a .rms tag in one of the seasons >>> .tmpl or .inc files. The seasons skin only uses the .rms tag with the >>> WeeWX wind field. As Tom indicated .rms only works against the wind >>> field, if your changes have used the .rms tag against another field >>> then this could be the cause. I suggest you go through all of your changes >>> to the seasons skin files and see what fields are being used with the >>> .rms tag. Until we know for sure, and given you seem to have made >>> changes to the skin, we will likely be chasing our tails. >>> >>> Gary >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/weewx-user/LWmSpcVfdmo/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
