Graphs problem Belchertown and MySQL-DB

[MaKi68]

Hello,

I'm running weewx 5.1.0 on a Raspi5 with Bookworm an Belchertown 1.3.1.
If I use the SQLite-DB, there is no problem.

If I switch to the MySQL-DB, ther is a problem with

xAxis_groupby = month aggregate_type = avg 

average_type = sum

in graphs.conf.

I get the following error:

2024-12-12T16:38:09.352479+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine: Caught unrecoverable exception in generator 'user.belchertown.HighchartsJsonGenerator'
2024-12-12T16:38:09.352586+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****  not enough arguments for format string
2024-12-12T16:38:09.356361+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****  Traceback (most recent call last):
2024-12-12T16:38:09.356425+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weewx/reportengine.py", line 248, in run
2024-12-12T16:38:09.356454+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      obj.start()
2024-12-12T16:38:09.356482+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weewx/reportengine.py", line 465, in start
2024-12-12T16:38:09.356509+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      self.run()
2024-12-12T16:38:09.356531+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-data/bin/user/belchertown.py", line 2934, in run
2024-12-12T16:38:09.356558+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      series_data = self.get_observation_data(
2024-12-12T16:38:09.356584+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****                    ^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-12-12T16:38:09.356610+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-data/bin/user/belchertown.py", line 3894, in get_observation_data
2024-12-12T16:38:09.356636+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      for row in query:
2024-12-12T16:38:09.356661+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weewx/manager.py", line 618, in genSql
2024-12-12T16:38:09.356686+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      for _row in _cursor.execute(sql, sqlargs):
2024-12-12T16:38:09.356710+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-12-12T16:38:09.356736+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weedb/mysql.py", line 53, in guarded_fn
2024-12-12T16:38:09.356761+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      return fn(*args, **kwargs)
2024-12-12T16:38:09.356786+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****             ^^^^^^^^^^^^^^^^^^^
2024-12-12T16:38:09.356812+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weedb/mysql.py", line 247, in execute
2024-12-12T16:38:09.356845+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      self.cursor.execute(mysql_string, tuple(sql_tuple))
2024-12-12T16:38:09.356870+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/pymysql/cursors.py", line 151, in execute
2024-12-12T16:38:09.356895+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      query = self.mogrify(query, args)
2024-12-12T16:38:09.356922+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****              ^^^^^^^^^^^^^^^^^^^^^^^^^
2024-12-12T16:38:09.356949+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/pymysql/cursors.py", line 129, in mogrify
2024-12-12T16:38:09.356974+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****      query = query % self._escape_args(args, conn)
2024-12-12T16:38:09.356999+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****              ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2024-12-12T16:38:09.357023+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****  TypeError: not enough arguments for format string

2024-12-12T16:38:09.357047+01:00 weewx-raspi5 weectl[15178]: ERROR weewx.reportengine:         ****  Generator terminated 

What's the problem with MySQL-DB?

My Homepage:

https://wetter-ruppersthal.at

Thank you in advance.

Kind regards

Manfred