[mythtv-users] mythweb header information error

Michael T. Dean mtdean at thirdcontact.com
Mon Nov 23 17:56:03 UTC 2009

On 11/23/2009 12:35 PM, Mark Boyum wrote:
>> mysql -umythtv -p mythconverg -e 'SHOW ENGINES;'
>> And verify there's a line with Engine 'InnoDB' with Support set to 'YES'.
>> Then, you can restore the last backup you had from when MythWeather worked
>> (but you'll lose all changes to settings /and/ all recordings and ... since
>> that backup), or--my suggestion--since MythWeather has no real data (and
>> only a bit of configuration), just recreate the MythWeather schema:
>> cat << "EOF" | mysql -umythtv -p mythconverg
>> DELETE TABLE IF EXISTS weathersourcesettings;
>> DELETE TABLE IF EXISTS weatherscreens;
>> DELETE TABLE IF EXISTS weatherdatalayout;
>> DELETE FROM settings WHERE value = 'WeatherDBSchemaVer';
>> EOF
>> Then restart mythfrontend.
> Thanks Mike and GXL,
> That did it!  Although I replaced "DELETE TABLE" with "DROP TABLE" to get it
> to execute.

Heh, yeah.  I shouldn't send e-mails when I'm tired.  Long weekend.


More information about the mythtv-users mailing list