> Do you mean this section of weewx.conf? Yep
> Will that mess up StandardReport? Don't believe so. It will change your URL that is displayed on weewx.com if you have register_this_station = true > I am on a quad core Xeon CPU at 3.30Ghz, 16GB RAM, and an SSD main drive. So basically a server. Hmm.... the highcharts do a lot of queries so an extended generation time is expected but not sure why it's 2 minutes. Maybe your tables needs to be optimized? There are ways to tune MySQL which may be something to check out too? On Monday, August 27, 2018 at 11:58:28 AM UTC-4, David Hathaway wrote: > > Do you mean this section of weewx.conf? > > # If you have a website, you may specify an URL > station_url = http://dave77459.mynetgear.com/weewx/ > > Will that mess up StandardReport? Heck, I'll try it and see. Easy to > change back. > > I am on a quad core Xeon CPU at 3.30Ghz, 16GB RAM, and an SSD main drive. > Hardly anything takes time on this system. > > I'll give --rebuild-daily a try. I have a backup from yesterday, but I'll > make another first. > > > On Mon, Aug 27, 2018 at 10:31 AM Pat <[email protected] <javascript:>> > wrote: > >> 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 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 >> [email protected] <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 [email protected]. For more options, visit https://groups.google.com/d/optout.
