Well, this is embarrassing. Data is going in, and timestamp is appropriate:
SELECT dateTime, outTemp FROM archive ORDER BY dateTime DESC LIMIT 20;
1511253600|84.08
as.POSIXct(1511253600, origin = "1970-01-01")
[1] "2017-11-21 19:40:00 AEDT"
Repeated refresh of page from chrome, and restarts of chrome didn't change
the image in the web page. But using a different browser and viewing the
graph images manually showed that they're actually OK. Explicitly clearing
the image cache in chrome eventually did the trick.
I'll go and hide now...
Thanks for all the prompt help.
On Tue, Nov 21, 2017 at 4:00 PM, Richard Beare <richard.be...@gmail.com>
wrote:
> Have done the refreshing, but not separate viewing. Will confirm.
> Thanks
>
> On Tue, Nov 21, 2017 at 3:51 PM, Andrew Milner <
> andrew.s.r.mil...@gmail.com> wrote:
>
>> An obvious one - but it's caught me out before - have you forced a page
>> reload in the browser and/or have you viewed the .png file directly via a
>> file explorer?
>>
>> On Tuesday, 21 November 2017 05:16:42 UTC+2, Richard Beare wrote:
>>>
>>> OK, thanks, I'll check that tonight.
>>>
>>> On Tue, Nov 21, 2017 at 1:51 PM, gjr80 <gjrod...@gmail.com> wrote:
>>>
>>>> max(dateTime) will just show you the most recent archive record
>>>> timestamp, what we need to see is whether there is any observational data
>>>> being recorded in the archive. It is quite possible that no observational
>>>> data is being recorded for some reason and hence the generated plots show
>>>> no data. Weekly and greater plots display some form of aggregate data so
>>>> they may well still show something whilst the daily plot does not.
>>>>
>>>> Gary
>>>>
>>>> On Tuesday, 21 November 2017 11:37:17 UTC+10, Richard Beare wrote:
>>>>>
>>>>> 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 <gjrod...@gmail.com> 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/to
>>>>>> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe.
>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>> weewx-user+...@googlegroups.com.
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>>
>>>>> --
>>>> 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/to
>>>> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to
>>>> weewx-user+...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>> 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/to
>> pic/weewx-user/Qkb5l9fjk9Q/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> weewx-user+unsubscr...@googlegroups.com.
>> 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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
