I would suggest: a) stop weewx b) take a copy of database c) sort out any bad data in archive table - not in archive_day_rain table. set any unwanted rain to 0
d) drop daily tables with database utility e) rebuild daily tables with database utility f) delete all noaa files (they will be rebuilt on first report cycle) g) restart weewx On Sunday, 24 November 2019 13:55:56 UTC+2, Chris Thompstone wrote: > > just trying something: > echo "SELECT * FROM archive_day_rain WHERE (sum > 4);" | sqlite3 > weewx.sdb.old2 > if I do this, it brings up the rows with big sums. > can I just do this: > > echo "UPDATE archive_day_rain SET sum=NULL WHERE (sum > 4);" | sqlite3 > weewx.sdb.old2 > > or will that not work? maybe sum=0 is better? > > 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/64d812e7-4f2a-416d-ba61-155fcd696061%40googlegroups.com.
