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 [email protected]. For more options, visit https://groups.google.com/d/optout.
