Because these are daily summaries, the value for dateTime will always be midnight. What you need is the time of the max, which is given by the field 'maxtime'.
SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), max, maxtime, datetime(maxtime, 'unixepoch', 'localtime') FROM archive_day_rainRate WHERE max > 100.0 ORDER BY dateTime DESC LIMIT 100; *Still need the log!* -tk On Thu, Feb 24, 2022 at 10:46 AM Luis <[email protected]> wrote: > Now with the rest of the columns for these values (max > 100) > I insist,* only at 00:00:00 every day* > > SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'),min, max, > sum, count, wsum, sumtime FROM archive_day_rainRate WHERE max > 100.0 LIMIT > 100; > > dateTime datetime (human) min max > sum count wsum sumtime > 1588975200 2020-05-09 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1589148000 2020-05-11 00:00:00 0 516.0236188995 > 0 47 0 84600 > 1589234400 2020-05-12 00:00:00 0 516.0236188995 > 0.6377952717 48 1148.03148906 86400 > 1589320800 2020-05-13 00:00:00 0 516.0236188995 > 0.8188976328 48 1474.01573904 86400 > 1589407200 2020-05-14 00:00:00 0 516.0236188995 > 4.8661417026 48 8759.055064680002 86400 > 1589493600 2020-05-15 00:00:00 0 516.0236188995 > 0.6141732246 48 1105.5118042800002 86400 > 1589580000 2020-05-16 00:00:00 0 516.0236188995 > 9.5511810441 48 17192.125879380004 86400 > 1589752800 2020-05-18 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1589839200 2020-05-19 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1589925600 2020-05-20 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590012000 2020-05-21 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590098400 2020-05-22 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590184800 2020-05-23 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590357600 2020-05-25 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590444000 2020-05-26 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590530400 2020-05-27 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590616800 2020-05-28 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590703200 2020-05-29 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590789600 2020-05-30 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1590876000 2020-05-31 00:00:00 0 516.0236188995 > 0.2913385809 48 524.40944562 86400 > 1590962400 2020-06-01 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1591048800 2020-06-02 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1592863200 2020-06-23 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1592949600 2020-06-24 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1594504800 2020-07-12 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1594591200 2020-07-13 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1594677600 2020-07-14 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1594764000 2020-07-15 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1594850400 2020-07-16 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1594936800 2020-07-17 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1595023200 2020-07-18 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1595109600 2020-07-19 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1595196000 2020-07-20 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1595282400 2020-07-21 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1595368800 2020-07-22 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1596232800 2020-08-01 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1596319200 2020-08-02 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1596405600 2020-08-03 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1596492000 2020-08-04 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1596578400 2020-08-05 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1596664800 2020-08-06 00:00:00 0 516.0236188995 > 0 48 0 86400 > 1596751200 2020-08-07 00:00:00 0 516.0236188995 > 0 128 0 84900 > 1596837600 2020-08-08 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1596924000 2020-08-09 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1597010400 2020-08-10 00:00:00 0 516.0236188995 > 0.9921259782 288 297.63779346 86400 > 1598306400 2020-08-25 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1598392800 2020-08-26 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1598479200 2020-08-27 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1598565600 2020-08-28 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1598652000 2020-08-29 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1598738400 2020-08-30 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1598997600 2020-09-02 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599084000 2020-09-03 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599170400 2020-09-04 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599256800 2020-09-05 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599343200 2020-09-06 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599429600 2020-09-07 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599516000 2020-09-08 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599602400 2020-09-09 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599688800 2020-09-10 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599775200 2020-09-11 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599861600 2020-09-12 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1599948000 2020-09-13 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600034400 2020-09-14 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600120800 2020-09-15 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600207200 2020-09-16 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600293600 2020-09-17 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600380000 2020-09-18 00:00:00 0 516.0236188995 > 1.9291338465 288 578.7401539499999 86400 > 1600466400 2020-09-19 00:00:00 0 516.0236188995 > 6.0551180733 288 1816.5354219900005 86400 > 1600552800 2020-09-20 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600725600 2020-09-22 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600812000 2020-09-23 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600898400 2020-09-24 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1600984800 2020-09-25 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601071200 2020-09-26 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601157600 2020-09-27 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601244000 2020-09-28 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601330400 2020-09-29 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601416800 2020-09-30 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601503200 2020-10-01 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601589600 2020-10-02 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601676000 2020-10-03 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601762400 2020-10-04 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601848800 2020-10-05 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1601935200 2020-10-06 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1602021600 2020-10-07 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1602108000 2020-10-08 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1602194400 2020-10-09 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1602280800 2020-10-10 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1603058400 2020-10-19 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1603144800 2020-10-20 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1603231200 2020-10-21 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1603317600 2020-10-22 00:00:00 0 516.0236188995 > 14.9685038457 287 4490.55115371 86100 > 1603404000 2020-10-23 00:00:00 0 516.0236188995 > 4.3700787135 288 1311.0236140500003 86400 > 1603753200 2020-10-27 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1603839600 2020-10-28 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1603926000 2020-10-29 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1604012400 2020-10-30 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1604098800 2020-10-31 00:00:00 0 516.0236188995 > 0 288 0 86400 > 1604185200 2020-11-01 00:00:00 0 516.0236188995 > 0 288 0 86400 > > > On Thursday, February 24, 2022 at 7:30:14 PM UTC+1 Luis wrote: > >> You are right. I gave no detailed information: >> >> Vantage Vue >> Raspberry Pi + Raspbian Buster >> >> Your query gives no records with rainRate > 100 (and no errors) >> >> sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), >> usUnits, rain, rainRate FROM archive WHERE rainRate > 100.0 LIMIT 100; >> sqlite> >> >> But I executed that query for the archive_day_rainRate table and you can >> see that impossible rainRate value: >> >> sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), >> max FROM archive_day_rainRate WHERE max > 100.0 LIMIT 100; >> 1588975200|2020-05-09 00:00:00|516.0236188995 >> 1589148000|2020-05-11 00:00:00|516.0236188995 >> 1589234400|2020-05-12 00:00:00|516.0236188995 >> 1589320800|2020-05-13 00:00:00|516.0236188995 >> 1589407200|2020-05-14 00:00:00|516.0236188995 >> 1589493600|2020-05-15 00:00:00|516.0236188995 >> 1589580000|2020-05-16 00:00:00|516.0236188995 >> 1589752800|2020-05-18 00:00:00|516.0236188995 >> 1589839200|2020-05-19 00:00:00|516.0236188995 >> 1589925600|2020-05-20 00:00:00|516.0236188995 >> 1590012000|2020-05-21 00:00:00|516.0236188995 >> 1590098400|2020-05-22 00:00:00|516.0236188995 >> 1590184800|2020-05-23 00:00:00|516.0236188995 >> 1590357600|2020-05-25 00:00:00|516.0236188995 >> 1590444000|2020-05-26 00:00:00|516.0236188995 >> 1590530400|2020-05-27 00:00:00|516.0236188995 >> 1590616800|2020-05-28 00:00:00|516.0236188995 >> 1590703200|2020-05-29 00:00:00|516.0236188995 >> 1590789600|2020-05-30 00:00:00|516.0236188995 >> 1590876000|2020-05-31 00:00:00|516.0236188995 >> 1590962400|2020-06-01 00:00:00|516.0236188995 >> 1591048800|2020-06-02 00:00:00|516.0236188995 >> 1592863200|2020-06-23 00:00:00|516.0236188995 >> 1592949600|2020-06-24 00:00:00|516.0236188995 >> 1594504800|2020-07-12 00:00:00|516.0236188995 >> 1594591200|2020-07-13 00:00:00|516.0236188995 >> 1594677600|2020-07-14 00:00:00|516.0236188995 >> 1594764000|2020-07-15 00:00:00|516.0236188995 >> 1594850400|2020-07-16 00:00:00|516.0236188995 >> 1594936800|2020-07-17 00:00:00|516.0236188995 >> 1595023200|2020-07-18 00:00:00|516.0236188995 >> 1595109600|2020-07-19 00:00:00|516.0236188995 >> 1595196000|2020-07-20 00:00:00|516.0236188995 >> 1595282400|2020-07-21 00:00:00|516.0236188995 >> 1595368800|2020-07-22 00:00:00|516.0236188995 >> 1596232800|2020-08-01 00:00:00|516.0236188995 >> 1596319200|2020-08-02 00:00:00|516.0236188995 >> 1596405600|2020-08-03 00:00:00|516.0236188995 >> 1596492000|2020-08-04 00:00:00|516.0236188995 >> 1596578400|2020-08-05 00:00:00|516.0236188995 >> 1596664800|2020-08-06 00:00:00|516.0236188995 >> 1596751200|2020-08-07 00:00:00|516.0236188995 >> 1596837600|2020-08-08 00:00:00|516.0236188995 >> 1596924000|2020-08-09 00:00:00|516.0236188995 >> 1597010400|2020-08-10 00:00:00|516.0236188995 >> 1598306400|2020-08-25 00:00:00|516.0236188995 >> 1598392800|2020-08-26 00:00:00|516.0236188995 >> 1598479200|2020-08-27 00:00:00|516.0236188995 >> 1598565600|2020-08-28 00:00:00|516.0236188995 >> 1598652000|2020-08-29 00:00:00|516.0236188995 >> 1598738400|2020-08-30 00:00:00|516.0236188995 >> 1598997600|2020-09-02 00:00:00|516.0236188995 >> 1599084000|2020-09-03 00:00:00|516.0236188995 >> 1599170400|2020-09-04 00:00:00|516.0236188995 >> 1599256800|2020-09-05 00:00:00|516.0236188995 >> 1599343200|2020-09-06 00:00:00|516.0236188995 >> 1599429600|2020-09-07 00:00:00|516.0236188995 >> 1599516000|2020-09-08 00:00:00|516.0236188995 >> 1599602400|2020-09-09 00:00:00|516.0236188995 >> 1599688800|2020-09-10 00:00:00|516.0236188995 >> 1599775200|2020-09-11 00:00:00|516.0236188995 >> 1599861600|2020-09-12 00:00:00|516.0236188995 >> 1599948000|2020-09-13 00:00:00|516.0236188995 >> 1600034400|2020-09-14 00:00:00|516.0236188995 >> 1600120800|2020-09-15 00:00:00|516.0236188995 >> 1600207200|2020-09-16 00:00:00|516.0236188995 >> 1600293600|2020-09-17 00:00:00|516.0236188995 >> 1600380000|2020-09-18 00:00:00|516.0236188995 >> 1600466400|2020-09-19 00:00:00|516.0236188995 >> 1600552800|2020-09-20 00:00:00|516.0236188995 >> 1600725600|2020-09-22 00:00:00|516.0236188995 >> 1600812000|2020-09-23 00:00:00|516.0236188995 >> 1600898400|2020-09-24 00:00:00|516.0236188995 >> 1600984800|2020-09-25 00:00:00|516.0236188995 >> 1601071200|2020-09-26 00:00:00|516.0236188995 >> 1601157600|2020-09-27 00:00:00|516.0236188995 >> 1601244000|2020-09-28 00:00:00|516.0236188995 >> 1601330400|2020-09-29 00:00:00|516.0236188995 >> 1601416800|2020-09-30 00:00:00|516.0236188995 >> 1601503200|2020-10-01 00:00:00|516.0236188995 >> 1601589600|2020-10-02 00:00:00|516.0236188995 >> 1601676000|2020-10-03 00:00:00|516.0236188995 >> 1601762400|2020-10-04 00:00:00|516.0236188995 >> 1601848800|2020-10-05 00:00:00|516.0236188995 >> 1601935200|2020-10-06 00:00:00|516.0236188995 >> 1602021600|2020-10-07 00:00:00|516.0236188995 >> 1602108000|2020-10-08 00:00:00|516.0236188995 >> 1602194400|2020-10-09 00:00:00|516.0236188995 >> 1602280800|2020-10-10 00:00:00|516.0236188995 >> 1603058400|2020-10-19 00:00:00|516.0236188995 >> 1603144800|2020-10-20 00:00:00|516.0236188995 >> 1603231200|2020-10-21 00:00:00|516.0236188995 >> 1603317600|2020-10-22 00:00:00|516.0236188995 >> 1603404000|2020-10-23 00:00:00|516.0236188995 >> 1603753200|2020-10-27 00:00:00|516.0236188995 >> 1603839600|2020-10-28 00:00:00|516.0236188995 >> 1603926000|2020-10-29 00:00:00|516.0236188995 >> 1604012400|2020-10-30 00:00:00|516.0236188995 >> 1604098800|2020-10-31 00:00:00|516.0236188995 >> 1604185200|2020-11-01 00:00:00|516.0236188995 >> >> The archive table does not contain strange values (result of your query >> is no records and no error is produced). >> On the other hand, the archive_day_rainRate table does contain that >> error for every day at 00:00:00 and only at that hour. >> >> On Thursday, February 24, 2022 at 6:17:47 PM UTC+1 [email protected] >> wrote: >> >>> I'm not sure what "contains a lot of data" means. Could you be more >>> specific? Many days? Just one? Is it in the archive table as well as the >>> daily summaries? We need to know if this is a one-time thing, or a chronic >>> issue. It would be helpful to see the main archive table. Assuming your >>> database is using US units (the default), then perhaps a query like this: >>> >>> SELECT dateTime, datetime(dateTime, 'unixepoch', 'localtime'), usUnits, >>> rain, rainRate FROM archive WHERE rainRate > 100.0 LIMIT 100; >>> >>> If the database does contain bad data, then it is a source problem, not >>> a reporting problem. >>> >>> I can't tell you where your log is, because you haven't said what kind >>> of operating system you are running on. See *Where to find things >>> <http://www.weewx.com/docs/usersguide.htm#Where_to_find_things>* for >>> likely locations. >>> >>> On Thu, Feb 24, 2022 at 8:59 AM Luis <[email protected]> wrote: >>> >>>> I can't my previous question about the log. I have sent the one I >>>> thought was produced by weewx with the debug option. >>>> Which one is the "full log"? >>>> >>>> >>>> On Thursday, February 24, 2022 at 5:06:55 PM UTC+1 [email protected] >>>> wrote: >>>> >>>>> It looks like the log has been filtered to show only debug statements. >>>>> Please post the full log. I need to see version numbers, conversion >>>>> targets, etc. >>>>> >>>>> It's nice to know that the database generally has reasonable rainRate >>>>> values, but the bad value you showed in veleta.png is the highest value >>>>> seen during some unknown day. I don't know which day because you didn't >>>>> show the full plot. What does the database show for that day? If you hover >>>>> a mouse over the value, it will show you the time of that max value. >>>>> That's >>>>> what we need from the database. >>>>> >>>>> -tk >>>>> >>>>> >>>>> On Thu, Feb 24, 2022 at 7:01 AM Luis <[email protected]> wrote: >>>>> >>>>>> Now the debug log file (I think this is the one you refer to) >>>>>> >>>>> >>>>>> >>>>>> On Thursday, February 24, 2022 at 3:36:02 PM UTC+1 Luis wrote: >>>>>> >>>>>>> Hi Tom, >>>>>>> I have followed your command on >>>>>>> https://www.mail-archive.com/[email protected]/msg33396.html >>>>>>> <https://www.mail-archive.com/[email protected]/msg33396.html> >>>>>>> and the result is the following: >>>>>>> >>>>>>> $ sqlite3 /var/lib/weewx/weewx.sdb >>>>>>> SQLite version 3.27.2 2019-02-25 16:06:06 >>>>>>> Enter ".help" for usage hints. >>>>>>> sqlite> select >>>>>>> ...> >>>>>>> dateTime,datetime(dateTime,'unixepoch','localtime'),rain,rainRate from >>>>>>> ...> archive where rainRate>0 order by dateTime desc limit 50; >>>>>>> 1641570900|2022-01-07 16:55:00|0.0|0.0393700785 >>>>>>> 1641570600|2022-01-07 16:50:00|0.0|0.0629921256 >>>>>>> 1641570300|2022-01-07 16:45:00|0.0157480314|1.4803149516 >>>>>>> <(480)%20314-9516> >>>>>>> 1641476700|2022-01-06 14:45:00|0.0|0.0314960628 >>>>>>> 1641476400|2022-01-06 14:40:00|0.0|0.0393700785 >>>>>>> 1641476100|2022-01-06 14:35:00|0.0|0.078740157 >>>>>>> 1641475800|2022-01-06 14:30:00|0.0078740157|0.157480314 >>>>>>> 1641475500|2022-01-06 14:25:00|0.0157480314|0.4409448792 >>>>>>> <(440)%20944-8792> >>>>>>> 1641475200|2022-01-06 14:20:00|0.0314960628|2.6220472281 >>>>>>> 1641430800|2022-01-06 02:00:00|0.0|0.0314960628 >>>>>>> 1641430500|2022-01-06 01:55:00|0.0|0.0551181099 >>>>>>> 1641430200|2022-01-06 01:50:00|0.0078740157|0.1181102355 >>>>>>> 1641429900|2022-01-06 01:45:00|0.0078740157|0.0551181099 >>>>>>> 1641429600|2022-01-06 01:40:00|0.0|0.0551181099 >>>>>>> 1641429300|2022-01-06 01:35:00|0.0157480314|0.2519685024 >>>>>>> <(251)%20968-5024> >>>>>>> 1641429000|2022-01-06 01:30:00|0.0078740157|0.2283464553 >>>>>>> <(228)%20346-4553> >>>>>>> 1641428700|2022-01-06 01:25:00|0.0157480314|0.2283464553 >>>>>>> <(228)%20346-4553> >>>>>>> 1641428400|2022-01-06 01:20:00|0.0078740157|0.0944881884 >>>>>>> 1641428100|2022-01-06 01:15:00|0.0078740157|0.1811023611 >>>>>>> 1641427800|2022-01-06 01:10:00|0.0078740157|0.1653543297 >>>>>>> 1641427500|2022-01-06 01:05:00|0.0078740157|0.078740157 >>>>>>> 1641427200|2022-01-06 01:00:00|0.0078740157|0.078740157 >>>>>>> 1641426900|2022-01-06 00:55:00|0.0|0.078740157 >>>>>>> 1641426600|2022-01-06 00:50:00|0.0078740157|0.1181102355 >>>>>>> 1641426300|2022-01-06 00:45:00|0.0078740157|0.0944881884 >>>>>>> 1641426000|2022-01-06 00:40:00|0.0078740157|0.0629921256 >>>>>>> 1641308400|2022-01-04 16:00:00|0.0|0.0314960628 >>>>>>> 1641308100|2022-01-04 15:55:00|0.0|0.0472440942 >>>>>>> 1641307800|2022-01-04 15:50:00|0.0078740157|0.0551181099 >>>>>>> 1641307500|2022-01-04 15:45:00|0.0|0.0551181099 >>>>>>> 1641307200|2022-01-04 15:40:00|0.0236220471|1.6771653441 >>>>>>> 1641306900|2022-01-04 15:35:00|0.0551181099|2.3779527414 >>>>>>> 1640620500|2021-12-27 16:55:00|0.0|0.0314960628 >>>>>>> 1640620200|2021-12-27 16:50:00|0.0|0.0314960628 >>>>>>> 1640619900|2021-12-27 16:45:00|0.0|0.0314960628 >>>>>>> 1640619600|2021-12-27 16:40:00|0.0078740157|0.0314960628 >>>>>>> 1640616300|2021-12-27 15:45:00|0.0|0.0314960628 >>>>>>> 1640616000|2021-12-27 15:40:00|0.0|0.0393700785 >>>>>>> 1640615700|2021-12-27 15:35:00|0.0|0.0393700785 >>>>>>> 1640615400|2021-12-27 15:30:00|0.0078740157|0.0393700785 >>>>>>> 1640611500|2021-12-27 14:25:00|0.0|0.0314960628 >>>>>>> 1640611200|2021-12-27 14:20:00|0.0|0.0472440942 >>>>>>> 1640610900|2021-12-27 14:15:00|0.0078740157|0.0551181099 >>>>>>> 1640610600|2021-12-27 14:10:00|0.0|0.0551181099 >>>>>>> 1640610300|2021-12-27 14:05:00|0.0078740157|0.236220471 >>>>>>> 1640605200|2021-12-27 12:40:00|0.0|0.0314960628 >>>>>>> 1640604900|2021-12-27 12:35:00|0.0|0.0472440942 >>>>>>> 1640604600|2021-12-27 12:30:00|0.0078740157|0.2677165338 >>>>>>> <(267)%20716-5338> >>>>>>> 1640604300|2021-12-27 12:25:00|0.0157480314|0.2283464553 >>>>>>> <(228)%20346-4553> >>>>>>> 1640547900|2021-12-26 20:45:00|0.0|0.0314960628 >>>>>>> >>>>>>> As you can see the database contains normal, acceptable values. >>>>>>> I wonder how the html displayed values are computed/retrieved... >>>>>>> On Wednesday, February 23, 2022 at 9:11:05 PM UTC+1 [email protected] >>>>>>> wrote: >>>>>>> >>>>>>>> That's certainly an unlikely number. >>>>>>>> >>>>>>>> Are you seeing this all the time? Or, just when it's raining? >>>>>>>> >>>>>>>> In weewx.conf, set debug = 2, then restart weewxd. Please post the >>>>>>>> log from startup through the first reporting cycle. >>>>>>>> >>>>>>>> -tk >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> On Wed, Feb 23, 2022 at 11:02 AM Luis <[email protected]> wrote: >>>>>>>> >>>>>>>>> All is set to prefer_hardware. >>>>>>>>> But then I can't understand why ALL THE REST of values are correct. >>>>>>>>> I moved to WEEWX from VWIEW after several years using wview and >>>>>>>>> there was no problem at all. >>>>>>>>> So my data logger works well. >>>>>>>>> It's just the rain rate which is wrong. >>>>>>>>> >>>>>>>>> Luis >>>>>>>>> On Sunday, November 21, 2021 at 10:43:45 PM UTC+1 [email protected] >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> Two things to check: >>>>>>>>>> >>>>>>>>>> 1. Are you using hardware record generation? This is the default. >>>>>>>>>> Look for option "record_generation" in the stanza [StdArchive]. >>>>>>>>>> >>>>>>>>>> 2. Did you change any values under [StdWXCalculate]? In >>>>>>>>>> particular, make sure the setting for 'rainRate' is >>>>>>>>>> "prefer_hardware": >>>>>>>>>> >>>>>>>>>> [StdWXCalculate] >>>>>>>>>> [[Calculations]] >>>>>>>>>> ... >>>>>>>>>> rainRate = prefer_hardware >>>>>>>>>> >>>>>>>>>> Assuming both of these are true, the value you are seeing is >>>>>>>>>> coming straight from the logger in your Vantage Vue. >>>>>>>>>> >>>>>>>>>> -tk >>>>>>>>>> >>>>>>>>>> On Sun, Nov 21, 2021 at 7:03 AM Luis <[email protected]> wrote: >>>>>>>>>> >>>>>>>>>>> Hi all, >>>>>>>>>>> I am running a WeeWx server connected to a Vantage Vue station. >>>>>>>>>>> The max rain rate is systematically wrong. >>>>>>>>>>> It always shows 13107.0 mm/hr which is impossible. >>>>>>>>>>> Today's max rain rate reported by the Vantage Vue console is >>>>>>>>>>> 25.6 mm/hr >>>>>>>>>>> Is there an issue with the conversion from inches to mm and with >>>>>>>>>>> the decimal separator (comma vs dot)? >>>>>>>>>>> Thanks >>>>>>>>>>> Luis >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> 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/a44a3e2e-7557-48b6-8c5a-a3a7d1607d26n%40googlegroups.com >>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/a44a3e2e-7557-48b6-8c5a-a3a7d1607d26n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>> . >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> 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/dcc3ed51-7b11-4739-a4d2-b06d562a7b73n%40googlegroups.com >>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/dcc3ed51-7b11-4739-a4d2-b06d562a7b73n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>> . >>>>>>>>> >>>>>>>> -- >>>>>> 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/d3b6d73a-0918-406e-b2af-1564bb433fd8n%40googlegroups.com >>>>>> <https://groups.google.com/d/msgid/weewx-user/d3b6d73a-0918-406e-b2af-1564bb433fd8n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- >>>> 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/415ff46f-4e77-4781-b97a-e304f3a9f479n%40googlegroups.com >>>> <https://groups.google.com/d/msgid/weewx-user/415ff46f-4e77-4781-b97a-e304f3a9f479n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- > 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/32acb126-6d67-470c-8c70-fb1d3d6ab804n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/32acb126-6d67-470c-8c70-fb1d3d6ab804n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAPq0zEAf70ewSNCtqgJ4jG7MCn-E2yYOj0Fa6LL2F0Qyd%3D2S4g%40mail.gmail.com.
