You are of course 100% correct sir! Thanks very much, I knew it would be something simple.
Colin On Thu, 15 Nov 2018, 18:26 gjr80 <gjroder...@gmail.com wrote: > Hi, > > When you tried sudo exactly what command did you use? The correct > placement of sudo would be: > > $ echo "UPDATE archive SET windGust=NULL WHERE (windGust > 100);" | > sudo sqlite3 /var/lib/weewx/tmp/weewxback.sdb > > Gary > > On Thursday, 15 November 2018 14:20:33 UTC+10, Colin Larsen wrote: >> >> Hi all >> >> I know this is a simple fix but my sql/linux skills need a hand. >> >> I'm trying to get rid of errant data in windGust using the example in >> Github. >> >> I copied the weewx.sdb file to /var/lib/weewx/tmp (after creating tmp), >> and ran the commands below with an "unable to open database file error". >> Did a chmod 666 thinking it might be permissions but still no go. Also >> tried sudo. What did I miss? >> >> *pi@raspberrypi*:*/var/lib/weewx/tmp $* ls -l >> >> total 1180 >> >> -rw-rw-rw- 1 root root 1208320 Nov 15 17:07 weewxback.sdb >> >> *pi@raspberrypi*:*/var/lib/weewx/tmp $* echo "UPDATE archive SET >> windGust=NULL WHERE (windGust > 100);" | sqlite3 >> /var/lib/weewx/tmp/weewxback.sdb >> >> Error: near line 1: unable to open database file >> >> *pi@raspberrypi*:*/var/lib/weewx/tmp $* >> > -- > 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 weewx-user+unsubscr...@googlegroups.com. > 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.