Added the Key into the interpolation dictionary to both of the statements (one at a time of course) which corrected the error, but generated a different error.
Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: Generate failed with exception '<class 'sqlite3.Warning'>' Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** Ignoring template /home/weewx/skins/Seasons/index.html.tmpl Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** Reason: You can only execute one statement at a time. Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** Traceback (most recent call last): Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/weewx/cheetahgenerator.py", line 322, in generate Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** unicode_string = compiled_template.respond() Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "_home_weewx_skins_Seasons_index_html_tmpl.py", line 225, in respond Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/usr/lib/python3/dist-packages/Cheetah/Template.py", line 1707, in _handleCheetahInclude Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** self._CHEETAH__cheetahIncludes[_includeID].respond(trans) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "_home_weewx_skins_Seasons_historical_statistics_inc.py", line 377, in respond Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "_home_weewx_skins_Seasons_historical_statistics_inc.py", line 127, in __errorCatcher9 Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "<string>", line 1, in <module> Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/weewx/tags.py", line 347, in __getattr__ Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** return self._do_query(aggregate_type) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/weewx/tags.py", line 364, in _do_query Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** db_manager, val=val, **self.option_dict) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/weewx/xtypes.py", line 102, in get_aggregate Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** **option_dict) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/user/historical.py", line 104, in get_aggregate Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** row = db_manager.getSql(sql_stmt) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/weewx/manager.py", line 419, in getSql Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** _cursor.execute(sql, sqlargs) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/weedb/sqlite.py", line 29, in guarded_fn Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** return fn(*args, **kwargs) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** File "/home/weewx/bin/weedb/sqlite.py", line 211, in execute Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** return sqlite3.Cursor.execute(self, *args, **kwargs) Apr 24 20:25:26 raspberrypi weewx[11504] ERROR weewx.cheetahgenerator: **** sqlite3.Warning: You can only execute one statement at a time. I backed out all the changes that were made to the historical.py file and works it works fine. I would not worry to much about this because it is not an actual issue. Again thanks for you time to look into what I was trying. Rich > >> -- 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/e2a76e50-edce-4b44-aec0-7e68032f0081%40googlegroups.com.
