Hi Pat, I updated. If anyone is following along, belchertown_highchartsSearchX.py went into /usr/share/weewx/user .
I have the following error, but I am not sure where I would see a hole? Aug 28 08:53:46 localhost weewx[10317]: cheetahgenerator: Generate failed with exception '<class 'weedb.NoColumnError'>' Aug 28 08:53:46 localhost weewx[10317]: cheetahgenerator: **** Ignoring template /etc/weewx/skins/Belchertown/records/index.html.tmpl Aug 28 08:53:46 localhost weewx[10317]: cheetahgenerator: **** Reason: (1054, "Unknown column 'wind' in 'where clause'") Aug 28 08:53:46 localhost weewx[10317]: **** Traceback (most recent call last): Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate Aug 28 08:53:46 localhost weewx[10317]: **** print >> _file, compiled_template Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in __str__ Aug 28 08:53:46 localhost weewx[10317]: **** rc = getattr(self, mainMethName)() Aug 28 08:53:46 localhost weewx[10317]: **** File "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1109, in respond Aug 28 08:53:46 localhost weewx[10317]: **** File "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in __errorCatcher46 Aug 28 08:53:46 localhost weewx[10317]: **** File "<string>", line 1, in <module> Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ Aug 28 08:53:46 localhost weewx[10317]: **** return self._do_query(aggregate_type) Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weewx/tags.py", line 343, in _do_query Aug 28 08:53:46 localhost weewx[10317]: **** val=val, **self.option_dict) Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate Aug 28 08:53:46 localhost weewx[10317]: **** return weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, aggregateType, **option_dict) Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate Aug 28 08:53:46 localhost weewx[10317]: **** **option_dict) Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate Aug 28 08:53:46 localhost weewx[10317]: **** _row = self.getSql(select_stmt % interpolate_dict) Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weewx/manager.py", line 394, in getSql Aug 28 08:53:46 localhost weewx[10317]: **** _cursor.execute(sql, sqlargs) Aug 28 08:53:46 localhost weewx[10317]: **** File "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn Aug 28 08:53:46 localhost weewx[10317]: **** raise klass(e) Aug 28 08:53:46 localhost weewx[10317]: **** NoColumnError: (1054, "Unknown column 'wind' in 'where clause'") Aug 28 08:54:05 localhost weewx[10317]: cheetahgenerator: Generated 15 files for report Belchertown in 108.92 seconds Aug 28 08:54:05 localhost weewx[10317]: copygenerator: copied 1 files to /var/www/html/weewx/belchertown On Tue, Aug 28, 2018 at 7:43 AM Pat <p...@obrienphoto.net> wrote: > 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.
