[BUG] Reason: '<' not supported between instances of 'NoneType' and 'float' in the skins/weewx-wdc/year-%Y.html.tmpl file

[cbirkenbeul]

Hello,
I've upgraded to weewx 5.0.2 and your skin to 3.5 and got a lot of issues. Most I could fix by myself because of the whew 5 upgrade.

But this issue I got and cannot solve by myself:

2024-02-27T10:05:36.003514+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: Evaluation of template /etc/weewx/skins/weewx-wdc/year-%Y.html.tmpl failed with exception '<class 'TypeError'>'
2024-02-27T10:05:36.003788+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/weewx-wdc/year-%Y.html.tmpl
2024-02-27T10:05:36.003952+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: **** Reason: '<' not supported between instances of 'NoneType' and 'float'
2024-02-27T10:05:36.005540+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
2024-02-27T10:05:36.005700+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 334, in generate
2024-02-27T10:05:36.005843+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
2024-02-27T10:05:36.005982+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-02-27T10:05:36.006115+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_year__Y_html_tmpl.py", line 203, in respond
2024-02-27T10:05:36.006256+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
2024-02-27T10:05:36.006389+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
2024-02-27T10:05:36.006520+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_includes_climatological_days_inc.py", line 861, in respond
2024-02-27T10:05:36.006650+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
2024-02-27T10:05:36.006772+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
2024-02-27T10:05:36.006895+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_includes_stat_table_inc.py", line 403, in respond
2024-02-27T10:05:36.007017+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_includes_stat_table_inc.py", line 144, in __errorCatcher11
2024-02-27T10:05:36.007140+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "<string>", line 1, in <module>
2024-02-27T10:05:36.007272+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****  TypeError: '<' not supported between instances of 'NoneType' and 'float'
2024-02-27T10:05:49.659314+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: Evaluation of template /etc/weewx/skins/weewx-wdc/statistics.html.tmpl failed with exception '<class 'TypeError'>'
2024-02-27T10:05:49.659790+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/weewx-wdc/statistics.html.tmpl
2024-02-27T10:05:49.659942+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: **** Reason: '<' not supported between instances of 'NoneType' and 'float'
2024-02-27T10:05:49.661522+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
2024-02-27T10:05:49.661680+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 334, in generate
2024-02-27T10:05:49.661819+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
2024-02-27T10:05:49.661958+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-02-27T10:05:49.662091+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_statistics_html_tmpl.py", line 250, in respond
2024-02-27T10:05:49.662226+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
2024-02-27T10:05:49.662356+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
2024-02-27T10:05:49.662484+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_includes_climatological_days_inc.py", line 861, in respond
2024-02-27T10:05:49.662617+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
2024-02-27T10:05:49.662740+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
2024-02-27T10:05:49.662879+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_includes_stat_table_inc.py", line 403, in respond
2024-02-27T10:05:49.663000+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_weewx_wdc_includes_stat_table_inc.py", line 144, in __errorCatcher11
2024-02-27T10:05:49.663122+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****    File "<string>", line 1, in <module>
2024-02-27T10:05:49.663247+01:00 weewx weewxd[69217]: ERROR weewx.cheetahgenerator: ****  TypeError: '<' not supported between instances of 'NoneType' and 'float'

There were a fixed issue with the same template file that was solved for 3.5, but I got a different error. The message seems that it could be a skin issue. Otherwise I would ask in the google groups.

Thanks.

[hoetzgit]

Hello,
a similar error in my case, WeeWX 4.10.2:

Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: **** Ignoring template /home/weewx/skins/weewx-wdc/statistics.html.tmpl
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: **** Reason: '<' not supported between instances of 'NoneType' and 'NoneType'
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "/home/weewx/bin/weewx/cheetahgenerator.py", line 348, in generate
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "_home_weewx_skins_weewx_wdc_statistics_html_tmpl.py", line 250, in respond
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "/usr/local/lib/python3.10/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "_home_weewx_skins_weewx_wdc_includes_climatological_days_inc.py", line 861, in respond
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "/usr/local/lib/python3.10/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "_home_weewx_skins_weewx_wdc_includes_stat_table_inc.py", line 403, in respond
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "_home_weewx_skins_weewx_wdc_includes_stat_table_inc.py", line 144, in __errorCatcher11
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****    File "<string>", line 1, in <module>
Feb 27 16:11:26 weewx weewx[114473] ERROR weewx.cheetahgenerator: ****  TypeError: '<' not supported between instances of 'NoneType' and 'NoneType'

Henry

[Daveiano]

