Ah ha... you're right... and then things make sense, because indeed I don't have the output temperature for those dates. So, the curve are correctly generated. Now I need to figure out why I had no data at that time, knowing that I had no sensor error warning in the logs...
sqlite> select datetime(dateTime,'unixepoch', 'localtime'),outTemp from archive where dateTime > 1692553600 and dateTime < 1692593600; 2023-08-20 19:50:00|31.75 2023-08-20 19:55:00|31.6481481481481 2023-08-20 20:00:00|31.6111111111111 2023-08-20 20:05:00|31.462962962963 2023-08-20 20:10:00|31.3333333333333 ... 2023-08-21 00:00:00| 2023-08-21 00:05:00| 2023-08-21 00:10:00| 2023-08-21 00:15:00| 2023-08-21 00:20:00| 2023-08-21 00:25:00| 2023-08-21 00:30:00| 2023-08-21 00:35:00| 2023-08-21 00:40:00| 2023-08-21 00:45:00| 2023-08-21 00:50:00| 2023-08-21 00:55:00| 2023-08-21 01:00:00| 2023-08-21 01:05:00| 2023-08-21 01:10:00| 2023-08-21 01:15:00| 2023-08-21 01:20:00| 2023-08-21 01:25:00| 2023-08-21 01:30:00| 2023-08-21 01:35:00| On Wednesday, August 23, 2023 at 2:44:22 PM UTC+2 gjr80 wrote: > The missing data in your plot is from midnight 20 August through until > just after sunrise on 21 August not from 22 August as per your database > extract. Try dropping each timestamp in your query by 86400. > > Gary > > On Wednesday, 23 August 2023 at 21:55:29 UTC+10 [email protected] > wrote: > >> Hi, >> There's something strange, and I'd like your help to debug the issue. >> The *outside temperature curve* of my weather station has *a cut during >> the night of Aug 21 and Aug 22*. *But*, to my understanding, *the data >> exists in the SQLite database*! >> Why? >> How can I trigger the curve to be re-generated ? >> [image: weektempdew.png] >> >> This is the content of the database. I cut off some of the long output, >> but you can see I always have an outside temperature. No error. >> >> select datetime(dateTime,'unixepoch', 'localtime'),outTemp from archive >> where dateTime > 1692640000 and dateTime < 1692680000; >> ... >> 2023-08-21 23:00:00|28.1666666666667 >> 2023-08-21 23:05:00|28.1666666666667 >> 2023-08-21 23:10:00|28.25 >> 2023-08-21 23:15:00|28.2222222222222 >> 2023-08-21 23:20:00|28.1111111111111 >> 2023-08-21 23:25:00|28.0 >> 2023-08-21 23:30:00|28.0 >> 2023-08-21 23:35:00|28.0 >> 2023-08-21 23:40:00|28.0 >> 2023-08-21 23:45:00|28.0 >> 2023-08-21 23:50:00|27.8888888888889 >> 2023-08-21 23:55:00|27.8888888888889 >> 2023-08-22 00:00:00|28.1666666666667 >> 2023-08-22 00:05:00|28.3055555555556 >> 2023-08-22 00:10:00|28.1481481481481 >> 2023-08-22 00:15:00|28.1666666666667 >> 2023-08-22 00:20:00|28.4444444444444 >> 2023-08-22 00:25:00|28.1666666666667 >> 2023-08-22 00:30:00|27.8888888888889 >> 2023-08-22 00:35:00|28.1111111111111 >> 2023-08-22 00:40:00|28.25 >> 2023-08-22 00:45:00|28.4259259259259 >> 2023-08-22 00:50:00|28.4444444444444 >> 2023-08-22 00:55:00|28.3888888888889 >> 2023-08-22 01:00:00|28.8055555555556 >> 2023-08-22 01:05:00|28.0740740740741 >> 2023-08-22 01:10:00|27.1666666666667 >> 2023-08-22 01:15:00|27.2777777777778 >> 2023-08-22 01:20:00|27.1111111111111 >> 2023-08-22 01:25:00|27.3055555555556 >> 2023-08-22 01:30:00|27.3703703703704 >> 2023-08-22 01:35:00|26.9444444444444 >> 2023-08-22 01:40:00|26.8518518518519 >> 2023-08-22 01:45:00|26.7777777777778 >> 2023-08-22 01:50:00|26.8518518518519 >> 2023-08-22 01:55:00|26.75 >> 2023-08-22 02:00:00|26.6481481481481 >> 2023-08-22 02:05:00|26.6111111111111 >> 2023-08-22 02:10:00|26.3888888888889 >> 2023-08-22 02:15:00|26.2222222222222 >> 2023-08-22 02:20:00|26.1666666666667 >> 2023-08-22 02:25:00|26.2962962962963 >> 2023-08-22 02:30:00|26.25 >> ... >> >> >> - Weewx 4.10.2 on a Raspberry Pi >> - Actually I have the same problem on outside humidity and barometer. >> >> >> -- 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/46ba20ee-ce0d-4b6b-a7ef-7fe9e7692cd0n%40googlegroups.com.
