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.