Sylvain,
You are impacted by the very issue we are discussing. It looks like you
can avoid the error by modifying *records/index.html.tmpl *around line 132
FROM:
<td class="leftborder">$alltime.*wind*.maxtime.format("%B %-d, %Y at %-I:%M
%p")</td>
<td>$alltime.*wind*.max</td>
TO:
<td class="leftborder">$alltime.*windGust*.maxtime.format("%B %-d, %Y at
%-I:%M %p")</td>
<td>$alltime.*windGust*.max</td>
The issue as described above is limited to the $alltime.wind variable.
With this change, you will get a log entry like
cheetahgenerator: Generated 16 files for report Belchertown in 134.22
seconds
but in your case it looks to be 14 minutes instead of 2.
If you can live without the graphs (I can't), turning them off makes the
generation quick. I went from 134.22 seconds to 0.99 seconds. To do that,
that set highcharts_enabled = 0 in Extras. I moved my Belchertown settings
to weewx.conf, and I suggest you do the same so they aren't overwritten in
updates:
[StdReport]
# Where the skins reside, relative to WEEWX_ROOT
SKIN_ROOT = /etc/weewx/skins
# Where the generated reports should go, relative to WEEWX_ROOT
HTML_ROOT = /var/www/html/weewx
# The database binding indicates which data should be used in reports.
data_binding = wx_binding
# Each of the following subsections defines a report that will be run.
[[Belchertown]]
HTML_ROOT = /var/www/html/weewx/belchertown
skin = Belchertown
[[[Extras]]]
forecast_enabled = 1
*highcharts_enabled = 0*
darksky_secret_key = thisisheretotakeupspace
earthquake_enabled = 1
site_title = The Hill
footer_copyright_text = The Hill
radar_html = <iframe width="650" height="360" src="
https://embed.windy.com/embed2.html?yoururl"; frameborder="0"></iframe>
[[StandardReport]]
etc
On Sat, Sep 1, 2018 at 7:01 AM Sylvain Martel <kinw...@gmail.com> wrote:
>
>
> On Saturday, 1 September 2018 07:39:32 UTC-4, Sylvain Martel wrote:
>>
>> With the skin installed, the reports thread never finish. Usually it
>> takes 15-50 seconds to generate them(Raspberry Pi 2) but it never finish
>> now. Any clue?
>>
>
>
> Update: Finally got this error after waiting 14 mins:
> ep 1 07:59:03 Pi2 weewx-sto2[11171]: cheetahgenerator: Generate failed
> with exception '<class 'weedb.NoColumnError'>'
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: cheetahgenerator: **** Ignoring
> template /etc/weewx/skins/Belchertown/records/index.html.tmpl
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: cheetahgenerator: **** Reason:
> (1054, "Unknown column 'wind' in 'where clause'")
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** Traceback (most recent call
> last):
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** print >> _file,
> compiled_template
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in
> __str__
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** rc = getattr(self,
> mainMethName)()
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1124, in
> respond
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in
> __errorCatcher46
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File "<string>", line 1, in
> <module>
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** return
> self._do_query(aggregate_type)
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** val=val,
> **self.option_dict)
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** return
> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type,
> aggregateType, **option_dict)
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** **option_dict)
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** _row =
> self.getSql(select_stmt % interpolate_dict)
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weewx/manager.py", line 394, in getSql
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** _cursor.execute(sql,
> sqlargs)
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** File
> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** raise klass(e)
> Sep 1 07:59:03 Pi2 weewx-sto2[11171]: **** NoColumnError: (1054,
> "Unknown column 'wind' in 'where clause'")
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "weewx-user" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/weewx-user/GSrKZEiPqsc/unsubscribe.
> To unsubscribe from this group and all its topics, 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.
