This way is fine. Problems and resolutions can help everyone if it's in the public forum.
I think I just resolved the error. In my highcharts Day function I'm defining an end point, yet still using the timespan (which causes the problem). Moving to my defined end point may have fixed it. Doing some testing with it now across a few lab systems to make sure. Then I'll issue 0.5 and we can give that a test. To answer some of your questions: The link to styles.css file is wrong. To fix this, change your weewx.conf's URL to "http://dave77459.mynetgear.com/weewx/belchertown"; and re-run the report. The 2 minute generation is for the highcharts section and it does seem high. Are you on a Pi? I have 3 years of data in my database and it takes 15 seconds to generate on a PC. A pi would be a bit slower. No column error with wind? Hmm. Not too sure on this. Could be database related. You can try to run sudo wee_database --rebuild-daily to rebuild the daily values and see if that helps. Make sure you have a *working backup of your database* just in case you need to revert back to it. On Monday, August 27, 2018 at 11:25:07 AM UTC-4, David Hathaway wrote: > > 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
