[mythtv] [mythtv-commits] Ticket #7373: Table 'mythconverg.weatherdatalayout' doesn't exist

[Michael T. Dean]

On 10/20/2009 03:16 AM, Fa wrote:
> I just remembered what happened now.  Awhile back when I upgraded from one
> of the fedora to another fedora version, mysql was upgraded and it had some
> problems with a table.  The table was probably related to mythweather and I
> nuked that table and never used mythweather since then. So I think the
> problem existed for a long time and not related to the myth upgrade.  I
> think you can close the ticket, it probably has nothig todo with upgrading
> from 0.21 to 0.22...

Great.  In that case, you can fix your DB and make the upgrade succeed 
(and actually create the MythWeather tables) with:

mysql -umythtv -p mythconverg \
-e 'DELETE FROM settings WHERE value = "WeatherDBSchemaVer";'

Thanks for the quick response.

Mike