Tks Andrew, I have re-installed again and keept as original database schema. But it doesn't make sense, unless the standard skin is not even working anymore?! As I said, I'm using default installation with default configuration/skin/simulation driver. Tried with sqlite and Mysql, both smae errors. Standard skin is broken?!
Em segunda-feira, 5 de novembro de 2018 11:03:36 UTC-2, Andrew Milner escreveu: > > there is no wind column as such in the database > > see this thread for a description of wind and how it may be used as part > of daily summary > > https://groups.google.com/forum/?fromgroups#!searchin/weewx-user/wind$20column%7Csort:date/weewx-user/siTLWVi_fLM/hMwqeKygBwAJ > > - so introducing a wind column was probably not the correct thing to do in > the first place. You probably need to go back to the original problem and > solve that one > > > > On Monday, 5 November 2018 14:32:15 UTC+2, Jonis Maurin Ceará wrote: >> >> Hi. >> >> I have weewx 3.8.1 running on my RPi for almost one year. Last week my >> archive page stoped working and looking for any problem, I found some >> problems in database query....but looking for solutions in this group, I >> found that was related to saving time here in Brazil, which changed to one >> week later than usual. >> After waiting this one week, problem persist. The problem is that 'wind' >> column does not exist in database (Mysql or sqlite). >> After creating this field (as double), I got another error: Invalid >> aggregation type 'gustdir' >> >> What could be wrong? I'm using MySQL. >> >> What I've done: remove of weewx package (I'm using .deb on raspberry pi >> with debian 9.4), remove all databases and files (including /var/lib/weewx >> and /usr/share/weex, /etc/weex) everything.....and reinstall package, leave >> with default configuration and simulator. Weewx create new databases >> (tested with sqlite and mysql), but still with same error on both tests! >> >> This is the first error and the second (after creating wind column). >> >> cheetahgenerator: Generate failed with exception '<class >>> 'weedb.NoColumnError'>' >>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: **** Ignoring >>> template /etc/weewx/skins/Standard/week.html.tmpl >>> Nov 5 10:05:19 SkyWeather weewx[30088]: cheetahgenerator: **** Reason: >>> no such column: wind >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** Traceback (most recent >>> call last): >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** print >> _file, >>> compiled_template >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>> __str__ >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** rc = getattr(self, >>> mainMethName)() >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 949, in respond >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 245, in __errorCatcher26 >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File "<string>", line >>> 1, in <module> >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** return >>> self._do_query(aggregate_type) >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** val=val, >>> **self.option_dict) >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** return >>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>> aggregateType, **option_dict) >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** **option_dict) >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** _row = >>> self.getSql(select_stmt % interpolate_dict) >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** _cursor.execute(sql, >>> sqlargs) >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** File >>> "/usr/share/weewx/weedb/sqlite.py", line 41, in guarded_fn >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** raise >>> weedb.NoColumnError(e) >>> Nov 5 10:05:19 SkyWeather weewx[30088]: **** NoColumnError: no such >>> column: wind >> >> >> >> Second: >> >> Nov 5 10:25:16 SkyWeather weewx[30611]: manager: Added record 2018-11-05 >>> 10:25:00 -02 (1541420700) to database 'weewx' >>> Nov 5 10:25:16 SkyWeather weewx[30611]: manager: Added record >>> 2018-11-05 10:25:00 -02 (1541420700) to daily summary in 'weewx' >>> Nov 5 10:25:18 SkyWeather weewx[30611]: cheetahgenerator: Generate >>> failed with exception '<class 'weewx.ViolatedPrecondition'>' >>> Nov 5 10:25:18 SkyWeather weewx[30611]: cheetahgenerator: **** Ignoring >>> template /etc/weewx/skins/Standard/week.html.tmpl >>> Nov 5 10:25:18 SkyWeather weewx[30611]: cheetahgenerator: **** Reason: >>> Invalid aggregation type 'gustdir' >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** Traceback (most recent >>> call last): >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** print >> _file, >>> compiled_template >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>> __str__ >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** rc = getattr(self, >>> mainMethName)() >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 952, in respond >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "_etc_weewx_skins_Standard_week_html_tmpl.py", line 252, in __errorCatcher27 >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File "<string>", line >>> 1, in <module> >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** return >>> self._do_query(aggregate_type) >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** val=val, >>> **self.option_dict) >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** return >>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>> aggregateType, **option_dict) >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** **option_dict) >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 449, in getAggregate >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** raise >>> weewx.ViolatedPrecondition("Invalid aggregation type '%s'" % aggregate_type) >>> Nov 5 10:25:18 SkyWeather weewx[30611]: **** ViolatedPrecondition: >>> Invalid aggregation type 'gustdir' >>> Nov 5 10:25:20 SkyWeather weewx[30611]: cheetahgenerator: Generated 13 >>> files for report StandardReport in 3.53 seconds >>> Nov 5 10:25:21 SkyWeather weewx[30611]: imagegenerator: Generated 12 >>> images for StandardReport in 1.19 seconds >>> Nov 5 10:25:21 SkyWeather weewx[30611]: copygenerator: copied 0 files >>> to /var/www/html/weewx >> >> >> >> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
