Good morning from Germany, it works with a mysql database
Thank you Am Montag, 6. April 2020 02:21:06 UTC+2 schrieb Tom Keffer: > > 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] > <javascript:>> 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] >> <javascript:>> 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] <javascript:>. >>> 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/2e3ea481-0ba5-4fec-9ae5-37303a3c4beb%40googlegroups.com.
