<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Wed, Sep 23, 2015 at 3:28 PM, Paul Harrison <span dir="ltr"><<a href="mailto:mythtv@sky.com" target="_blank">mythtv@sky.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><br>
On 23/09/15 19:30, Ian Evans wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
On Wed, Sep 23, 2015 at 4:47 AM, Paul Harrison <<a href="mailto:mythtv@sky.com" target="_blank">mythtv@sky.com</a> <mailto:<a href="mailto:mythtv@sky.com" target="_blank">mythtv@sky.com</a>>> wrote:<br>
<br>
<br>
Each plugin has it own schema version and we store the version in<br>
the settings table so for MythNews it's 'NewsDBSchemaVer'.<br>
<br>
The database upgrade code looks at the schema version in the<br>
settings table and only attempts to update it if it is lower than<br>
the actually schema version.<br>
<br>
Assuming no update to the plugins was performed this looks like a<br>
DB corruption problem of some sort so running<br></span>
<<a href="http://optimize_mythdb.pl" rel="noreferrer" target="_blank">http://optimize_mythdb.pl</a>><<a href="http://optimize_mythdb.pl" rel="noreferrer" target="_blank">http://optimize_mythdb.pl</a>><br>
<a href="http://opttimize_mythdb.pl" rel="noreferrer" target="_blank">opttimize_mythdb.pl</a> would be a good idea.<span class=""><br>
<br>
If you have dropped the MythNews table you will have to remove the<br>
'NewsDBSchemaVer' schema version setting in the settings table to<br>
get the plugin to recreate the tables.<br>
<br>
<br>
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='';<br>
<br>
</span></blockquote>
<br>
That should be more like:<br>
UPDATE settings SET data = '' WHERE value = 'NewsDBSchemaVer';<br>
<br>
but in this case I would just remove the setting and allow the plugin to recreate it.<br>
DELETE FROM settings WHERE value = 'NewsDBSchemaVer';<br>
<br>
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.<br>
<br>
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.<br>
<br>
Looks like they should be for 0.27.5-fixes :-<br>
NewsDBSchemaVer 1001<br>
MusicDBSchemaVer 1020<br>
WeatherDBSchemaVer 1006<span class=""><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
For the record, here are the other values:<br>
<br>
DBSchemaVer 1317 NULL<br>
ArchiveDBSchemaVer 1005 NULL<br>
GameDBSchemaVer 1016 NULL<br>
MusicDBSchemaVer 1000 NULL<br>
PhoneDBSchemaVer 1001 NULL<br>
WeatherDBSchemaVer 1000 NULL<br>
BrowserDBSchemaVer 1002 NULL<br>
NetvisionDBSchemaVer 1004 NULL<br>
NewsDBSchemaVer 1000 NULL<br>
WebDBSchemaVer 4 NULL<br>
GalleryDBSchemaVer 1003 NULL<br>
<br>
</blockquote>
<br></span>
Really strange how it has only affected those plugin. If you haven't already done it I would run <a href="http://opttimize_mythdb.pl" rel="noreferrer" target="_blank">opttimize_mythdb.pl</a> just to be sure.<div class="HOEnZb"><div class="h5"><br></div></div></blockquote></div><br></div><div class="gmail_extra">I updated those three values. Restarted the frontend and all three plugins were working fine.<br></div></div>