The "sudo" only applies to the first command (echo), not the second (sqlite3). Try running interactively:
*sudo -i* *echo "UPDATE archive SET rain=NULL WHERE (rain >0);" | sqlite3 backup.sdb* On Sun, Feb 24, 2019 at 10:39 AM V. Kelly Bellis <[email protected]> wrote: > Hello, > > Closely following the outlined procedures at > Cleaning up old 'bad' data > <https://github.com/weewx/weewx/wiki/Cleaning-up-old-%27bad%27-data> > > After first stopping weewx, making a copy of the weewx.sdb, I'm trying to > clean out all rainRate and rain values greater than 0 on my RPi 3B+ > running Raspbian Linux 9 (stretch) [4.14.98-v7+], but have run into a wee > snag: > > [image: read only db.PNG] > > > Any advice will be much appreciated. > > Kind regards, > > Kelly > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
