The confusing thing is that this is the part that throws an exception:
<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>
Should this work?
The exception is NoColumnError: (1054, "Unknown column 'wind' in 'where
clause'")
On Fri, Aug 31, 2018 at 2:05 PM Thomas Keffer <[email protected]> wrote:
> It all depends on what you want.
>
> In what follows, I am assuming that option loop_hilo
> <http://weewx.com/docs/usersguide.htm#StdArchive> is set to true (the
> normal state of affairs). Much of this information is also in the section
> *Wind
> <http://www.weewx.com/docs/customizing.htm#Wind>*.
>
> $day.wind.max is the maximum wind speed seen during the day (including
> LOOP packets). It's obtained from the daily summaries.
> $day.windGust.max is the same. However, because windGust does not appear
> in the daily summaries, it is calculated from the archive data.
> $day.windSpeed.max is the max average wind speed. This is calculated from
> the archive data. The wind is averaged over each of the archive intervals,
> then the maximum of these values is taken. This is different from the above
> two tags.
>
> Generally, you work with $day.wind.*something. *This is because, for the
> average user, it's easier to just tell him/her to work with 'wind' and not
> worry about how it got flattened. $day.wind.max is natural,
> $day.windGust.max is not.
>
> Also, it's much more efficient to calculate things from the daily archives.
>
> On Fri, Aug 31, 2018 at 11:15 AM Pat <[email protected]> wrote:
>
>> You're right, this is confusing. I do have one tmpl with
>> day/week/month/year.wind. Are you suggesting that I change the week/month
>> to the proper windGust, windSpeed, etc? or change all 4 types since
>> day/year can be used in aggregation?
>>
>> On Friday, August 31, 2018 at 12:43:26 PM UTC-4, Thomas Keffer wrote:
>>>
>>> The tag "wind" can only be used in aggregations, such as day and year.
>>> The tags windSpeed, windDir, windGust, and windGustDir can be used for
>>> current observations, as well as aggregations. This is all explained in the
>>> Customizing Guide, section *Wind
>>> <http://www.weewx.com/docs/customizing.htm#Wind>*.
>>>
>>> Confusing, I know. It's the product of a legacy schema from wview, and
>>> the need to flatten vector-like quantities into a two dimensional SQL
>>> table. A more general solution would have been a separate table for each
>>> type (much like the daily summaries), but that would break compatibility
>>> with wview, as well as be slower.
>>>
>>> -tk
>>>
>>> On Fri, Aug 31, 2018 at 9:16 AM Pat O'Brien <[email protected]>
>>> wrote:
>>>
>>> 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 <[email protected]> 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 <[email protected]>
>>> 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:* [email protected] [mailto:[email protected]] *On
>>> Behalf Of *David Hathaway
>>> *Sent:* Friday, August 31, 2018 9:07 AM
>>> *To:* weewx-user <[email protected]>
>>> *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]>
>>> 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]> 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
>>>
>>> ...
>>
>> --
>> 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.
>>
> --
> 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
> [email protected].
> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
