Error after updating weewx to version 5

[Mks Mk]

Hi

updated weewx using this command sudo apt update.

Hardware : raspberry pi 3 b+
OS       : Raspberry Pi OS (bullseye) Lite 64-bit
weewx    : 4.10.2

after the update we got this error:

INFO weewx.manager: Added record 2024-01-18 09:45:00 +03 (1705560300) to database 'weewx.sdb'
INFO weewx.manager: Added record 2024-01-18 09:45:00 +03 (1705560300) to daily summary in 'weewx.sdb'
ERROR weewx.cheetahgenerator: Evaluation of template /etc/weewx/skins/Seasons/index.html.tmpl failed with exception '<class 'weedb.OperationalError'>'
ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/Seasons/index.html.tmpl
ERROR weewx.cheetahgenerator: **** Reason: near "IS": syntax error
ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weedb/sqlite.py", line 38, in guarded_fn
ERROR weewx.cheetahgenerator: ****      return fn(*args, **kwargs)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute
ERROR weewx.cheetahgenerator: ****      return sqlite3.Cursor.execute(self, *args, **kwargs)
ERROR weewx.cheetahgenerator: ****  sqlite3.OperationalError: near "IS": syntax error
ERROR weewx.cheetahgenerator: ****
ERROR weewx.cheetahgenerator: ****  During handling of the above exception, another exception occurred:
ERROR weewx.cheetahgenerator: ****
ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 334, in generate
ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Seasons_index_html_tmpl.py", line 249, in respond
ERROR weewx.cheetahgenerator: ****    File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Seasons_sensors_inc.py", line 290, in respond
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/tags.py", line 389, in has_data
ERROR weewx.cheetahgenerator: ****      val = weewx.xtypes.has_data(self.obs_type, self.timespan, db_manager)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/xtypes.py", line 156, in has_data
ERROR weewx.cheetahgenerator: ****      vt = xtype.get_aggregate(obs_type, timespan, 'not_null', db_manager)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/xtypes.py", line 373, in get_aggregate
ERROR weewx.cheetahgenerator: ****      row = db_manager.getSql(select_stmt)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/manager.py", line 579, in getSql
ERROR weewx.cheetahgenerator: ****      _cursor.execute(sql, sqlargs)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weedb/sqlite.py", line 52, in guarded_fn
ERROR weewx.cheetahgenerator: ****      raise weedb.OperationalError(e)
ERROR weewx.cheetahgenerator: ****  weedb.OperationalError: near "IS": syntax error
ERROR weewx.cheetahgenerator: Evaluation of template /etc/weewx/skins/Seasons/telemetry.html.tmpl failed with exception '<class 'weedb.OperationalError'>'
ERROR weewx.cheetahgenerator: **** Ignoring template /etc/weewx/skins/Seasons/telemetry.html.tmpl
ERROR weewx.cheetahgenerator: **** Reason: near "IS": syntax error
ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weedb/sqlite.py", line 38, in guarded_fn
ERROR weewx.cheetahgenerator: ****      return fn(*args, **kwargs)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weedb/sqlite.py", line 233, in execute
ERROR weewx.cheetahgenerator: ****      return sqlite3.Cursor.execute(self, *args, **kwargs)
ERROR weewx.cheetahgenerator: ****  sqlite3.OperationalError: near "IS": syntax error
ERROR weewx.cheetahgenerator: ****
ERROR weewx.cheetahgenerator: ****  During handling of the above exception, another exception occurred:
ERROR weewx.cheetahgenerator: ****
ERROR weewx.cheetahgenerator: ****  Traceback (most recent call last):
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/cheetahgenerator.py", line 334, in generate
ERROR weewx.cheetahgenerator: ****      unicode_string = compiled_template.respond()
ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Seasons_telemetry_html_tmpl.py", line 250, in respond
ERROR weewx.cheetahgenerator: ****    File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line 1708, in _handleCheetahInclude
ERROR weewx.cheetahgenerator: ****      self._CHEETAH__cheetahIncludes[_includeID].respond(trans)
ERROR weewx.cheetahgenerator: ****    File "_etc_weewx_skins_Seasons_sensors_inc.py", line 290, in respond
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/tags.py", line 389, in has_data
ERROR weewx.cheetahgenerator: ****      val = weewx.xtypes.has_data(self.obs_type, self.timespan, db_manager)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/xtypes.py", line 156, in has_data
ERROR weewx.cheetahgenerator: ****      vt = xtype.get_aggregate(obs_type, timespan, 'not_null', db_manager)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/xtypes.py", line 373, in get_aggregate
ERROR weewx.cheetahgenerator: ****      row = db_manager.getSql(select_stmt)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weewx/manager.py", line 579, in getSql
ERROR weewx.cheetahgenerator: ****      _cursor.execute(sql, sqlargs)
ERROR weewx.cheetahgenerator: ****    File "/usr/share/weewx/weedb/sqlite.py", line 52, in guarded_fn
ERROR weewx.cheetahgenerator: ****      raise weedb.OperationalError(e)
ERROR weewx.cheetahgenerator: ****  weedb.OperationalError: near "IS": syntax error
INFO weewx.cheetahgenerator: Generated 7 files for report SeasonsReport in 3.35 seconds
INFO weewx.imagegenerator: Generated 4 images for report SeasonsReport in 0.29 seconds
INFO weewx.reportengine: Copied 0 files to /var/www/html/weewx

what could be the problem with this raspberry pi?
other raspberry pi 4 update was done with no problem at all.

Thank you

[Tom Keffer]

Could you please use the utility "weectl debug" to post your weewx.conf?

weectl debug > /var/tmp/debug.txt

The utility will attempt to obfuscate any passwords, but it's not always 100% accurate. Look over /var/tmp/debug.txt to see if it missed anything. Then post the file.

--
You received this message because you are subscribed to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/d3623891-0f90-4ac0-8688-573151f6a7f3n%40googlegroups.com.

[Mks Mk]

finding

in skin.conf file (Seasons) weewx v4.10.2 under

[DisplayOptions]
    sensor_connections =

we kept (sensor_connections) blank (sorry, can not remember the reason) and weewx v4.10.2 never complained about it, but weewx v5.0 did not like it!
we edited skin.conf file (Seasons):

[DisplayOptions]
    sensor_connections = rxCheckPercent

weewx v5 is running ok now.

[Tom Keffer]

That makes sense. We've seen this before: https://groups.google.com/g/weewx-development/c/Kjp4pnx3x1M/m/6AUNe0niAAAJ

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/8ad68085-4a44-417e-9220-321e2068225fn%40googlegroups.com.