I can't spot any issue and I can't even reproduce this error.

Did you guys make any changes to the provided skin.conf of the skin?

There were a fixed issue with the same template file that was solved for 3.5

@cbirkenbeul What issue do you mean? The template which causes the error skins/weewx-wdc/includes/stat-table.inc was added in 3.5.0.

Please try to disable the new added Stat tables via skin.conf:

[DisplayOptions]
    ...
    # For instructions, see https://github.com/Daveiano/weewx-wdc/wiki/Configuration#stat_tables
    #[[stat_tables]]
    #    [[[tables_outtemp]]]
    #        observation = "outTemp"
    #        label = "Temperature Stat Table"
    #        aggregate_types = "avg"
    #    [[[tables_rain]]]
    #        observation = "rain"
    #        label = "Rain Stat Table"
    #        aggregate_types = "sum", "avg"

This should stop the error and generate the templates.

[cbirkenbeul]

Hey,
thanks for your reply.
I've made a complete new installation, because I messed up with the 4 to 5 upgrade.

With disabling the stat_table fields all reports are now generated fine.

[Daveiano]

Ok but something is going on here. Do you have any missing data? Like you gathered data since 2020 but your database does not contain values for August 2021 or something?

Cant make any sense out of this Error message.

Would it be possible to share your weewx db with me? This way I could debug into this with the actual data causing this.

[cbirkenbeul]

We had an hardware issue since then. So no software problem.

I could, but I use a mariadb as backend and the sql file seems quite big. But should missing old data cause this issue? I mean, I run the 3.3 version quite long without any issues.

[Daveiano]

The error is triggered by the stat-table.inc template, these were added in 3.5.0 (new feature, see here: https://github.com/Daveiano/weewx-wdc/wiki/Configuration#stat_tables) - so I think it does not matter if the skin runs with an earlier version since the template was added in the last version.

One thing you could try in the skin.conf: Please just comment out the "tables_rain", like this:

...
[[stat_tables]]
        [[[tables_outtemp]]]
            observation = "outTemp"
            label = "Temperature Stat Table"
            aggregate_types = "min", "avg", "max"
        #[[[tables_rain]]]
        #   observation = "rain"
        #   label = "Rain Stat Table"
        #   aggregate_types = "sum", "avg"
...

Does this also solve the problem?

@hoetzgit Do you have a sqlite file of your DB to reproduce the problem for me?

[Daveiano]

Ok, I think I found the problem. Attached is an updated file stat-table.inc (its named stat-table.txt, please rename to stat-table.inc). Can you please copy it over the old one?

Its at skins/weewx-wdc/includes/stat-table.inc, see https://www.weewx.com/docs/5.0/usersguide/where/

You can then enable back the [[stat_tables]] an they should render as expected as you can see here in the example: https://github.com/Daveiano/weewx-wdc/wiki/Configuration#stat_tables

stat-table.txt

[hoetzgit]

I have no more errors in the log with the customized stat-table.inc

[cbirkenbeul]

For me it does not work. I've implemented your file and reenabled the stats_table section which I comment out some days ago.
Log attached for further debugging.
weewx.log

[Daveiano]

Ok, I don't think the changed file is related to the error.

The error appears on every page, except the index page (at least it's not included in the log) - the changed file only impacts the year and statistics pages, not eg. the week or month pages which also fail to generate.

There seems to be something messed up. Did you only change the one file or did you change other things, too? Perhaps copied to the wrong location? Changed something in skin.conf?

[cbirkenbeul]

As you told me in your very first answer, I disabled the stats_table completely. For your patch I reenabled them.

I have changed the language and added the lightning values as discussed here.

I've download your file with wget on my system. Renamed it and copied the file to the includes directory. I don't see any formatting errors like utf-8 or so. My procedure should be fine.

[Daveiano]

Sorry for not getting back to you sooner, I got a nasty cold last week...

It's really difficult for me to reproduce these error messages. The first thing would be to disable the stat-tables again, I guess. This should solve the errors.

The error from your logs 1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'radiation IS NOT NULL LIMIT 1' at line 1"is hard to understand since the stat_tables only query rain and outTemp, but no radiation.

So if you want to share your DB with me I would have a look to reproduce the issue (you can share it with david.baetge@gmail.com). In the meantime, disabling the stat-tables again should work.

[Nkawu]

Just upgraded to weewx 5.0.2 & weewx-wdc 3.5.0. Got the same error but on a different template. Change to stat-table.inc fixed it for me also. I didn't have the stat_tables section in my weewx.conf at all.