Silly me. I don't know what made me think this would work with MySQL --- it does not have an equivalent of strftime().
Let me see what I can do. -tk On Sat, Apr 4, 2020 at 3:23 AM Hartmut Schweidler <[email protected]> wrote: > Hallo Tom, > > Today I installed the Historical extension, the extension does not work > with a MYSQL database. > my Weewx version 4.0.0b18 > > <tr> > <td class="stats_label">Max Temp <br /> </td> > <td class="stats_data">$day.outTemp.historical_max > im Jahre $day.outTemp.historical_maxtime.format("%Y")</td> > </tr> > an in syslog > > Apr 4 12:21:12 wetter weewx-weewx[10525] DEBUG user.xrainno: MyXRainNo > SLE executed in 1.774 seconds > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > Generate failed with exception '<class 'weedb.DatabaseError'>' > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** Ignoring template /home/weewx/skins/Basics/trend.html.tmpl > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** Reason: not enough arguments for format string > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** Traceback (most recent call last): > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 238 > , in execute > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** query = query % args > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** TypeError: not enough arguments for format string > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** During handling of the above exception, another exception occurred: > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** Traceback (most recent call last): > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weedb/mysql.py", line 52, in guarded_fn > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** return fn(*args, **kwargs) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weedb/mysql.py", line 262, in execute > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** self.cursor.execute(mysql_string, tuple(sql_tuple)) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/usr/lib/python3/dist-packages/MySQLdb/cursors.py", line 240 > , in execute > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** self.errorhandler(self, ProgrammingError, str(m)) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", > line 52, in defaulterrorhandler > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** raise errorclass(errorvalue) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** _mysql_exceptions.ProgrammingError: not enough arguments for format > string > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** During handling of the above exception, another exception occurred: > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** Traceback (most recent call last): > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weewx/cheetahgenerator.py", line 323, in > generate > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** unicode_string = compiled_template.respond() > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "_home_weewx_skins_Basics_trend_html_tmpl.py", line 422, in > respond > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line > 1707, in _handleCheetahInclude > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** self._CHEETAH__cheetahIncludes[_includeID].respond(trans) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File > "cheetah__home_weewx_skins_Standard_hes_current_inc_1585994730_8648148_88513.py" > , line 114, in respond > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weewx/tags.py", line 347, in __getattr__ > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** return self._do_query(aggregate_type) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weewx/tags.py", line 364, in _do_query > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** db_manager, val=val, **self.option_dict) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weewx/xtypes.py", line 102, in get_aggregate > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** **option_dict) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/user/historical.py", line 75, in > get_aggregate > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** row = db_manager.getSql(sql_stmt) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weewx/manager.py", line 419, in getSql > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** _cursor.execute(sql, sqlargs) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** File "/home/weewx/bin/weedb/mysql.py", line 61, in guarded_fn > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** raise klass(e) > Apr 4 12:21:12 wetter weewx-weewx[10525] ERROR weewx.cheetahgenerator: > **** weedb.DatabaseError: not enough arguments for format string > Apr 4 12:21:12 wetter weewx-weewx[10525] INFO weewx.cheetahgenerator: > Generated 0 files for report BasicReport in 31.83 seconds > > > > > -- > You received this message because you are subscribed to the Google Groups > "weewx-development" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-development/83b79abb-3ab5-4de0-987c-2e894121cfb5%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-development/83b79abb-3ab5-4de0-987c-2e894121cfb5%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/CAPq0zECYvzb-uYD0DYMC4whvCyNf-ySR%3DL0QyuqZbx2xAEms2Q%40mail.gmail.com.
