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.
