I'm not in front of the machine at the moment, but I did check the most
recent time, and it matched the current time.

from memory:

select max(timeDate) from archive;

which I then converted to a readable form (with R). It was definitely
today, not the stuck date of 3 days ago.

Mysterious!

On Tue, Nov 21, 2017 at 12:18 PM, gjr80 <[email protected]> wrote:

> On Tuesday, 21 November 2017 07:27:15 UTC+10, Richard Beare wrote:
>>
>>
>> At this point I'm starting to think I need to reinstall, but I hope I'm
>> missing something basic.
>>
>>
> Don't go doing this, it is seldom required and is usually a waste of your
> and our time. If forcing regeneration by deletion has not helped then I
> would have a look at what is in your database, are you getting current data
> in there or not? Assuming you are using SQLite and not MySQL try the
> following (assumes sqlite3 is installed, if not you need something like sudo
> apt-get install sqlite3 to install it, also change paths to suit your
> install):
>
> $ sqlite3 /home/weewx/archive/weewx.sdb
> sqlite> SELECT STRFTIME('%d-%m-%Y %H:%M:%S', datetime(dateTime,
> 'unixepoch')), outTemp FROM archive ORDER BY dateTime DESC LIMIT 20;
> sqlite> .quit
>
> What does the SQLite query return? This will show whether you in fact have
> current data being saved to archive or not.
>
> 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/Qkb5l9fjk9Q/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.

Reply via email to