following. i'm interested in using apptemp to but would like to know what is necessary to get the archive table configured properly.
On Monday, December 10, 2018 at 7:54:39 AM UTC-8, Philip Kutzenco wrote: > > This is likely a naive question on my part. But did you extend the schema > on the archive table for your database to include appTemp? Assuming so, did > you rebuild the daily value tables? Are the values in the archive table and > the archive_day_appTemp table being populated? When I look at your website, > your daily.json data shows appTemp with a value of "N/A".phil > > > On Monday, December 10, 2018 at 10:09:52 AM UTC-5, G Hammer wrote: >> >> Here's the rest of the pertinent log entries that Groups cut off: >> Dec 10 09:55:50 ftp weewx[13683]: **** raise weedb. >> NoColumnError(e) >> Dec 10 09:55:50 ftp weewx[13683]: **** NoColumnError: no such >> column: appTemp >> Dec 10 09:55:50 ftp weewx[13683]: **** Generator terminated >> Dec 10 09:55:50 ftp weewx[13683]: copygenerator: copied 0 files to /home/ >> weewx/public_html/weather >> >> >> >> On Monday, December 10, 2018 at 10:07:01 AM UTC-5, G Hammer wrote: >>> >>> Pat, >>> >>> When I have show_apptemp=1 I do see the Feels like temp as I expect. >>> If I set highcharts_show_apptemp = 1 I do not get an apptemp plot, the >>> report generator errors out: >>> Dec 10 09:55:50 ftp weewx[13683]: reportengine: Caught unrecoverable >>> exception in generator weewx.cheetahgenerator.CheetahGenerator >>> Dec 10 09:55:50 ftp weewx[13683]: **** no such column: appTemp >>> Dec 10 09:55:50 ftp weewx[13683]: **** Traceback (most recent >>> call last): >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/reportengine.py", line 239, in run >>> Dec 10 09:55:50 ftp weewx[13683]: **** obj.start() >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/reportengine.py", line 273, in start >>> Dec 10 09:55:50 ftp weewx[13683]: **** self.run() >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/cheetahgenerator.py", line 158, in run >>> Dec 10 09:55:50 ftp weewx[13683]: **** ngen = self.generate >>> (gen_dict[section_name], self.gen_ts) >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/cheetahgenerator.py", line 232, in generate >>> Dec 10 09:55:50 ftp weewx[13683]: **** ngen += self. >>> generate(section[subsection], gen_ts) >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/cheetahgenerator.py", line 232, in generate >>> Dec 10 09:55:50 ftp weewx[13683]: **** ngen += self. >>> generate(section[subsection], gen_ts) >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/cheetahgenerator.py", line 320, in generate >>> Dec 10 09:55:50 ftp weewx[13683]: **** default_binding) >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/cheetahgenerator.py", line 372, in _getSearchList >>> Dec 10 09:55:50 ftp weewx[13683]: **** searchList += obj. >>> get_extension_list(timespan, db_lookup) >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/user/belchertown_highchartsSearchX.py", line 85, in >>> get_extension_list >>> Dec 10 09:55:50 ftp weewx[13683]: **** (time_start_vt, >>> time_stop_vt, appTemp_vt) = db_lookup().getSqlVectors(TimeSpan(_start_ts >>> , _end_ts), 'appTemp') >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/manager.py", line 512, in getSqlVectors >>> Dec 10 09:55:50 ftp weewx[13683]: **** aggregate_type, >>> aggregate_interval) >>> Dec 10 09:55:50 ftp weewx[13683]: **** File >>> "/home/weewx/bin/weewx/manager.py", line 775, in _getSqlVectors >>> Dec 10 09:55:50 ftp weewx[13683]: **** for _rec in _cursor. >>> execute(sql_str, (startstamp, stopstamp)): >>> Dec 10 09:55<span style="color: #660;" class="styled-by-prettif >>> >> -- 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.
