OK It would appear I have somehow mucked it up.. Station hadnt updated in 4 days so did a wee_device --clear which regenerated a current time and values but still does not update anymore and the offending record is still there.. At a loss.....
On Thursday, 27 September 2018 22:59:26 UTC+12, Glenn F wrote: > > > Ok that line of code was far better to establish the error, thanking you. > ,, I have performed the guide from " Clean Up Old Bad Data" and finger > crossed that when it recycles the update it will be repaired,, Toes > crossed too.... > > > On Tuesday, 25 September 2018 23:30:11 UTC+12, Thomas Keffer wrote: >> >> It's hard to read, but that's probably right. You can confirm my just >> selecting the most relevant columns. Try this for your SELECT statement: >> >> echo "SELECT dateTime, datetime(dateTime,'unixepoch','localtime'), >> rainRate from archive where rainRate > 100;" | sqlite3 >> /var/tmp/datbasebu/weewx.sdb >> >> This print out just timestamps, the local time, and rain rates. Easier to >> read. >> >> -tk >> >> On Tue, Sep 25, 2018 at 3:12 AM Glenn F <[email protected]> wrote: >> >>> >>> 1. Cheers Thomas,.... if you have time to view the attched imge and >>> see if I'm in the right direction,.. I got swamped in numbers,, love a >>> little clarification... >>> >>> >>> On Monday, 24 September 2018 23:30:50 UTC+12, Thomas Keffer wrote: >>>> >>>> Hello, Glenn >>>> >>>> See the Wiki entry Clean up old "bad" data >>>> <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data> and >>>> see if that doesn't answer your question. If not, come back and we'll dig >>>> in deeper. >>>> >>>> -tk >>>> >>>> On Mon, Sep 24, 2018 at 12:38 AM Glenn F <[email protected]> wrote: >>>> >>>>> It has probably been asked, and if so point me in the direction >>>>> please. I'd love to delete this record, I never built an ark nor got >>>>> flooded out, so would love this to show the actual , real, value.. >>>>> >>>>> Running a FineOffsetUSB system . >>>>> >>>>> Glenn.. >>>>> >>>>> -- >>>>> 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. >>> >> -- 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.
