Pat Not being funny but don't you think that Belchertown skin threads are more suited to the development forum - or even maybe a forum of its own! I'm getting a flood of emails all the time from these threads. It appears to be very much work in progress as the current beta testers/users work their way through issues!!!!!
On Tuesday, 28 August 2018 16:59:31 UTC+3, David Hathaway wrote: > > 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 <javascript:>> > 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+...@googlegroups.com <javascript:>. >> 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.
