[mythtv-users] Corrupt/missing weather DB tables

[Chuck Filson]

On May 21, 2008 11:56:59 pm Dusty Herrman wrote:
> I just had a power surge and it looks like I have some corrupted/missing
> DB tables.  Can someone please give me the descriptions of the tables
> (and maybe some of the data in them)?
>
> The tables are: weatherdatalayout, weatherscreens, and
> weathersourcesettings.
>
> Thanks in advance

	Backup your database first ... then try the following.

	Delete the value of "WeatherDBSchemaVer" in the database and also delete 
those three tables, then MythWeather should create and update the tables the 
next time it runs.

Chuck