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.
