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/065f218a-4a09-4f77-80fa-26b558a9d517n%40googlegroups.com.

Reply via email to