Thomas, I mixed my answers...but is not config mistake. I've made tests
with both drivers, sqlite and MySQL, both has the same problem/error (with
their corresponding errors/drivers).
Em segunda-feira, 5 de novembro de 2018 11:16:39 UTC-2, Thomas Keffer
escreveu:
>
> 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á <jmc...@gmail.com
> <javascript:>> 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+...@googlegroups.com <javascript:>.
>> 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.
