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/CAPq0zEBMpN9vQJ3Q9kKJU8h%3DPYGCyG-net4ipCG8MYmaqrNXFw%40mail.gmail.com.
