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.
