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 />&nbsp;</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.

Reply via email to