Hello, Jonis
You say you are using MySQL, but your first error was actually raised by
the sqlite driver. Check weewx.conf and make sure it is using the database
you think it is using.
-tk
On Mon, Nov 5, 2018 at 4:32 AM Jonis Maurin Ceará <jmce...@gmail.com> 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.
>
--
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.
