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 <hathaway.d...@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 <
> juanantoniomosqu...@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.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 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 weewx[17746]: ****    File
>>>>>>>>>>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in 
>>>>>>>>>>>>>> generate
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: ****
>>>>>>>>>>>>>> default_binding)
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: ****    File
>>>>>>>>>>>>>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in 
>>>>>>>>>>>>>> _getSearchList
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: ****
>>>>>>>>>>>>>> searchList += obj.get_extension_list(timespan, db_lookup)
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: ****    File
>>>>>>>>>>>>>> "/usr/share/weewx/user/belchertown_highchartsSearchX.py", line 
>>>>>>>>>>>>>> 440, in
>>>>>>>>>>>>>> get_extension_list
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: ****
>>>>>>>>>>>>>> rain_round.append( round( rainsql[1], 2) )
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: ****  TypeError: a
>>>>>>>>>>>>>> float is required
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: ****  Generator
>>>>>>>>>>>>>> terminated
>>>>>>>>>>>>>> Aug 28 07:45:39 meteomontaos weewx[17746]: copygenerator:
>>>>>>>>>>>>>> copied 22 files to /var/www/html/weewx/belchertown
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Greetings and thanks.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> El martes, 28 de agosto de 2018, 3:16:41 (UTC+2), Pat
>>>>>>>>>>>>>> escribió:
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Belchertown skin 0.5 is released
>>>>>>>>>>>>>>> <https://github.com/poblabs/weewx-belchertown/releases>.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> This should fix the NOAA reports and day charts. Tested it
>>>>>>>>>>>>>>> against sqlite and mysql, and in a couple different timezones. 
>>>>>>>>>>>>>>> Please let
>>>>>>>>>>>>>>> me know if it persists.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>>> Few other fixes and updates listed in the release notes.
>>>>>>>>>>>>>>>
>>>>>>>>>>>>>> --
>>>>>>>>>>>>>> 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+...@googlegroups.com.
>>>>>>>>>>>>>> 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 weewx-user+...@googlegroups.com.
>>>>>>>>>>> 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
>> 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.

Reply via email to