OK, I've updated the extension to work with MySQL. Find it here: https://github.com/tkeffer/weewx-historical/archive/weewx-historical-0.2.0.tar.gz
-tk On Sat, Apr 4, 2020 at 4:38 AM Thomas Keffer <[email protected]> wrote: > 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/CAPq0zEAKgxwWpaiXg_VdqW_AUKTxTceKGx3e%3DraBjZgC7hxbvw%40mail.gmail.com.
