OK, thanks, I'll check that tonight. On Tue, Nov 21, 2017 at 1:51 PM, gjr80 <[email protected]> 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 <[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/to >>> pic/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 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.
