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.
