[mythtv-users] [Bulk] Re: Mythnews disappears and Music schema update notice

Ian Evans dheianevans at gmail.com
Thu Sep 24 04:22:20 UTC 2015


On Wed, Sep 23, 2015 at 3:28 PM, Paul Harrison <mythtv at sky.com> wrote:

>
> On 23/09/15 19:30, Ian Evans wrote:
>
>> On Wed, Sep 23, 2015 at 4:47 AM, Paul Harrison <mythtv at sky.com <mailto:
>> mythtv at sky.com>> wrote:
>>
>>
>>     Each plugin has it own schema version and we store the version in
>>     the settings table so for MythNews it's 'NewsDBSchemaVer'.
>>
>>     The database upgrade code looks at the schema version in the
>>     settings table and only attempts to update it if it is lower than
>>     the actually schema version.
>>
>>     Assuming no update to the plugins was performed this looks like a
>>     DB corruption problem of some sort so running
>>     <http://optimize_mythdb.pl><http://optimize_mythdb.pl>
>>     opttimize_mythdb.pl would be a good idea.
>>
>>     If you have dropped the MythNews table you will have to remove the
>>     'NewsDBSchemaVer' schema version setting in the settings table to
>>     get the plugin to recreate the tables.
>>
>>
>> Just to clarify your last sentence...if I uninstall
>> Mythnews/weather/music, and drop their tables, I then set the corresponding
>> SchemaVer to blank? i.e UPDATE settings SET NewsDBSchemaVer='';
>>
>>
> That should be more like:
> UPDATE settings SET data = '' WHERE value = 'NewsDBSchemaVer';
>
> but in this case I would just remove the setting and allow the plugin to
> recreate it.
> DELETE FROM settings WHERE value = 'NewsDBSchemaVer';
>
> You shouldn't need to re-install anything unless you suspect something
> other than the DB is corrupt - just close the frontend before you do
> anything and when it's restarted the plugins will create the tables and
> setting for you. IIRC when the FE starts you will be prompted do you want
> to backup and update the DB.
>
> If as Mike suggested the various plugin DB tables are infact correct but
> it's the various *DBSchemaVer settings that are wrong you could first try
> updating the *DBSchemaVer values in the settings table to match the schema
> versions that way you wont have to recreate all your news feeds, weather
> settings and music settings.
>
> Looks like they should be for 0.27.5-fixes :-
> NewsDBSchemaVer  1001
> MusicDBSchemaVer  1020
> WeatherDBSchemaVer 1006
>
> For the record, here are the other values:
>>
>> DBSchemaVer     1317     NULL
>> ArchiveDBSchemaVer     1005     NULL
>> GameDBSchemaVer     1016     NULL
>> MusicDBSchemaVer     1000     NULL
>> PhoneDBSchemaVer     1001     NULL
>> WeatherDBSchemaVer     1000     NULL
>> BrowserDBSchemaVer     1002     NULL
>> NetvisionDBSchemaVer     1004     NULL
>> NewsDBSchemaVer     1000     NULL
>> WebDBSchemaVer     4     NULL
>> GalleryDBSchemaVer     1003     NULL
>>
>>
> Really strange how it has only affected those plugin. If you haven't
> already done it I would run opttimize_mythdb.pl just to be sure.
>
>
I updated those three values. Restarted the frontend and all three plugins
were working fine.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20150924/daeb8160/attachment.html>


More information about the mythtv-users mailing list