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.
