That did it! I found I'm running the v4.0 schema, and the [[wx_binding] section of weewx.conf matches the new schema configuration. After doing a drop-daily and rebuild-daily, and waiting for the next archive intervals, it all came back. Thanks very much for your assistance!
On Thursday, November 11, 2021 at 9:20:04 AM UTC-5 William Reinhardt wrote: > Thanks for the info! I'll be sure the schema matches above. It's very > likely I'm trying to mix schemas. Will let you know what happens. > > On Wednesday, November 10, 2021 at 7:07:02 PM UTC-5 [email protected] > wrote: > >> How a database schema is specified changed in V4.0. The newer >> wview_extended schema uses the new way, the older wview schema uses the old >> way. My hunch is that you're mixing the new way and the old way. >> >> Take a look in the [[wx_binding]] section of weewx.conf. You want either: >> >> # Old way, using wview schema >> [DataBindings] >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_sqlite >> # The name of the table within the database >> table_name = archive >> # The manager handles aggregation of data for historical summaries >> manager = weewx.wxmanager.WXDaySummaryManager >> # The schema defines the structure of the database. >> # It is *only* used when the database is created. >> schema = schemas.wview.schema >> >> >> # New way, using wview_extended schema >> [DataBindings] >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_sqlite >> # The name of the table within the database >> table_name = archive >> # The manager handles aggregation of data for historical summaries >> manager = weewx.manager.DaySummaryManager >> # The schema defines the structure of the database. >> # It is *only* used when the database is created. >> schema = schemas.wview_extended.schema >> >> If you're using the older wview schema, make sure the manager is set to >> weewx.wxmanager.WXDaySummaryManager. Then, use wee_database to drop, then >> rebuild the daily summaries. >> >> -tk >> >> >> >> >> On Wed, Nov 10, 2021 at 3:45 PM William Reinhardt <[email protected]> >> wrote: >> >>> Hello all, >>> >>> Back in July, I successfully added a couple new observation types >>> ("appTemp" and "cloudbase") to my SQLite database by following these >>> instructions: >>> >>> https://github.com/poblabs/weewx-belchertown/wiki/Adding-a-new-observation-type-to-the-WeeWX-database >>> >>> Inexplicably, the "archive_day_wind" table was missing afterwards! The >>> other wind-related tables ("archive_day_windDir", "archive_day_windGust," >>> etc.) are still in the database, just the "wind" table is missing. I'll >>> post the Debug errors from the syslog at the end of this post. Let me know >>> if you need more. It also shows up on my weather station website at >>> www.woodvilleweather.com. In the "Weather Records Snapshot" section, >>> the Average and Highest Wind data show as $day.wind.avg, >>> $month.wind.avg, etc., with similar errors since July 2021 in the Reports >>> page. I verified the absence of the table using a SQLite database viewer to >>> open old database backups from before and after I added the observations in >>> July. >>> >>> My question is: how can I regain the wind table? Is there a wee_database >>> command to add this table? Add a new observation type and call it "wind"? >>> Copy-paste from a backup database and rebuild the daily data? My weather >>> station stores no data so I can't get it from there. It's been a busy >>> summer and I'm now just getting time to play with this and get my WEEWX box >>> working 100% again. Thanks for any ideas. >>> >>> -Bill >>> >>> *Debug info:* >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $day.wind.max >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $day.wind.maxtime >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $day.wind.gustdir >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $day.wind.avg >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $day.wind.vecdir >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $day.wind.vecavg >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $day.wind.rms >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $week.wind.max >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $week.wind.maxtime >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $week.wind.gustdir >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $week.wind.avg >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $week.wind.vecdir >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $week.wind.vecavg >>> Nov 10 18:30:30 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $week.wind.rms >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $month.wind.max >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $month.wind.maxtime >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $month.wind.gustdir >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $month.wind.avg >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $month.wind.vecdir >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $month.wind.vecavg >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $month.wind.rms >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $year.wind.max >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $year.wind.maxtime >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $year.wind.gustdir >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $year.wind.avg >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $year.wind.vecdir >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $year.wind.vecavg >>> Nov 10 18:30:31 WX_WS1 weewx[29868] DEBUG weewx.cheetahgenerator: >>> Unrecognized: $year.wind.rms >>> >>> -- >>> 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]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/766f2e09-9b9f-4604-a939-a406e31b1639n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/766f2e09-9b9f-4604-a939-a406e31b1639n%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3c433e5b-b957-4a6e-9768-a2be20a3b494n%40googlegroups.com.
