[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