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.
select extraTemp9 is not null from weewx.archive.csv
Description: MS-Excel spreadsheet
