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.
