select * from archive_day_windGust where dateTime = 1688565600; +------------+------+------------+----------------+------------+-------------------+-------+--------------------+---------+ | dateTime | min | mintime | max | maxtime | sum | count | wsum | sumtime | +------------+------+------------+----------------+------------+-------------------+-------+--------------------+---------+ | 1688565600 | 0 | 1688566200 | 81.90000006552 | 1688648400 | 635.3000005082397 | 288 | 190590.00015247212 | 86400 | +------------+------+------------+----------------+------------+-------------------+-------+--------------------+---------+
date -d@1688565600 Thu 06 Jul 2023 00:00:00 AEST Maxtime: date -d@1688648400 Thu 06 Jul 2023 23:00:00 AEST The max is 81.9 and not 295? On Fri, 7 Jul 2023 at 12:05, Greg Reive <[email protected]> wrote: > I only have the one database. > It is very strange that I can't even find the high wind record. > I will keep looking. > > On Fri, 7 July 2023, 12:02 Tom Keffer, <[email protected]> wrote: > >> If you did all those things, the only thing I can think of is that you >> may not be working on the database you think you're working on. >> >> >> On Thu, Jul 6, 2023 at 5:58 PM Greg from Oz <[email protected]> wrote: >> >>> I have a windGust reading spike of 295kph and I cannot find it in the >>> database. >>> 295 km/h from N/A (N/A) at 06/07/23 23:00:00 >>> >>> select dateTime, windGust from archive where (windGust > 100); >>> Returned nothing. >>> >>> I deleted the record for that date and time in the mysql database: >>> delete from archive where dateTime = 1686142800; >>> >>> I dropped the daily records and rebuilt them. >>> wee_database /opt/weewx/weewx-data/weewx.conf --drop-daily >>> wee_database /opt/weewx/weewx-data/weewx.conf --rebuild-daily >>> >>> I deleted the daywind.png file as well >>> >>> It is still there: >>> >>> [image: Screenshot from 2023-07-07 10-53-10.png] >>> >>> This has me stumped...... >>> >>> I have been able to fix up wrong rain readings before and that worked >>> but this wind record is not working the same way. >>> >>> Any ideas? >>> >>> >>> >>> -- >>> 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/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com >>> <https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- >> 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/OcVhlHxEvHI/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com >> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> > -- ¯\_(ツ)_/¯ -- 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/CAD_tbc-rxfz7xH9Tun5cYjr-Abso8gP4qVPV9pdhCw5GNQcV-w%40mail.gmail.com.
