do you use phpliteadmin to browse the database or do you just retrieve records using sqlite3?
only you can determine the datetime of the last good archive record - let us say it is 987654321 then to delete all records later than that use sqlite 3 delete from archive where dateTime > 987654321; would delete additional archive records then to sort out the daily summaries use wee_database to 1) drop daily 2) rebuild daily if your NOAA summary data is looking corrupted just delete the NOAA files and weewx will recreate them on the next report cycle. On Monday, 8 July 2019 16:08:40 UTC+3, Eric Gammeter wrote: > > Still at this... Is there any way to determine the last-good db record > and then delete everything after that in order to salvage my WX year > history? > > > root@raspberrypi:/var/lib/weewx# /etc/init.d/weewx status > ● weewx.service - LSB: weewx weather system > Loaded: loaded (/etc/init.d/weewx; generated; vendor preset: enabled) > Active: active (exited) since Mon 2019-07-08 08:52:59 EDT; 10min ago > Docs: man:systemd-sysv-generator(8) > Process: 2872 ExecStop=/etc/init.d/weewx stop (code=exited, > status=0/SUCCESS) > Process: 3049 ExecStart=/etc/init.d/weewx start (code=exited, > status=0/SUCCESS) > > Jul 08 08:53:00 raspberrypi weewx[3064]: **** File > "/usr/share/weewx/weewx/engine.py", line 142, in loadServices > Jul 08 08:53:00 raspberrypi weewx[3064]: **** > self.service_obj.append(weeutil.weeutil._get_object(svc)(self, config_dict)) > Jul 08 08:53:00 raspberrypi weewx[3064]: **** File > "/usr/share/weewx/weewx/engine.py", line 500, in __init__ > Jul 08 08:53:00 raspberrypi weewx[3064]: **** > self.setup_database(config_dict) > Jul 08 08:53:00 raspberrypi weewx[3064]: **** File > "/usr/share/weewx/weewx/engine.py", line 617, in setup_database > Jul 08 08:53:00 raspberrypi weewx[3064]: **** _nrecs, _ndays = > dbmanager.backfill_day_summary() # @UnusedVariable > Jul 08 08:53:00 raspberrypi weewx[3064]: **** File > "/usr/share/weewx/weewx/manager.py", line 1447, in backfill_day_summary > Jul 08 08:53:00 raspberrypi weewx[3064]: **** > timestamp_to_string(lastRecord))) > Jul 08 08:53:00 raspberrypi weewx[3064]: **** ViolatedPrecondition: > lastUpdate(2036-08-06 20:22:00 EDT (2101681320)) > lastRecord(2019-07-01 > 00:00:00 EDT (1561953600)) > Jul 08 08:53:00 raspberrypi weewx[3064]: **** Exiting. > root@raspberrypi:/var/lib/weewx# > > > > > > > > > > > On Friday, July 5, 2019 at 3:58:01 PM UTC-4, Eric Gammeter wrote: >> >> Hi- My INDEX.HTML file is being produced each half hour as it should >> be...but the timestamp (in the file) is incorrect! The report (attached) >> shows it is 8/6/2036 @ 08:22:00PM. >> >> I can see that the reports fire off every 30 mins- and that a new >> (correct time stamp) INDEX.HTML file is created in the /var/www/html/weewx >> filesystem-- but that file's info is incorrect. >> >> I tested (with minicom) and that TEST's fine. >> >> I have shutdown and rebooted the VantageVue station to no avail. >> >> Thanks for reading! >> >> /Eric >> > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/c8efbf47-494f-4286-b926-ef573eb4a140%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
