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/CAPq0zEDJkrMsV2P62NC7jPUAWGM7ALgF6TWecDLXH3%2BtHDN_DA%40mail.gmail.com.
