I guess he means this "feels like" which as far as I know is a derived/calculated field in the skin
[image: image.png] On Sun, 21 Jan 2024 at 03:13, Tom Keffer <tkef...@gmail.com> wrote: > Richard, you're going to have to give us more information than this. The > only reference to "feels like" that I can find in the Belchertown skin has > been commented out. Where are you seeing this? > > On Fri, Jan 19, 2024 at 7:25 PM Richard Whitcombe <whitcomb...@gmail.com> > wrote: > >> Actually follow up that ive only just noticed. >> Since performing this fix ive lost the "Feels like" temperature display >> on my skin on all pages. >> >> On Friday 19 January 2024 at 19:47:31 UTC+9 Richard Whitcombe wrote: >> >>> I just did AppTemperature but its working for me. >>> Although i dont think i use any of the other columns as my station >>> doesnt provide it. >>> >>> Missing data calculations took about 8 minutes for 7 years of data on a >>> Pi4. >>> >>> On Friday 19 January 2024 at 19:14:09 UTC+9 mh081...@gmail.com wrote: >>> >>>> Hi, >>>> >>>> as i read in the other posts about this Problem i doing now following. >>>> >>>> weectl database add-column appTemp >>>> weectl database add-column cloudbase >>>> weectl database add-column visibility >>>> weectl database add-column windrun >>>> weectl database add-column cloud_cover >>>> weectl database add-column aqi >>>> >>>> weectl database calc-missing >>>> >>>> Answer all wit 'y' >>>> >>>> Now it seems that the Problem was solved. Belchertown Reports was >>>> generated in about 6 seconds. Thanks @vince for your right direction. >>>> ############################## >>>> Jan 19 11:09:50 wetter weewxd[293936]: INFO weewx.engine: Loading >>>> station type Vantage (weewx.drivers.vantage) >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: StdConvert >>>> target unit is 0x1 >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.wxservices: >>>> StdWXCalculate will use data binding wx_binding >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: Archive will >>>> use data binding wx_binding >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: Record >>>> generation will be attempted in 'hardware' >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: Using archive >>>> interval of 300 seconds (specified by hardware) >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: >>>> StationRegistry: Registration not requested. >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: >>>> Wunderground-PWS: Data for station IMECKLEN47 will be posted >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: >>>> Data for station MHROSTOCK will be posted >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: CWOP: Posting >>>> not enabled. >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: WOW: Posting >>>> not enabled. >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.restx: AWEKAS: >>>> Posting not enabled. >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: service version >>>> is 0.23 >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: binding to >>>> ['archive', 'loop'] >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: topic is weather >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: desired unit >>>> system is METRIC >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: data will be >>>> uploaded to mqtt://pi:x...@gw.martenhinrichs.de:8883/ >>>> <http://pi:x...@gw.martenhinrichs.de:8883/> >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO user.mqtt: network >>>> encryption/authentication will be attempted >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO weewx.engine: 'pyephem' >>>> detected, extended almanac data is available >>>> Jan 19 11:09:53 wetter weewxd[293936]: INFO __main__: Starting up weewx >>>> version 5.0.0 >>>> Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.engine: Clock error >>>> is 2.69 seconds (positive is fast) >>>> Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.engine: Using binding >>>> 'wx_binding' to database 'weewx.sdb' >>>> Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.manager: Starting >>>> backfill of daily summaries >>>> Jan 19 11:09:54 wetter weewxd[293936]: INFO weewx.manager: Daily >>>> summaries up to date >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.wxxtypes: Type >>>> beaufort has been deprecated. Use unit beaufort instead. >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 10:50:00 CET (1705657800) to database 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 10:50:00 CET (1705657800) to daily summary in 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 10:55:00 CET (1705658100) to database 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 10:55:00 CET (1705658100) to daily summary in 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 11:00:00 CET (1705658400) to database 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 11:00:00 CET (1705658400) to daily summary in 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: >>>> Published record 2024-01-19 10:50:00 CET (1705657800) >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 11:05:00 CET (1705658700) to database 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 11:05:00 CET (1705658700) to daily summary in 'weewx.sdb' >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.engine: Starting main >>>> packet loop. >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: >>>> Published record 2024-01-19 10:55:00 CET (1705658100) >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: >>>> Published record 2024-01-19 11:00:00 CET (1705658400) >>>> Jan 19 11:09:56 wetter weewxd[293936]: INFO weewx.restx: >>>> Wunderground-PWS: Published record 2024-01-19 10:50:00 CET (1705657800) >>>> Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: >>>> Wunderground-PWS: Published record 2024-01-19 10:55:00 CET (1705658100) >>>> Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: >>>> Published record 2024-01-19 11:05:00 CET (1705658700) >>>> Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: >>>> Wunderground-PWS: Published record 2024-01-19 11:00:00 CET (1705658400) >>>> Jan 19 11:09:57 wetter weewxd[293936]: INFO weewx.restx: >>>> Wunderground-PWS: Published record 2024-01-19 11:05:00 CET (1705658700) >>>> Jan 19 11:10:01 wetter CRON[293953]: (root) CMD >>>> (/root/get_picture_camera1.sh >/dev/null 2>&1) >>>> Jan 19 11:10:01 wetter CRON[293954]: (root) CMD >>>> (/root/get_picture_webcam.sh >/dev/null 2>&1) >>>> Jan 19 11:10:01 wetter CRON[293956]: (root) CMD >>>> (/root/get_picture_camera2.sh >/dev/null 2>&1) >>>> Jan 19 11:10:17 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 11:10:00 CET (1705659000) to database 'weewx.sdb' >>>> Jan 19 11:10:17 wetter weewxd[293936]: INFO weewx.manager: Added record >>>> 2024-01-19 11:10:00 CET (1705659000) to daily summary in 'weewx.sdb' >>>> Jan 19 11:10:18 wetter weewxd[293936]: INFO weewx.restx: >>>> Wunderground-PWS: Published record 2024-01-19 11:10:00 CET (1705659000) >>>> Jan 19 11:10:18 wetter weewxd[293936]: INFO weewx.restx: PWSWeather: >>>> Published record 2024-01-19 11:10:00 CET (1705659000) >>>> Jan 19 11:10:19 wetter weewxd[293936]: INFO weewx.cheetahgenerator: >>>> Generated 8 files for report SeasonsReport in 0.99 seconds >>>> Jan 19 11:10:20 wetter weewxd[293936]: INFO weewx.imagegenerator: >>>> Generated 30 images for report SeasonsReport in 1.42 seconds >>>> Jan 19 11:10:20 wetter weewxd[293936]: INFO weewx.reportengine: Copied >>>> 5 files to /var/www/html/weewx >>>> Jan 19 11:10:20 wetter weewxd[293936]: INFO user.belchertown: version >>>> 1.3.1 >>>> Jan 19 11:10:23 wetter weewxd[293936]: INFO user.belchertown: New >>>> forecast file downloaded to /var/www/html/json/forecast.json >>>> Jan 19 11:10:26 wetter weewxd[293936]: INFO weewx.cheetahgenerator: >>>> Generated 12 files for report Belchertown in 6.25 seconds >>>> Jan 19 11:10:26 wetter weewxd[293936]: INFO weewx.reportengine: Copied >>>> 40 files to /var/www/html >>>> >>>> ####################################################################################################### >>>> >>>> >>>> >>>> >>>> >>>> mh081...@gmail.com schrieb am Freitag, 19. Januar 2024 um 10:32:55 >>>> UTC+1: >>>> >>>>> Hi, >>>>> >>>>> as you wish. I have no extra/extended schema in my database. >>>>> ##### >>>>> root@wetter:~# echo "select count(*) from >>>>> pragma_table_info('archive');" | sqlite3 /var/tmp/test.sdb >>>>> 52 >>>>> ##### >>>>> >>>>> >>>>> vince schrieb am Freitag, 19. Januar 2024 um 08:32:51 UTC+1: >>>>> >>>>>> Followup on this one - If the original poster can check to see if >>>>>> their database uses the old original (small) wview schema that would >>>>>> likely >>>>>> help. Easiest way is to look to see how many elements are in the >>>>>> database. >>>>>> One way to see how many elements you have in your db would be: >>>>>> >>>>>> - cp weewx.sdb /var/tmp/test.sdb >>>>>> - echo "select count(*) from pragma_table_info('archive');" | >>>>>> sqlite3 /var/tmp/test.sdb >>>>>> - (my db with the extended schema returns "114" as the count) >>>>>> - (a db with the original wview schema returns "52" as the >>>>>> count) >>>>>> >>>>>> >>>>>> Switching to the extended schema is a bit of work and takes some >>>>>> time. The details are documented at >>>>>> http://www.weewx.com/docs/5.0/custom/database/ with the procedure >>>>>> for how to switch to the new bigger schema in >>>>>> http://www.weewx.com/docs/5.0/custom/database/#reconfigure-using-new-schema >>>>>> - but be CAREFUL doing this and ALWAYS work off a copy of your db so if >>>>>> anything happens you can revert to a known good db. I've done it so >>>>>> many >>>>>> years ago at this point that I'll have to defer to others for pitfalls >>>>>> and >>>>>> how they do it, but the links above are how the current docs recommend >>>>>> doing so. >>>>>> >>>>>> Short description to the original Belchertown problem reporters - >>>>>> check your db schema. Hopefully that's the pattern of which systems will >>>>>> need to take action. >>>>>> >>>>>> >>>>>> -- >> 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. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/768238c2-f5ff-4efc-9e34-7ac2bbc490a4n%40googlegroups.com >> <https://groups.google.com/d/msgid/weewx-user/768238c2-f5ff-4efc-9e34-7ac2bbc490a4n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/CAPq0zEAtK9FVeuO4qztKS_xD%2B_QdzdhRFuM%3DotnjgU1w5%3DwuNQ%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAPq0zEAtK9FVeuO4qztKS_xD%2B_QdzdhRFuM%3DotnjgU1w5%3DwuNQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > -- 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. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CACjxfUsrHmfFrvPhaN3jdQtb2vGw40uF8Y0moNP4deAKRMkHNg%40mail.gmail.com.
