See my post above in this topic : https://groups.google.com/d/msg/weewx-user/ARBHWDXiDpQ/7cz4m-Q7BAAJ. <https://groups.google.com/d/msg/weewx-user/ARBHWDXiDpQ/7cz4m-Q7BAAJ>
phil On Monday, December 10, 2018 at 11:22:58 AM UTC-5, Wes Witt wrote: > > 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
