[mythtv-users] Mythvideo: series suddenly renames itself

Raymond Wagner raymond at wagnerrp.com
Thu Jan 19 03:41:11 UTC 2012

On 1/18/2012 22:30, Nick Rout wrote:
> On Thu, Jan 19, 2012 at 4:27 PM, Raymond Wagner<raymond at wagnerrp.com>  wrote:
>> On 1/18/2012 22:22, Nick Rout wrote:
>>> OR mysql: delete from videometadata where filename like '%arrested%'
>> and potentially leave a bunch of orphaned cruft in the database.
> OK, my bad.
> Can you clarify? i know direct manipulation of mythconverg is frowned
> on, but out of curiosity, what other tables are linked to
> videometadata? What cruft might i be leaving?

Off the top of my head, videocategory and filemarkup reference 
videometadata directly.  Then you have crosslinks in videometadatacast, 
videometadatacountry, and videometadatagenre, which link with videocast, 
videocountry, and videogenre, respectively.  The links should be 
deleted, but the cast, country, and genre entries could potentially be 
in use with other videos.

The recording tables have a housekeeper task that runs daily and removes 
any such orphaned cruft if the primary entry in 'recorded' is manually 
removed, but the video tables have no such routine.

More information about the mythtv-users mailing list