if you are in the correct directory use ./wee_database ...... or specify the full path eg /home/weewx/bin/wee_database ........
or maybe you need to use sudo On Friday, 13 April 2018 19:47:28 UTC+3, stef 942 wrote: > thks for yr help, i follow yr guide to cleanup database : > > > pi@raspberrypi:~ $ echo "SELECT * FROM archive WHERE (rain < 0);" | > sqlite3 /var/tmp/backup.sdb > > 1523516100|1|5|29.405696969085|29.0870376875|29.0870376875|67.3666666666667|48.416|37.0|80.0|0.937794853313016|21.6687231304882|2.46063603713324|22.5|0.0|-15.3|42.5342303732686|48.416|48.416|||0.0||49.82|||||||||75.75||||||||||||||||1.0|1.0|1.0| > > 1523623500|1|5|29.6939319716336|29.3823375625|29.3823375625|70.4042857142857|65.12|41.7142857142857|57.5|2.13441535039209|55.6672765639842|3.13171859271503||0.0|-0.08|49.7270271335126|65.12|65.12|||0.0|67.928|||||||||72.2|||||||||||||||||0.0|0.0|0.0| > then > pi@raspberrypi:~ $ echo "UPDATE archive SET windSpeed=NULL WHERE (rain < > 0);" | sqlite3 /var/tmp/backup.sdb > pi@raspberrypi:~ $ echo "SELECT * FROM archive WHERE (rain < 0);" | > sqlite3 /var/tmp/backup.sdb > > 1523516100|1|5|29.405696969085|29.0870376875|29.0870376875|67.3666666666667|48.416|37.0|80.0||21.6687231304882|2.46063603713324|22.5|0.0|-15.3|42.5342303732686|48.416|48.416|||0.0||49.82|||||||||75.75||||||||||||||||1.0|1.0|1.0| > > 1523623500|1|5|29.6939319716336|29.3823375625|29.3823375625|70.4042857142857|65.12|41.7142857142857|57.5||55.6672765639842|3.13171859271503||0.0|-0.08|49.7270271335126|65.12|65.12|||0.0|67.928|||||||||72.2|||||||||||||||||0.0|0.0|0.0| > > but got this : > > pi@raspberrypi:~ $ wee_database weewx.conf --drop-daily > -bash: wee_database: command not found > >> >> -- 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.
