Re: [weewx-user] Re: negative value in rain display

2018-04-13 Thread Andrew Milner 
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.36667|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.751.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.36667|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.751.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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: negative value in rain display

2018-04-13 Thread stef 942 
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.36667|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.751.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.36667|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.751.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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [weewx-user] Re: negative value in rain display

2018-04-13 Thread Thomas Keffer 
See the Wiki: *Cleaning up old 'bad' data
*.

-tk

On Fri, Apr 13, 2018 at 1:38 AM, stef 942  wrote:

> ok now current display is ok but history not, how can i reset it? thanks
> for yr help
>
>
> Le vendredi 13 avril 2018 07:46:38 UTC+2, stef 942 a écrit :
>
>> Hi,
>>
>> yesterday i had a power failure, when i restart weewx it shows negative
>> value in rain display : my page 
>>
>> i tried to reset my station (WMR200) , i reset also the datalogger but
>> still same negative value :(
>>
>> i dont know what to do to reset rain values, can you help me please?
>> thanks.
>>
> --
> 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.