I feel like a problem child at this point. Maybe I should email you directly rather than via this group? No worries if you want to continue this way though.
Commenting out the NOAA reports got it to run...ish. - I got a "NoColumnError" in the wind section. See log below. I commented out the Wind Records section of the records\index.html.tmpl to continue on. - The skin is taking 2 minutes to be generated. Is this expected? In contrast, StandardReport takes 0.75 seconds. - The resulting page is broken as if it is missing all content. See it here: http://dave77459.mynetgear.com/weewx/belchertown/ Aug 27 09:53:16 localhost weewx[22819]: cheetahgenerator: Generated 14 files for report StandardReport in 1.18 seconds Aug 27 09:53:17 localhost weewx[22819]: imagegenerator: Generated 16 images for StandardReport in 1.54 seconds Aug 27 09:54:14 localhost weewx[22819]: manager: Added record 2018-08-27 09:54:00 CDT (1535381640) to database 'weewx' Aug 27 09:54:14 localhost weewx[22819]: manager: Added record 2018-08-27 09:54:00 CDT (1535381640) to daily summary in 'weewx' Aug 27 09:54:14 localhost weewx[22819]: engine: Launch of report thread aborted: existing report thread still running Aug 27 09:54:15 localhost weewx[22819]: restx: Wunderground-PWS: Published record 2018-08-27 09:54:00 CDT (1535381640) Aug 27 09:54:35 localhost weewx[22819]: cheetahgenerator: Generate failed with exception '<class 'weedb.NoColumnError'>' Aug 27 09:54:35 localhost weewx[22819]: cheetahgenerator: **** Ignoring template /etc/weewx/skins/Belchertown/records/index.html.tmpl Aug 27 09:54:35 localhost weewx[22819]: cheetahgenerator: **** Reason: (1054, "Unknown column 'wind' in 'where clause'") Aug 27 09:54:35 localhost weewx[22819]: **** Traceback (most recent call last): Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 330, in generate Aug 27 09:54:35 localhost weewx[22819]: **** print >> _file, compiled_template Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/lib/python2.7/dist-packages/Cheetah/Template.py", line 1005, in __str__ Aug 27 09:54:35 localhost weewx[22819]: **** rc = getattr(self, mainMethName)() Aug 27 09:54:35 localhost weewx[22819]: **** File "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 1109, in respond Aug 27 09:54:35 localhost weewx[22819]: **** File "_etc_weewx_skins_Belchertown_records_index_html_tmpl.py", line 385, in __errorCatcher46 Aug 27 09:54:35 localhost weewx[22819]: **** File "<string>", line 1, in <module> Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weewx/tags.py", line 329, in __getattr__ Aug 27 09:54:35 localhost weewx[22819]: **** return self._do_query(aggregate_type) Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weewx/tags.py", line 343, in _do_query Aug 27 09:54:35 localhost weewx[22819]: **** val=val, **self.option_dict) Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weewx/wxmanager.py", line 60, in getAggregate Aug 27 09:54:35 localhost weewx[22819]: **** return weewx.manager.DaySummaryManager.getAggregate(self, timespan, obs_type, aggregateType, **option_dict) Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weewx/manager.py", line 1249, in getAggregate Aug 27 09:54:35 localhost weewx[22819]: **** **option_dict) Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weewx/manager.py", line 458, in getAggregate Aug 27 09:54:35 localhost weewx[22819]: **** _row = self.getSql(select_stmt % interpolate_dict) Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weewx/manager.py", line 394, in getSql Aug 27 09:54:35 localhost weewx[22819]: **** _cursor.execute(sql, sqlargs) Aug 27 09:54:35 localhost weewx[22819]: **** File "/usr/share/weewx/weedb/mysql.py", line 48, in guarded_fn Aug 27 09:54:35 localhost weewx[22819]: **** raise klass(e) Aug 27 09:54:35 localhost weewx[22819]: **** NoColumnError: (1054, "Unknown column 'wind' in 'where clause'") Aug 27 09:54:54 localhost weewx[22819]: cheetahgenerator: Generated 13 files for report Belchertown in 96.59 seconds Aug 27 09:54:54 localhost weewx[22819]: copygenerator: copied 22 files to /var/www/html/weewx/belchertown On Monday, August 27, 2018 at 9:44:55 AM UTC-5, David Hathaway wrote: > > OK, I will try that and see if that gets the rest going. > > On Mon, Aug 27, 2018 at 9:37 AM Pat <> wrote: > >> Thanks. I'm aware of this error but haven't resolved it yet. It's a >> problem with NOAA reports being generated. >> >> My thought is to move the NOAA reports to another skin, but I'm afraid >> that'll be too much extra work for everyone who installs the skin. >> >> If you want to stop it from happening, open skin.conf and remove the >> NOAA_month >> and NOAA_year sections - which will get the skin working but will not >> produce the NOAA reports. >> >> >> On Monday, August 27, 2018 at 10:22:23 AM UTC-4, David Hathaway wrote: >>> >>> I updated MySQL to stop throwing that error, updated to weewx v 3.8.2, >>> and installed Belchertown 0.4. Now I get this error: >>> >>> Aug 27 09:17:16 localhost weewx[4131]: imagegenerator: Generated 16 >>> images for StandardReport in 0.75 seconds >>> Aug 27 09:17:47 localhost weewx[4131]: reportengine: Caught >>> unrecoverable exception in generator weewx.cheetahgenerator.CheetahGenerator >>> Aug 27 09:17:47 localhost weewx[4131]: **** start time >>> (1535346000) is greater than stop time (1420092000) >>> Aug 27 09:17:47 localhost weewx[4131]: **** Traceback (most >>> recent call last): >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weewx/reportengine.py", line 239, in run >>> Aug 27 09:17:47 localhost weewx[4131]: **** obj.start() >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weewx/reportengine.py", line 273, in start >>> Aug 27 09:17:47 localhost weewx[4131]: **** self.run() >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 158, in run >>> Aug 27 09:17:47 localhost weewx[4131]: **** ngen = >>> self.generate(gen_dict[section_name], self.gen_ts) >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>> Aug 27 09:17:47 localhost weewx[4131]: **** ngen += >>> self.generate(section[subsection], gen_ts) >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 232, in generate >>> Aug 27 09:17:47 localhost weewx[4131]: **** ngen += >>> self.generate(section[subsection], gen_ts) >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 320, in generate >>> Aug 27 09:17:47 localhost weewx[4131]: **** default_binding) >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weewx/cheetahgenerator.py", line 372, in _getSearchList >>> Aug 27 09:17:47 localhost weewx[4131]: **** searchList += >>> obj.get_extension_list(timespan, db_lookup) >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/user/belchertown_highchartsSearchX.py", line 88, in >>> get_extension_list >>> Aug 27 09:17:47 localhost weewx[4131]: **** (time_start_vt, >>> time_stop_vt, outTemp_vt) = db_lookup().getSqlVectors(TimeSpan(_start_ts, >>> timespan.stop), 'outTemp') >>> Aug 27 09:17:47 localhost weewx[4131]: **** File >>> "/usr/share/weewx/weeutil/weeutil.py", line 315, in __new__ >>> Aug 27 09:17:47 localhost weewx[4131]: **** raise >>> ValueError("start time (%d) is greater than stop time (%d)" % (args[0], >>> args[1])) >>> Aug 27 09:17:47 localhost weewx[4131]: **** ValueError: start >>> time (1535346000) is greater than stop time (1420092000) >>> Aug 27 09:17:47 localhost weewx[4131]: **** Generator terminated >>> Aug 27 09:17:47 localhost weewx[4131]: copygenerator: copied 1 files to >>> /var/www/html/weewx/belchertown >>> >>> >>> On Monday, August 27, 2018 at 8:35:00 AM UTC-5, David Hathaway wrote: >>>> >>>> Thanks Pat. I moved the options into weewx.conf after reading that >>>> suggestion. >>>> >>>> On Mon, Aug 27, 2018 at 8:03 AM Pat <> wrote: >>>> >>>>> I'd suggest using the latest release >>>>> <https://github.com/poblabs/weewx-belchertown/releases>. No issues >>>>> with upgrading if all your Belchertown options are within weewx.conf. See >>>>> the GitHub readme <https://github.com/poblabs/weewx-belchertown> for >>>>> those options. >>>>> >>>>> >> -- 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.
