Andrew I am not the same guy that posted on the other thread. I think I have the same (original) problem as he did with corrupt minimum temperatures throwing off the weewx engine. I hope it gets resolved by the instructions you gave. On the sudo issue, I have been working as root all along.
Roberto On Thursday, December 13, 2018 at 2:41:46 PM UTC, Andrew Milner wrote: > > Am intrigued to know the result. After rereading the other thread you > referenced I assume that this time you used sudo for drop daily whereas on > the previous occasion you did not - is that correct?? > > > > On Thursday, 13 December 2018 16:29:33 UTC+2, Roberto Botero wrote: >> >> Andrew >> >> I used some of the posts in the thread I just cited and went looking for >> very negative temperature minima in other tables in addition to outTemp: >> archive_day_windchill and archive_day_dewpoint. I found records with bad >> minima in both and replaced them NULL. >> I have dropped the daily tables, checked that they were empty and am now >> rebuilding them. >> Let's see if this works. >> >> Roberto >> >> On Thursday, December 13, 2018 at 1:25:19 PM UTC, Roberto Botero wrote: >>> >>> Hi Andrew >>> >>> Yes, have done both --drop and --rebuild as per the procedure in the >>> link I provided. I am going through the replies in this post of earlier >>> https://groups.google.com/forum/#!topic/weewx-user/fZtyq_cTyZ4 where >>> you helped a lot! >>> I think I have the same issue. >>> >>> Roberto >>> >>> On Thursday, December 13, 2018 at 12:49:30 PM UTC, Andrew Milner wrote: >>>> >>>> did you drop daily and rebuild daily after updating the archive?? >>>> >>>> if you did not do that try it (stop weewx first of course!!) >>>> >>>> >>>> >>>> >>>> >>>> On Thursday, 13 December 2018 13:03:21 UTC+2, Roberto Botero wrote: >>>>> >>>>> And for completeness the NOAA data for December this year shows the >>>>> offending dates. Is there a way to just delete those records from the >>>>> database and get things up and running again? >>>>> >>>>> MONTHLY CLIMATOLOGICAL SUMMARY for Dec 2018 >>>>> >>>>> >>>>> NAME: Petts Wood, Kent, England >>>>> ELEV: 79 meter LAT: 51-23.38 N LONG: 000-04.95 E >>>>> >>>>> >>>>> TEMPERATURE (°C), RAIN (mm), WIND SPEED (m/s) >>>>> >>>>> HEAT COOL AVG >>>>> MEAN DEG DEG WIND >>>>> DOM >>>>> DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH >>>>> TIME DIR >>>>> --------------------------------------------------------------------------------------- >>>>> 01 10.2 12.6 16:25 6.9 01:40 4.3 0.0 4.3 0.6 6.3 >>>>> 12:20 254 >>>>> 02 13.4 14.8 12:25 11.8 00:05 2.6 0.0 2.3 1.2 7.2 >>>>> 09:55 252 >>>>> 03 10.3 13.7 11:55 3.6 00:00 4.3 0.0 3.0 0.8 8.5 >>>>> 12:05 251 >>>>> 04 4.5 7.6 14:10 0.8 08:15 7.5 0.0 1.0 0.0 1.8 >>>>> 20:25 248 >>>>> 05 10.1 12.3 13:55 5.5 00:30 4.4 0.0 3.6 0.4 5.4 >>>>> 12:50 236 >>>>> 06 11.6 12.8 23:15 10.0 02:55 3.5 0.0 0.0 0.9 7.2 >>>>> 16:35 258 >>>>> 07 9.9 13.0 02:30 6.5 20:25 4.5 0.0 6.3 1.4 9.4 >>>>> 06:25 253 >>>>> 08 9.4 11.4 14:10 7.6 00:05 4.8 0.0 4.6 1.8 8.9 >>>>> 02:50 257 >>>>> 09 8.5 9.8 06:25 5.3 22:25 5.3 0.0 1.5 0.6 8.9 >>>>> 03:15 252 >>>>> 10 7.0 8.7 13:15 5.6 00:20 6.1 0.0 0.0 0.1 3.1 >>>>> 01:45 245 >>>>> 11 4.0 8.5 13:35 -67.8 08:15 7.8 0.0 0.3 0.0 2.2 >>>>> 22:25 105 >>>>> 12 4.1 6.8 02:00 -67.8 05:25 7.7 0.0 0.0 0.2 4.5 >>>>> 14:05 103 >>>>> 13 2.2 2.5 01:05 1.5 02:05 8.8 0.0 0.0 0.3 3.1 >>>>> 00:05 112 >>>>> 14 >>>>> 15 >>>>> 16 >>>>> 17 >>>>> 18 >>>>> 19 >>>>> 20 >>>>> 21 >>>>> 22 >>>>> 23 >>>>> 24 >>>>> 25 >>>>> 26 >>>>> 27 >>>>> 28 >>>>> 29 >>>>> 30 >>>>> 31 >>>>> --------------------------------------------------------------------------------------- >>>>> 8.6 14.8 02 -67.8 11 71.6 0.0 26.9 0.7 9.4 >>>>> 07 253 >>>>> >>>>> >>>>> Thanks >>>>> >>>>> >>>>> Roberto >>>>> >>>>> -- 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.