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 <kin...@gmail.com > <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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.