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/59d17128-0e6c-415a-a754-08daa7c87e3en%40googlegroups.com.
