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 string2024-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 run2024-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 start2024-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 run2024-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_data2024-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 genSql2024-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_fn2024-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 execute2024-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 execute2024-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 mogrify2024-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 -- 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 [email protected]. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/a50a77c6-4409-4ba2-a290-e97ba6cd4a73n%40googlegroups.com.
