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] <javascript:>> > 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] <javascript:>. >> 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.
