[mythtv-users] missing database tables (weather)

[Ryan Patterson]

On Sun, Apr 17, 2016 at 9:01 PM, Michael T. Dean <mtdean at thirdcontact.com>
wrote:

> On 04/17/2016 02:08 PM, Ryan Patterson wrote:
>
>> During my preparations for upgrading to mythtv 0.28,
>> mythconverg_backup.pl <http://mythconverg_backup.pl> failed to produce a
>> usable database backup.  It errors because table
>> mythconverg.weatherdatalayout is not present.
>>
>> I'm not sure why the backup script is dependent on those tables.
>>
>
> It's not.  Your database shows that those tables exist, but they don't.
> Therefore, your MySQL database (not MySQL Server, but the mythconverg
> database you're using on it) is broken.
>
>   I stopped using mythweather a long time ago.  But I certainly didn't
>> manually remove the tables.
>>
>> Running optimize_mythdb.pl <http://optimize_mythdb.pl> does not show any
>> errors or warnings.
>>
>> But mysqlcheck complains about three missing tables:
>> weatherdatalayout
>> weatherscreens
>> weathersourcesettings
>>
>> I recompiled mythplugins with mythweather enabled.  I hoped running
>> mythweather would create the missing tables.  But when I try and view or
>> configure mythweather the frontend logs tons of SQL errors because of the
>> missing tables.
>>
>> Any suggestions for how I can fix this?
>>
>
> http://www.gossamer-threads.com/lists/mythtv/users/419174#419174
>
> (and you won't need MythWeather plugin installed nor to re-create the
> tables).
>

Last night I figured out that the offending tables where in some sort of
half existing state.  But I wasn't sure how to resolve it without some
manual DB hacking.

After running the (simple and obvious in hindsight) SQL you linked to,
mythconverg_backup.pl runs to completion without issue.  Thanks.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160418/c92313dc/attachment.html>