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

Michael T. Dean mtdean at thirdcontact.com
Tue Oct 20 07:23:20 UTC 2009

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.


More information about the mythtv-dev mailing list