I'm on mobile, so I read this again. Maybe the difference is year.wind as opposed to day?
On Fri, Aug 31, 2018, 12:12 PM Pat O'Brien <p...@obrienphoto.net> wrote: > Interesting... Check this link as it is the official document. > > http://www.weewx.com/docs/customizing.htm > > Then search for "day.wind". You'll see the differences. > > > On Fri, Aug 31, 2018, 11:57 AM David Hathaway <hathaway.d...@gmail.com> > wrote: > >> Reckoned it was easy enough to try, so I changed the records code to >> >> <tr> >> <td>Strongest Wind Gust</td> >> <td class="leftborder">$year.windGust.max</td> >> <td>$year.windGust.maxtime.format("%B %-d, %Y at %-I:%M %p")</td> >> <td class="leftborder">$alltime.windGust.maxtime.format("%B %-d, %Y >> at %-I:%M %p")</td> >> <td>$alltime.windGust.max</td> >> </tr> >> >> (using windGust instead of wind) >> >> It does work in my installation. >> >> >> On Friday, August 31, 2018 at 9:32:23 AM UTC-5, David Hathaway wrote: >>> >>> This was the query right before the exception: >>> >>> >>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT dateTime >>> FROM archive WHERE dateTime > 1389475998 AND dateTime <= 1535720760 AND >>> wind = (SELECT MAX(wind) FROM archive WHERE dateTime > 1389475998 and >>> dateTime <= 1535720760) AND wind IS NOT NULL >>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: Generate failed >>> with exception '<class 'weedb.NoColumnError'>' >>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: **** Ignoring >>> template /etc/weewx/skins/Belchertown/records/index.html.tmpl >>> Aug 31 08:06:51 hathaway weewx[22213]: cheetahgenerator: **** Reason: >>> (1054, "Unknown column 'wind' in 'where clause'") >>> Aug 31 08:06:51 hathaway weewx[22213]: **** Traceback (most recent call >>> last): >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>> Aug 31 08:06:51 hathaway weewx[22213]: **** print >> _file, >>> compiled_template >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>> __str__ >>> Aug 31 08:06:51 hathaway weewx[22213]: **** rc = getattr(self, >>> mainMethName)() >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1123, in >>> respond >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in >>> __errorCatcher46 >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File "<string>", line 1, >>> in <module> >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>> Aug 31 08:06:51 hathaway weewx[22213]: **** return >>> self._do_query(aggregate_type) >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>> Aug 31 08:06:51 hathaway weewx[22213]: **** val=val, >>> **self.option_dict) >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>> Aug 31 08:06:51 hathaway weewx[22213]: **** return >>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>> aggregateType, **option_dict) >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 1252, in getAggregate >>> Aug 31 08:06:51 hathaway weewx[22213]: **** **option_dict) >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 461, in getAggregate >>> Aug 31 08:06:51 hathaway weewx[22213]: **** _row = >>> self.getSql(select_stmt % interpolate_dict) >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weewx/manager.py", line 397, in getSql >>> Aug 31 08:06:51 hathaway weewx[22213]: **** _cursor.execute(sql, >>> sqlargs) >>> Aug 31 08:06:51 hathaway weewx[22213]: **** File >>> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn >>> Aug 31 08:06:51 hathaway weewx[22213]: **** raise klass(e) >>> Aug 31 08:06:51 hathaway weewx[22213]: **** NoColumnError: (1054, >>> "Unknown column 'wind' in 'where clause'") >>> Aug 31 08:06:51 hathaway weewx[22213]: manager: getSQL: SELECT >>> MIN(dateTime) FROM archive >>> >>> If I comment out this part, I don't get the exception: >>> >>> #if $Extras.has_key('show_windrun') >>> and $Extras.show_windrun == '1' >>> <tr> >>> <td class="records-header" >>> colspan=5>Wind Records</td> >>> </tr> >>> <tr> >>> <td class="records-header" >>> colspan=1> </td> >>> <td class="records-header" >>> colspan=2>$current.dateTime.format("%Y")</td> >>> <td >>> class="records-header-alltime" colspan=2>All Time</td> >>> </tr> >>> <tr> >>> <td>Strongest Wind Gust</td> >>> <td >>> class="leftborder">$year.wind.max</td> >>> >>> <td>$year.wind.maxtime.format("%B %-d, %Y at %-I:%M %p")</td> >>> <td >>> class="leftborder">$alltime.wind.maxtime.format("%B %-d, %Y at %-I:%M >>> %p")</td> >>> <td>$alltime.wind.max</td> >>> >>> </tr> >>> #end if >>> >>> Perhaps instead of $year.wind.maxtime it should be >>> $year.windGust.maxtime ? >>> >>> >>> >>> >>> On Friday, August 31, 2018 at 8:13:59 AM UTC-5, Pat wrote: >>>> >>>> As far as I know, my skin isn’t specifying a query for wind. A search >>>> on the repo in GitHub shows that the columns I query are “windSpeed, >>>> windGust”, etc. >>>> >>>> >>>> >>>> Anything for “wind” is done through a built in weewx call for >>>> $day.wind, $week.wind, etc. >>>> >>>> >>>> >>>> Where do you see this query? >>>> >>>> >>>> >>>> >>>> >>>> *From:* weewx...@googlegroups.com [mailto:weewx...@googlegroups.com] *On >>>> Behalf Of *David Hathaway >>>> *Sent:* Friday, August 31, 2018 9:07 AM >>>> *To:* weewx-user <weewx...@googlegroups.com> >>>> *Subject:* Re: [weewx-user] Re: Belchertown skin for weewx now >>>> available! >>>> >>>> >>>> >>>> Well, this is interesting. Here is a statement that fails: >>>> >>>> >>>> >>>> SELECT dateTime FROM archive WHERE dateTime > 1389475998 AND dateTime >>>> <= 1535720400 AND wind = (SELECT MAX(wind) FROM archive WHERE dateTime > >>>> 1389475998 and dateTime <= 1535720400) AND wind IS NOT NULL >>>> >>>> >>>> >>>> My schema has windSpeed, windDir, windGust, and windGustDir. Should it >>>> have plain old 'wind'? >>>> >>>> >>>> >>>> Dave >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Fri, Aug 31, 2018 at 7:50 AM David Hathaway <hathaw...@gmail.com> >>>> wrote: >>>> >>>> I'd like to solve my "wind" issue, since I have to modify the template >>>> on each revision. What table is lacking "wind"? >>>> >>>> >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator: **** Ignoring >>>> template /etc/weewx/skins/Belchertown/records/index.html.tmpl >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: cheetahgenerator: **** Reason: >>>> (1054, "Unknown column 'wind' in 'where clause'") >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** Traceback (most recent >>>> call last): >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** print >> _file, >>>> compiled_template >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in >>>> __str__ >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** rc = getattr(self, >>>> mainMethName)() >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py", >>>> line 1124, in respond >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "cheetah__etc_weewx_skins_Belchertown_records_index_html_tmpl_1535719243_19_63343.py", >>>> line 385, in __errorCatcher46 >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File "<string>", line 1, >>>> in <module> >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** return >>>> self._do_query(aggregate_type) >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weewx/tags.py", line 343, in _do_query >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** val=val, >>>> **self.option_dict) >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** return >>>> weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, >>>> aggregateType, **option_dict) >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** **option_dict) >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** _row = >>>> self.getSql(select_stmt % interpolate_dict) >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weewx/manager.py", line 394, in getSql >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** _cursor.execute(sql, >>>> sqlargs) >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** File >>>> "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** raise klass(e) >>>> >>>> Aug 31 07:40:53 hathaway weewx[32401]: **** NoColumnError: (1054, >>>> "Unknown column 'wind' in 'where clause'") >>>> >>>> Aug 31 07:41:11 hathaway weewx[32401]: cheetahgenerator: Generated 15 >>>> files for report Belchertown in 113.97 seconds >>>> >>>> >>>> >>>> On Fri, Aug 31, 2018 at 1:27 AM Juan Antonio Mosquera < >>>> juananton...@juanantoniomosquera.com> wrote: >>>> >>>> Intall 0.6 version now... and same problem. My installation is wit >>>> APT.... >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Aug 31 08:25:17 meteomontaos weewx[14817]: reportengine: Found >>>> configuration file /etc/weewx/skins/Belchertown/skin.conf for report >>>> Belchertown >>>> >>>> Aug 31 08:25:18 meteomontaos weewx[14817]: cheetahgenerator: using >>>> search list ['weewx.cheetahgenerator.Almanac', >>>> 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', >>>> 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', >>>> 'weewx.cheetahgenerator.Extras', 'user.belchertown.getData', >>>> 'user.belchertown.getForecast', 'user.belchertown.getEarthquake', >>>> 'user.belchertown_highchartsSearchX.highchartsDay', >>>> 'user.belchertown_highchartsSearchX.highchartsWeek', >>>> 'user.belchertown_highchartsSearchX.highchartsMonth', >>>> 'user.belchertown_highchartsSearchX.highchartsYear'] >>>> >>>> Aug 31 08:25:18 meteomontaos weewx[14817]: manager: Daily summary >>>> version is 2.0 >>>> >>>> Aug 31 08:25:18 meteomontaos weewx[14817]: Belchertown Extension: >>>> version 0.6 >>>> >>>> Aug 31 08:25:25 meteomontaos wee_reports[16397]: reportengine: Caught >>>> unrecoverable exception in generator >>>> weewx.cheetahgenerator.CheetahGenerator >>>> >>>> Aug 31 08:25:25 meteomontaos wee_reports[16397]: **** start time >>>> (1514674800) is greater than stop time (1420066800) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** Traceback (most >>>> recent call last): >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 239, in run >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** obj.start() >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 273, in start >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** self.run() >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** ngen = >>>> self.generate(gen_dict[section_name], self.gen_ts) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** >>>> default_binding) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** searchList >>>> += obj.get_extension_list(timespan, db_lookup) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/user/belchertown_highchartsSearchX.py", line 1350, in >>>> get_extension_list >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** >>>> (time_start_vt, time_stop_vt, outTemp_vt) = >>>> db_lookup().getSqlVectors(TimeSpan(_start_ts, timespan.stop), 'outTemp', >>>> 'max', 86400) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** File >>>> "/usr/share/weewx/weeutil/weeutil.py", line 315, in __new__ >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** raise >>>> ValueError("start time (%d) is greater than stop time (%d)" % (args[0], >>>> args[1])) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** ValueError: >>>> start time (1514674800) is greater than stop time (1420066800) >>>> >>>> Aug 31 08:25:26 meteomontaos wee_reports[16397]: **** Generator >>>> terminated >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Greetings. >>>> >>>> >>>> El jueves, 30 de agosto de 2018, 20:14:47 (UTC+2), Pat escribió: >>>> >>>> Juan, how did you install weewx? APT/YUM or setup.py? >>>> >>>> On Thursday, August 30, 2018 at 2:27:32 AM UTC-4, Juan Antonio Mosquera >>>> wrote: >>>> >>>> Hi, my steps> >>>> >>>> >>>> >>>> pi@meteomontaos:~ $ sudo vim /etc/weewx/weewx.conf >>>> >>>> pi@meteomontaos:~ $ sudo wee_extension --install >>>> weewx-belchertown-0.5.tar.gz >>>> >>>> Request to install 'weewx-belchertown-0.5.tar.gz' >>>> >>>> Extracting from tar archive weewx-belchertown-0.5.tar.gz >>>> >>>> Saving installer file to /usr/share/weewx/user/installer/Belchertown >>>> >>>> Saved configuration dictionary. Backup copy at >>>> /etc/weewx/weewx.conf.20180830075700 >>>> >>>> Finished installing extension 'weewx-belchertown-0.5.tar.gz' >>>> >>>> pi@meteomontaos:~ $ sudo wee_extension --list >>>> >>>> Extension Name Version Description >>>> >>>> Belchertown 0.1 A clean modern skin with real time >>>> streaming updates and interactive charts. Modeled after >>>> BelchertownWeather.com >>>> >>>> csv 0.5 Emit loop or archive data in CSV format. >>>> >>>> pi@meteomontaos:~ $ sudo vim /etc/weewx/weewx.conf >>>> >>>> pi@meteomontaos:~ $ sudo service weewx stop >>>> >>>> pi@meteomontaos:~ $ sudo service weewx start >>>> >>>> pi@meteomontaos:~ $ sudo journalctl -f >>>> >>>> >>>> >>>> >>>> >>>> Change your .py and result> >>>> >>>> >>>> >>>> >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: reportengine: Caught >>>> unrecoverable exception in generator >>>> weewx.cheetahgenerator.CheetahGenerator >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** start time >>>> (1514674800) is greater than stop time (1420066800) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** Traceback (most recent >>>> call last): >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 239, in run >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** obj.start() >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 273, in start >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** self.run() >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** ngen = >>>> self.generate(gen_dict[section_name], self.gen_ts) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** default_binding) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** searchList += >>>> obj.get_extension_list(timespan, db_lookup) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/user/belchertown_highchartsSearchX.py", line 1350, in >>>> get_extension_list >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** (time_start_vt, >>>> time_stop_vt, outTemp_vt) = db_lookup().getSqlVectors(TimeSpan(_start_ts, >>>> timespan.stop), 'outTemp', 'max', 86400) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** File >>>> "/usr/share/weewx/weeutil/weeutil.py", line 315, in __new__ >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** raise >>>> ValueError("start time (%d) is greater than stop time (%d)" % (args[0], >>>> args[1])) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** ValueError: start time >>>> (1514674800) is greater than stop time (1420066800) >>>> >>>> Aug 30 08:25:41 meteomontaos weewx[11275]: **** Generator terminated >>>> >>>> >>>> >>>> >>>> >>>> >>>> El miércoles, 29 de agosto de 2018, 17:42:41 (UTC+2), Pat escribió: >>>> >>>> So you get that error with 0.5? Or you re-install and it is OK now? >>>> >>>> On Wednesday, August 29, 2018 at 11:32:36 AM UTC-4, Juan Antonio >>>> Mosquera wrote: >>>> >>>> I installed 0.5 version... and weewx 3.8.2 running in Raspberry Pi B+. >>>> And now... I uninstalled your extension. When extension running OK I >>>> install it. >>>> >>>> El miércoles, 29 de agosto de 2018, 17:24:27 (UTC+2), Pat escribió: >>>> >>>> Juan, which version did you install? This particular error should have >>>> been resolved in 0.5 >>>> <https://github.com/poblabs/weewx-belchertown/releases>. Please >>>> upgrade to that version. >>>> >>>> >>>> >>>> >>>> On Wednesday, August 29, 2018 at 11:16:52 AM UTC-4, Juan Antonio >>>> Mosquera wrote: >>>> >>>> My result is: >>>> >>>> >>>> >>>> >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: reportengine: Caught >>>> unrecoverable exception in generator >>>> weewx.cheetahgenerator.CheetahGenerator >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** start time >>>> (1514674800) is greater than stop time (1420066800) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** Traceback (most >>>> recent call last): >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 239, in run >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** obj.start() >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 273, in start >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** self.run() >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** ngen = >>>> self.generate(gen_dict[section_name], self.gen_ts) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** >>>> default_binding) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** searchList += >>>> obj.get_extension_list(timespan, db_lookup) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/user/belchertown_highchartsSearchX.py", line 1350, in >>>> get_extension_list >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** >>>> (time_start_vt, time_stop_vt, outTemp_vt) = >>>> db_lookup().getSqlVectors(TimeSpan(_start_ts, timespan.stop), 'outTemp', >>>> 'max', 86400) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** File >>>> "/usr/share/weewx/weeutil/weeutil.py", line 315, in __new__ >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** raise >>>> ValueError("start time (%d) is greater than stop time (%d)" % (args[0], >>>> args[1])) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** ValueError: start >>>> time (1514674800) is greater than stop time (1420066800) >>>> >>>> Aug 29 17:16:28 meteomontaos wee_reports[4760]: **** Generator >>>> terminated >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> Greetings. >>>> >>>> El martes, 28 de agosto de 2018, 14:43:42 (UTC+2), Pat escribió: >>>> >>>> Juan, David, give this attached file a try. >>>> >>>> >>>> >>>> I set a rain value in the archive table to NULL and saw it fail on >>>> MySQL and sqlite. >>>> >>>> >>>> >>>> Updated file skips NULL values >>>> >>>> >>>> >>>> Place it into your bin/user folder replacing the old one. Restart >>>> weewx, then either wait for an archive to happen, or run sudo >>>> wee_reports and let me know the results. >>>> >>>> >>>> >>>> Make sure you turn highcharts_enabled back to 1 to enable it. >>>> >>>> >>>> >>>> >>>> >>>> On Tuesday, August 28, 2018 at 7:16:32 AM UTC-4, David Hathaway wrote: >>>> >>>> Excellent, thanks! >>>> >>>> >>>> >>>> On Tue, Aug 28, 2018 at 6:14 AM Pat <p...@obrienphoto.net> wrote: >>>> >>>> You could set highcharts_enabled = 0 for the time being. I should have >>>> a test soon then can send you guys the file to try it yourself before I >>>> publish a release. >>>> >>>> >>>> >>>> On Tuesday, August 28, 2018 at 7:08:32 AM UTC-4, David Hathaway wrote: >>>> >>>> Pat, >>>> >>>> >>>> >>>> What config settings to comment out now to get past this issue for the >>>> moment? >>>> >>>> >>>> >>>> Dave >>>> >>>> >>>> >>>> On Tue, Aug 28, 2018 at 6:06 AM David Hathaway <hathaw...@gmail.com> >>>> wrote: >>>> >>>> Was about to report this very issue. So "me too" >>>> >>>> >>>> >>>> Aug 28 06:03:18 localhost weewx[4973]: imagegenerator: Generated 16 >>>> images for StandardReport in 0.78 seconds >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: reportengine: Caught >>>> unrecoverable exception in generator >>>> weewx.cheetahgenerator.CheetahGenerator >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** a float is required >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** Traceback (most >>>> recent call last): >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 239, in run >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** obj.start() >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/weewx/reportengine.py", line 273, in start >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** self.run() >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** ngen = >>>> self.generate(gen_dict[section_name], self.gen_ts) >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** ngen += >>>> self.generate(section[subsection], gen_ts) >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** >>>> default_binding) >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** searchList += >>>> obj.get_extension_list(timespan, db_lookup) >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** File >>>> "/usr/share/weewx/user/belchertown_highchartsSearchX.py", line 440, in >>>> get_extension_list >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** >>>> rain_round.append( round( rainsql[1], 2) ) >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** TypeError: a float >>>> is required >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: **** Generator >>>> terminated >>>> >>>> Aug 28 06:03:50 localhost weewx[4973]: copygenerator: copied 1 files to >>>> /var/www/html/weewx/belchertown >>>> >>>> >>>> >>>> >>>> >>>> On Tue, Aug 28, 2018 at 12:47 AM Juan Antonio Mosquera < >>>> juananton...@juanantoniomosquera.com> wrote: >>>> >>>> Hi. >>>> >>>> >>>> >>>> New problem now. >>>> >>>> >>>> >>>> >>>> >>>> Aug 28 07:42:34 meteomontaos weewx[17746]: reportengine: Running report >>>> Belchertown >>>> >>>> Aug 28 07:42:34 meteomontaos weewx[17746]: reportengine: Found >>>> configuration file /etc/weewx/skins/Belchertown/skin.conf for report >>>> Belchertown >>>> >>>> Aug 28 07:42:34 meteomontaos weewx[17746]: cheetahgenerator: using >>>> search list ['weewx.cheetahgenerator.Almanac', >>>> 'weewx.cheetahgenerator.Station', 'weewx.cheetahgenerator.Current', >>>> 'weewx.cheetahgenerator.Stats', 'weewx.cheetahgenerator.UnitInfo', >>>> 'weewx.cheetahgenerator.Extras', 'user.belchertown.getAllStats', >>>> 'user.belchertown.getForecast', 'user.belchertown.getEarthquake', >>>> 'user.belchertown.getNOAAdata', 'user.belchertown.getSocialShare', >>>> 'user.belchertown_highchartsSearchX. >>>> >>>> -- >> 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.