Trying to eliminate bad data

[Steve2Q]

Hi..I followed the instructions here:  https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data

First, I shut down Weewx and made a copy of my weewx.sdb file. When I tried to change the bad data (on the copy) to NULL, I received an sqlite3 error that I could not write to a read-only file. I thought that weewx.sdb allowed writing, so why would a copy turn into read-only?

Thanks.

[vince]

Because it's owned by root and you tried to do your editing as the non-privileged 'pi' user ?

[Steve2Q]

I did use sudo in front of the UPDATE command, but I guess this is not sufficient?

Steve

[vince]

You're going to have to give us a transcript of what you did, and what you saw.

You need to do "sudo sqlite3" which I'm guessing you did not do.

[Steve2Q]

Vince..thanks. I solved the problem by starting with sudo su. Haven't done any LInux in quite a while so I forgot about that one. Another question: I am thinking of adding lines to [StdQC] to eliminate any outHumidity values <20. By doing this, will it also take care of the calculated dewpoint and heat index values, or will I need separate entries for each?

Thanks.