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:* [email protected] <javascript:> [mailto:
> [email protected] <javascript:>] *On Behalf Of *David Hathaway
> *Sent:* Friday, August 31, 2018 9:07 AM
> *To:* weewx-user <[email protected] <javascript:>>
> *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 <[email protected]
> <javascript:>> 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 <
> [email protected] <javascript:>> 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 <[email protected]> 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 <[email protected]>
> 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 <
> [email protected]> 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.highchartsDay',
> 'user.belchertown_highchartsSearchX.highchartsWeek',
> 'user.belchertown_highchartsSearchX.highchartsMonth',
> 'user.belchertown_highchartsSearchX.highchartsYear']
>
> Aug 28 07:42:35 meteomontaos weewx[17746]: manager: Daily summary version
> is 2.0
>
> Aug 28 07:42:46 meteomontaos weewx[17746]: wmr300: dump history is disabled
>
> Aug 28 07:43:08 meteomontaos weewx[17746]: wmr300: dump history is disabled
>
> Aug 28 07:43:15 meteomontaos sudo[19974]: pam_unix(sudo:session): session
> closed for user root
>
> Aug 28 07:44:31 meteomontaos weewx[17746]: wmr300: dump history is disabled
>
> Aug 28 07:44:52 meteomontaos weewx[17746]: wmr300: dump history is disabled
>
> Aug 28 07:45:12 meteomontaos weewx[17746]: wmr300: dump history is disabled
>
> Aug 28 07:45:32 meteomontaos weewx[17746]: wmr300: dump history is disabled
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: reportengine: Caught
> unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** a float is required
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** Traceback (most recent
> call last):
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** File
> "/usr/share/weewx/weewx/reportengine.py", line 239, in run
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** obj.start()
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** File
> "/usr/share/weewx/weewx/reportengine.py", line 273, in start
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** self.run()
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** File
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** ngen =
> self.generate(gen_dict[section_name], self.gen_ts)
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** File
> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate
>
> Aug 28 07:45:39 meteomontaos weewx[17746]: **** ngen +=
> self.generate(section[subsection], gen_ts)
>
> Aug 28 07:45:39 meteomontaos w
>
>
--
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.
