Most likely, your database includes records with timestamps of zero, or near zero. In turn, this is usually caused by not having a real-time clock: the computer dumbly sets the clock to zero unix epoch time, which is 1 January 1970, on startup.
You need to fix two things: 1. Make sure your computer is synchronized with a definitive time source before starting weewx. This is best done by using a real-time clock, then running NTP, or another time synchronization utility. See the Wiki guide on *Running WeeWX on a Raspberry <https://github.com/weewx/weewx/wiki/Raspberry-Pi>Pi*. Even if you do not have an RPi, the principles are the same. 2. Get rid of the bogus archive records. First, you'll have to find your database. If you used the package installer, it will be in /var/lib/weewx/weewx.sdb. If you used the setup.py method, it will be in /home/weewx/archive/weewx.sdb. Let's assume the former. # First install the utility sqlite3 if you don't already have it *sudo apt-get install sqlite3* # Back up the database: *cd /var/lib/weewx* *sudo cp weewx.sdb weewx.sdb.backup* # Use the utility sqlite3 to look at the database *sqlite3 weewx.sdb* # This will tell you how many records you have before 1 January 2000 sqlite> *count(dateTime) from archive where dateTime < 946684800;* # Delete them sqlite> *delete from archive where dateTime < 946684800;* sqlite> *.quit* # Now you need to drop the daily summaries. Use the utility wee_database to do this: *sudo wee_database --drop-daily* The daily summaries will automatically be rebuilt the next time your run weewxd. See if that helps. -tk On Thu, Aug 6, 2020 at 1:51 PM Chris Martino <[email protected]> wrote: > Howdy! > > First time poster, so please be gentle if this has been asked before. My > search results turned up nada, so here I am! > > Sometime within the past few weeks my NOAA Reports have gone back in time > to December 31, 1969, as seen on my weewx site: > https://bridgewaterweather.com/reports > > The Dec. 31, 1969 date contains 1 entry with some bogus data for "AVG WIND > SPEED", "HIGH", "TIME" and "DOM DIR". > > Is it possible to clear this data so my reports don't go back 51 years? > > Thanks! > > Chris > > -- > 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/0f79940a-68a5-4968-a2c1-ffdd21a9a0d5n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/0f79940a-68a5-4968-a2c1-ffdd21a9a0d5n%40googlegroups.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/CAPq0zEDQDVD3URzJTCUZA9TGe_D912wQw-ja6dans30wOA82zw%40mail.gmail.com.
