Thanks Mathew The code change has been done database checked first then purged.........................appears to have done the trick. fyi.....just a couple of rather old entries
sqlite> select dateTime, datetime(dateTime,'unixepoch','localtime'), interval from archive WHERE interval <= 0 order by dateTime; 1508786399|2017-10-24 05:19:59|0 1508935799|2017-10-25 22:49:59|0 sqlite> On Sun, 19 May 2019 at 19:22, mwall <[email protected]> wrote: > you must also purge your database of any non-positive values for > 'interval'. as tom posted in this thread: > > https://groups.google.com/d/msg/weewx-user/69RvQnD_OQc/ZyF0_jZqAwAJ > > > You may have to install the tool sqlite3, if you haven't already: > *sudo apt-get install sqlite3* > > Then delete any non-positive values: > *sudo sqlite3 /var/lib/weewx/weewx.sdb* > sqlite> *delete from archive where interval <= 0;* > > > > m > > -- > 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/739d93c6-616f-4db4-8458-46914e6c51b3%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/739d93c6-616f-4db4-8458-46914e6c51b3%40googlegroups.com?utm_medium=email&utm_source=footer> > . > 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAN84nRvixFfC9cmADoiCPOGdJ0jYF2VUC5XWi3xGPk9u9vOQ-A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
