Thanks Gary, I found the source of my issue, I was logging the output of my putty session to a file in case I needed to put the steps taken on here as per your suggestions. To show exactly what and where i was editing i did a "locate" command on the weewx.sdb file and only then realised I was editing the wrong one, I was actually editing an old backup in the wrong location, hense it not working! Doh!
Thanks for offering to help, you already did in a roundabout way in the end! On Friday, April 3, 2020 at 4:20:20 PM UTC+1, Muireadach O Connor wrote: > > Hi guys, > > I'm struggling to understand what I'm doing wrong here. > > I want to remove a daily reading of 134mm rain from February 2013 as its > bothering me in my records page. I had cleaned the rain gauge that day and > never got around to correcting it. > I'd previously amended a max rainRate figure from the database without too > much issue so thought this would be the same but its proving much more > troublesome. > > I removed it using : > > update archive set rain=NULL where rain > 4; (db in imperial) > > Next made a new copy of this new database > > Then.. > > sudo wee_database --drop-daily > sudo wee_database weewx.conf --rebuild-daily > > then ran : > > wee_reports --config=/etc/weewx/weewx.conf > > However the records webpage on my pi (reports folder) in still showed the > old value in there. > > At this stage I figured maybe its cached in memory so stopped the WeeWX > service and restarted the raspberry pi > > Now the old value is back in the database again (/shakes fist at cloud) > I've looked at my amended copy and the latest one and the old maximum > daily reading is definitely back and definitely was removed. > > I'm guessing this is being pulled from the console somehow, should I have > cleared it also there also before restarting? > If not, anyone any ideas how to fix this? > > -- 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/520ab5e9-03a8-461d-802f-12550449d5d1%40googlegroups.com.