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

Hika van den Hoven hikavdh at gmail.com
Wed Sep 23 09:13:41 UTC 2015


Hoi Paul,

Wednesday, September 23, 2015, 10:47:29 AM, you wrote:

> On 23/09/15 08:55, Hika van den Hoven wrote:
>>> Here's the thing...removing mythweather, music and news doesn't delete the
>>> corresponding tables, even if you use purge in apt-get.
>>> So when you reinstall and fire up the frontend, it gives the same
>>> complaints about the tables.
>>> HOWEVER, if you drop the tables after purging and reinstalling, the
>>> frontend log complains it can't find the tables in order to upgrade them.
>>> So purging/reinstalling doesn't seem to recreate/initialize the tables.
>>> I gotta sleep...but I appreciate your help. Hopefully you and others will
>>> see the issue and I'll fight the good fight when I wake up.
>>> Thanks!
>> I'm surprised! I would expect the same proces that caused the problem
>> to recreate the tables. How then if you add a plug-in to a running
>> system? Normally on a fresh or updated system the frontend when first
>> run does this!
>>
>>

> 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 optimize_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.

> Paul H.
> _______________________________________________

Thanks also on behalf of Ian. So his problem could have come from
corruption of that value! Does optimize_mythdb.pl check on those
version values? I mean, deeper then just comparing?

The weird thing is that his problem was a wrongfully attempt at
upgrading, but when he dropped the table it did nothing?

Tot mails,
  Hika                            mailto:hikavdh at gmail.com

"Zonder hoop kun je niet leven
Zonder leven is er geen hoop
Het eeuwige dilemma
Zeker als je hoop moet vernietigen om te kunnen overleven!"

De lerende Mens



More information about the mythtv-users mailing list