Got it, thanks :)
On Saturday, 1 September 2018 09:36:15 UTC-4, David Hathaway wrote:
>
> 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 <[email protected]
> <javascript:>> 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 getAggreg
>
> ...
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
