that worked!!! Thanks! On Monday, October 9, 2023 at 11:03:17 PM UTC-5 [email protected] wrote:
> Try > echo "UPDATE archive SET rainRate=NULL WHERE (rainRate > 10);" | sudo > sqlite3 /var/tmp/backup.sdb > > jeremeyi schrieb am Dienstag, 10. Oktober 2023 um 06:01:59 UTC+2: > >> sudo echo "UPDATE archive SET rainRate=NULL WHERE (rainRate > 10);" | >> sqlite3 /var/tmp/backup.sdb >> >> On Monday, October 9, 2023 at 11:00:19 PM UTC-5 [email protected] >> wrote: >> >>> What exactly did you type when you say: >>> > I have tried with sudo with the same results >>> >>> jeremeyi schrieb am Dienstag, 10. Oktober 2023 um 05:43:20 UTC+2: >>> >>>> I am trying to get rid of a couple of rain rate errors in my database >>>> using the guide here >>>> >>>> https://github.com/weewx/weewx/wiki/Cleaning%20up%20old%20'bad'%20data >>>> >>>> when I run >>>> echo "SELECT * FROM archive WHERE (rainRate > 10);" | sqlite3 >>>> /var/tmp/backup.sdb >>>> >>>> it shows the two records I need to get rid of but when I run >>>> >>>> echo "UPDATE archive SET rainRate=NULL WHERE (rainRate > 10);" | >>>> sqlite3 /var/tmp/backup.sdb >>>> >>>> it says Error: near line 1: attempt to write a readonly database. I >>>> have tried with sudo with the same results >>>> >>>> >>> -- 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/539603b8-cc4b-4d78-a141-c76d3fa5989fn%40googlegroups.com.
