Hi Tom, this version also works. Michaeal
Tom Keffer schrieb am Donnerstag, 4. November 2021 um 23:42:33 UTC+1: > Michael, > > Could you please try this version of weewx/xtypes.py? > > On Thu, Nov 4, 2021 at 12:16 PM Tom Keffer <[email protected]> wrote: > >> I think you're lucky. I just thought of a corner case where it would not >> work. >> >> I'll get a new version out later today. >> >> On Thu, Nov 4, 2021 at 12:14 PM [email protected] <[email protected]> wrote: >> >>> Great, thx Tom, now it works :) >>> >>> Michael >>> >>> >>> >>> Tom Keffer schrieb am Donnerstag, 4. November 2021 um 20:02:10 UTC+1: >>> >>>> Yes, I think there is a problem with the query for the daily summaries. >>>> >>>> Could you replace the file weewx/xtypes.py with the attached and try >>>> again? >>>> >>>> Thanks in advance. >>>> >>>> -tk >>>> >>>> >>>> On Thu, Nov 4, 2021 at 11:47 AM [email protected] <[email protected]> wrote: >>>> >>>>> Your first query modified a little bit in 2 variants >>>>> >>>>> 1) >>>>> MariaDB [(none)]> select count(*) from weewx.archive where extraTemp9 >>>>> is NULL; >>>>> +----------+ >>>>> | count(*) | >>>>> +----------+ >>>>> | 2983 | >>>>> +----------+ >>>>> 1 row in set (0.003 sec) >>>>> >>>>> 2) >>>>> MariaDB [(none)]> select count(*) from weewx.archive where extraTemp9 >>>>> is not NULL; >>>>> +----------+ >>>>> | count(*) | >>>>> +----------+ >>>>> | 1553 | >>>>> +----------+ >>>>> 1 row in set (0.003 sec) >>>>> >>>>> >>>>> your second select without "limit 1" at the end: >>>>> >>>>> MariaDB [(none)]> select count>0 from weewx.archive_day_extraTemp9 >>>>> where dateTime>=1609459200 and dateTime<1640995200; >>>>> +---------+ >>>>> | count>0 | >>>>> +---------+ >>>>> | 0 | >>>>> | 0 | >>>>> | 1 | >>>>> | 1 | >>>>> +---------+ >>>>> 4 rows in set (0.000 sec) >>>>> >>>>> the database has only existed for a few days. Therefore, I have >>>>> omitted the date restriction from your first select. >>>>> >>>>> >>>>> Michael >>>>> Tom Keffer schrieb am Donnerstag, 4. November 2021 um 18:19:36 UTC+1: >>>>> >>>>>> This is indicating that there is no non-null data for the year, which >>>>>> explains why we're not seeing anything on the HTML page. >>>>>> >>>>>> But, it's not explaining why these results are different from the >>>>>> ones you posted a few messages ago. >>>>>> >>>>>> >>>>>> On Thu, Nov 4, 2021 at 10:06 AM [email protected] <[email protected]> wrote: >>>>>> >>>>>>> Her it is: >>>>>>> >>>>>>> MariaDB [(none)]> select extraTemp9 is not null from weewx.archive >>>>>>> where dateTime>1609459200 and dateTime<=1640995200 limit 1; >>>>>>> +------------------------+ >>>>>>> | extraTemp9 is not null | >>>>>>> +------------------------+ >>>>>>> | 0 | >>>>>>> +------------------------+ >>>>>>> 1 row in set (0.000 sec) >>>>>>> >>>>>>> MariaDB [(none)]> select count>0 from weewx.archive_day_extraTemp9 >>>>>>> where dateTime>=1609459200 and dateTime<1640995200 limit 1; >>>>>>> +---------+ >>>>>>> | count>0 | >>>>>>> +---------+ >>>>>>> | 0 | >>>>>>> +---------+ >>>>>>> 1 row in set (0.000 sec) >>>>>>> >>>>>>> >>>>>>> Michael >>>>>>> >>>>>>> >>>>>>> Tom Keffer schrieb am Donnerstag, 4. November 2021 um 17:58:41 UTC+1: >>>>>>> >>>>>>>> Sorry, I blew those queries! We want >>>>>>>> >>>>>>>> select extraTemp9 is not null from weewx.archive where >>>>>>>> dateTime>1609459200 and dateTime<=1640995200 limit 1; >>>>>>>> select count>0 from weewx.archive_day_extraTemp9 where >>>>>>>> dateTime>=1609459200 and dateTime<1640995200 limit 1; >>>>>>>> >>>>>>>> -tk >>>>>>>> >>>>>>>> >>>>>>>> On Thu, Nov 4, 2021 at 9:46 AM [email protected] <[email protected]> wrote: >>>>>>>> >>>>>>>>> for the result of: >>>>>>>>> select extraTemp9 is not null from weewx.archive where >>>>>>>>> dateTime>1609459200 and dateTime<=1640995200; >>>>>>>>> see attached csv. >>>>>>>>> >>>>>>>>> But I don't really understand what this is supposed to query >>>>>>>>> (neither does mysql). >>>>>>>>> >>>>>>>>> MariaDB [(none)]> select count>0 from weewx.archive where >>>>>>>>> dateTime>=1609459200 and dateTime<1640995200; >>>>>>>>> ERROR 1054 (42S22): Unknown column 'count' in 'field list' >>>>>>>>> >>>>>>>>> >>>>>>>>> Tom Keffer schrieb am Donnerstag, 4. November 2021 um 17:24:30 >>>>>>>>> UTC+1: >>>>>>>>> >>>>>>>>>> Odd. >>>>>>>>>> >>>>>>>>>> Try these queries >>>>>>>>>> >>>>>>>>>> select extraTemp9 is not null from weewx.archive where >>>>>>>>>> dateTime>1609459200 and dateTime<=1640995200; >>>>>>>>>> select count>0 from weewx.archive where dateTime>=1609459200 and >>>>>>>>>> dateTime<1640995200; >>>>>>>>>> >>>>>>>>>> This is the check used to decide whether to show a value or plot. >>>>>>>>>> It checks for non-null values during the present year. >>>>>>>>>> >>>>>>>>>> -tk >>>>>>>>>> >>>>>>>>>> On Thu, Nov 4, 2021 at 8:27 AM [email protected] <[email protected]> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> Hi Tom, >>>>>>>>>>> Yes, these values are in the database. But now I see that the >>>>>>>>>>> value for extraTemp9 is stored in Fahrenheit. But the rest of the >>>>>>>>>>> values >>>>>>>>>>> are in C. >>>>>>>>>>> Then these values should also be visible in the HTML view, right? >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> MariaDB [(none)]> SELECT >>>>>>>>>>> >>>>>>>>>>> -> DATE_FORMAT(FROM_UNIXTIME(datetime), '%d/%m/%Y - %H:%i:%s') >>>>>>>>>>> AS datum, >>>>>>>>>>> >>>>>>>>>>> -> datetime, >>>>>>>>>>> >>>>>>>>>>> -> usUnits, >>>>>>>>>>> >>>>>>>>>>> -> extratemp1, >>>>>>>>>>> >>>>>>>>>>> -> extratemp2, >>>>>>>>>>> >>>>>>>>>>> -> extratemp9, >>>>>>>>>>> >>>>>>>>>>> -> extrahumid1, >>>>>>>>>>> >>>>>>>>>>> -> extrahumid2, >>>>>>>>>>> >>>>>>>>>>> -> extrahumid9 >>>>>>>>>>> >>>>>>>>>>> -> FROM >>>>>>>>>>> >>>>>>>>>>> -> weewx.archive >>>>>>>>>>> >>>>>>>>>>> -> WHERE >>>>>>>>>>> >>>>>>>>>>> -> datetime > 1636038720 >>>>>>>>>>> >>>>>>>>>>> -> order by datetime; >>>>>>>>>>> >>>>>>>>>>> +-----------------------+------------+---------+-------------------+-------------------+------------+-------------+-------------+-------------+ >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> | datum | datetime | usUnits | extratemp1 | extratemp2 | >>>>>>>>>>> extratemp9 | extrahumid1 | extrahumid2 | extrahumid9 | >>>>>>>>>>> >>>>>>>>>>> +-----------------------+------------+---------+-------------------+-------------------+------------+-------------+-------------+-------------+ >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> | 04/11/2021 - 16:14:00 | 1636038840 | 16 | 20.11111111111111 | >>>>>>>>>>> 16.77777777777778 | 68.2 | 45 | 56 | 45 | >>>>>>>>>>> >>>>>>>>>>> | 04/11/2021 - 16:15:00 | 1636038900 | 16 | 20.11111111111111 | >>>>>>>>>>> 16.77777777777778 | 68.2 | 45 | 56 | 45 | >>>>>>>>>>> >>>>>>>>>>> | 04/11/2021 - 16:16:00 | 1636038960 | 16 | 20.11111111111111 | >>>>>>>>>>> 16.77777777777778 | 68.2 | 45 | 56 | 45 | >>>>>>>>>>> >>>>>>>>>>> | 04/11/2021 - 16:17:00 | 1636039020 | 16 | 20.11111111111111 | >>>>>>>>>>> 16.77777777777778 | 68.2 | 45 | 56 | 45 | >>>>>>>>>>> >>>>>>>>>>> | 04/11/2021 - 16:18:00 | 1636039080 | 16 | 20.11111111111111 | >>>>>>>>>>> 16.77777777777778 | 68.2 | 45 | 56 | 45 | >>>>>>>>>>> >>>>>>>>>>> | 04/11/2021 - 16:19:00 | 1636039140 | 16 | 20.11111111111111 | >>>>>>>>>>> 16.77777777777778 | 68.2 | 45 | 56 | 45 | >>>>>>>>>>> >>>>>>>>>>> +-----------------------+------------+---------+-------------------+-------------------+------------+-------------+-------------+-------------+ >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> 6 rows in set (0.000 sec) >>>>>>>>>>> [image: Screenshot1.png] >>>>>>>>>>> >>>>>>>>>>> >>>>>>>>>>> Tom Keffer schrieb am Mittwoch, 3. November 2021 um 22:35:04 >>>>>>>>>>> UTC+1: >>>>>>>>>>> >>>>>>>>>>>> Hi, Michael >>>>>>>>>>>> >>>>>>>>>>>> The option "observations" controls what gets displayed under >>>>>>>>>>>> "High/Low". >>>>>>>>>>>> >>>>>>>>>>>> The option "observations_current" controls what gets displayed >>>>>>>>>>>> under "Current Conditions". >>>>>>>>>>>> >>>>>>>>>>>> There must also be corresponding non-null values sometime in >>>>>>>>>>>> the last year within the database. Are you sure you have values >>>>>>>>>>>> for >>>>>>>>>>>> extraTemp9 and extraHumid9? >>>>>>>>>>>> >>>>>>>>>>>> -tk >>>>>>>>>>>> >>>>>>>>>>>> >>>>>>>>>>>> On Wed, Nov 3, 2021 at 11:59 AM [email protected] <[email protected]> >>>>>>>>>>>> wrote: >>>>>>>>>>>> >>>>>>>>>>>>> Hi Tom, >>>>>>>>>>>>> >>>>>>>>>>>>> I have reinstalled weewx 4.6.0b6 on a VM with "setup.py". As >>>>>>>>>>>>> usual without any problems. The driver used is weewx-interceptor >>>>>>>>>>>>> by Matthew >>>>>>>>>>>>> Wall. >>>>>>>>>>>>> At first glance everything works as expected :) >>>>>>>>>>>>> I have added in weewx.conf under >>>>>>>>>>>>> "[Interceptor]" >>>>>>>>>>>>> >>>>>>>>>>>>> added the following: >>>>>>>>>>>>> >>>>>>>>>>>>> [[sensor_map_extensions]] >>>>>>>>>>>>> extraTemp9 = temperature_1 >>>>>>>>>>>>> extraHumid9 = humidity_1 >>>>>>>>>>>>> >>>>>>>>>>>>> these values extraTemp9 and extraHumid9 are also written to >>>>>>>>>>>>> the database. >>>>>>>>>>>>> >>>>>>>>>>>>> I have saved the file skin.conf under >>>>>>>>>>>>> [DisplayOptions] >>>>>>>>>>>>> observations_current =... >>>>>>>>>>>>> extraTemp9, extraHumid9... >>>>>>>>>>>>> added. >>>>>>>>>>>>> >>>>>>>>>>>>> If I understand the system correctly, the value for >>>>>>>>>>>>> extraTemp9 >>>>>>>>>>>>> extraHumid9 >>>>>>>>>>>>> must also be displayed in the HTML view under "Current". In >>>>>>>>>>>>> addition to the "standard values" only extraTemp1 ... extraTemp4 >>>>>>>>>>>>> and the >>>>>>>>>>>>> corresponding extraHumid values are displayed. >>>>>>>>>>>>> What do I have to do so that the values for extraTemp9 and >>>>>>>>>>>>> extraHumid9 are displayed? >>>>>>>>>>>>> >>>>>>>>>>>>> Michael >>>>>>>>>>>>> >>>>>>>>>>>>> >>>>>>>>>>>>> Tom Keffer schrieb am Dienstag, 2. November 2021 um 23:47:05 >>>>>>>>>>>>> UTC+1: >>>>>>>>>>>>> >>>>>>>>>>>>>> Available in the usual place: >>>>>>>>>>>>>> http://weewx.com/downloads/development_versions/ >>>>>>>>>>>>>> >>>>>>>>>>>>>> I'm especially interested in experiences with installing and >>>>>>>>>>>>>> configuring the *Seasons* skin. It has undergone a >>>>>>>>>>>>>> significant refactoring. >>>>>>>>>>>>>> >>>>>>>>>>>>>> Thanks!! >>>>>>>>>>>>>> >>>>>>>>>>>>>> -tk >>>>>>>>>>>>>> >>>>>>>>>>>>> -- >>>>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>>>> Google Groups "weewx-development" 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-development/6f551a83-d38b-4f38-be77-f2d4ef26eb35n%40googlegroups.com >>>>>>>>>>>>> >>>>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-development/6f551a83-d38b-4f38-be77-f2d4ef26eb35n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>>>> . >>>>>>>>>>>>> >>>>>>>>>>>> -- >>>>>>>>>>> You received this message because you are subscribed to the >>>>>>>>>>> Google Groups "weewx-development" 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-development/d2e80873-d7b2-47ac-b854-134db6b34f7fn%40googlegroups.com >>>>>>>>>>> >>>>>>>>>>> <https://groups.google.com/d/msgid/weewx-development/d2e80873-d7b2-47ac-b854-134db6b34f7fn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>>>> . >>>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> You received this message because you are subscribed to the Google >>>>>>>>> Groups "weewx-development" 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-development/b048eca8-c5e3-4228-9654-59caa34872e6n%40googlegroups.com >>>>>>>>> >>>>>>>>> <https://groups.google.com/d/msgid/weewx-development/b048eca8-c5e3-4228-9654-59caa34872e6n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>>>> . >>>>>>>>> >>>>>>>> -- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "weewx-development" 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-development/7b32e1f8-f725-4c65-ba23-e7a7b4da8cb2n%40googlegroups.com >>>>>>> >>>>>>> <https://groups.google.com/d/msgid/weewx-development/7b32e1f8-f725-4c65-ba23-e7a7b4da8cb2n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>>> . >>>>>>> >>>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "weewx-development" 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-development/6ab83f60-285d-419d-be35-127ded43ac3dn%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-development/6ab83f60-285d-419d-be35-127ded43ac3dn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "weewx-development" 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-development/783f4c8c-e322-4144-9507-52473083bda9n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-development/783f4c8c-e322-4144-9507-52473083bda9n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- You received this message because you are subscribed to the Google Groups "weewx-development" 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-development/83ce4af9-3ef6-4155-90eb-d450dbb05cfbn%40googlegroups.com.
