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/c2c6d3a0-ed6c-4afc-a6b5-5b1bcdb6302cn%40googlegroups.com.
