MYSQL Database / aggregate_type = avg / average_type = sum

[ManfredK1968]

Hello,

Hello,
I use weewx v5 in combination with Bechertown skin v 1.3.1
When I use the sqlite database, works

xAxis_groupby = month
aggregate_type = avg
average_type = sum
It doesn't matter whether you use rain or rainTotal

without problems.
However, when I switch to a mysql database, I get the error messages:

2024-01-24T17:33:46.755488+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine: Caught unrecoverable exception in generator 'user.belchertown.HighchartsJsonGenerator'
2024-01-24T17:33:46.756057+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****  not enough arguments for format string
2024-01-24T17:33:46.767935+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****  Traceback (most recent call last):
2024-01-24T17:33:46.768408+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weewx/reportengine.py", line 207, in run
2024-01-24T17:33:46.768736+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      obj.start()
2024-01-24T17:33:46.769014+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weewx/reportengine.py", line 399, in start
2024-01-24T17:33:46.769271+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      self.run()
2024-01-24T17:33:46.769570+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-data/bin/user/belchertown.py", line 2756, in run
2024-01-24T17:33:46.769904+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      series_data = self.get_observation_data(
2024-01-24T17:33:46.770178+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****                    ^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-01-24T17:33:46.770419+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-data/bin/user/belchertown.py", line 3694, in get_observation_data
2024-01-24T17:33:46.770641+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      for row in query:
2024-01-24T17:33:46.770994+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weewx/manager.py", line 598, in genSql
2024-01-24T17:33:46.771286+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      for _row in _cursor.execute(sql, sqlargs):
2024-01-24T17:33:46.771485+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
2024-01-24T17:33:46.771682+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weedb/mysql.py", line 53, in guarded_fn
2024-01-24T17:33:46.771871+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      return fn(*args, **kwargs)
2024-01-24T17:33:46.772046+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****             ^^^^^^^^^^^^^^^^^^^
2024-01-24T17:33:46.772233+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/weedb/mysql.py", line 247, in execute
2024-01-24T17:33:46.772402+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      self.cursor.execute(mysql_string, tuple(sql_tuple))
2024-01-24T17:33:46.772543+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/pymysql/cursors.py", line 151, in execute
2024-01-24T17:33:46.772660+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      query = self.mogrify(query, args)
2024-01-24T17:33:46.772781+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****              ^^^^^^^^^^^^^^^^^^^^^^^^^
2024-01-24T17:33:46.772901+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****    File "/home/pi/weewx-venv/lib/python3.11/site-packages/pymysql/cursors.py", line 129, in mogrify
2024-01-24T17:33:46.773099+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****      query = query % self._escape_args(args, conn)
2024-01-24T17:33:46.773274+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****              ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2024-01-24T17:33:46.773457+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****  TypeError: not enough arguments for format string
2024-01-24T17:33:46.773677+01:00 weewx-raspi5 weectl[15772]: ERROR weewx.reportengine:         ****  Generator terminated

What can I do?
Thanks in advance

My Homepage:
https://wetter-ruppersthal.at

LG
Manfred

[Brooksey07]

@ManfredK1968 - I'm a big fan of your History page on your website with all the colour-coded tables. I've been looking for something similar but not being a coder I've struggled to find something I can implement easily. Would you be willing to send instructions on how you did this on yours? or share the code to implement this myself.

I would credit you on my site for the work.

[ManfredK1968]

@Brooksey07 - I've sent you an email with all necessary files. I hope you've got it. If not, my email manfred.kirchner(at)gmail.com
If you have any questions, please contact me again.
LG from Austria
Manfred