[mythtv-users] Unset "damaged" flag

[mythtv at kosowsky.org]

John Pilkington wrote at about 10:45:14 +0100 on Monday, April 22, 2019:
 > On 22/04/2019 10:29, Stephen Worthington wrote:
 > > On Mon, 22 Apr 2019 00:16:51 -0400, you wrote:
 > > 
 > >> I have a recording that seems to have the "damaged" flag set due to
 > >> the recording ending early.
 > >> Luckily, I missed only the last few seconds which are not important.
 > >>
 > >> Is there any way to *unset* the damaged flag from the GUI?
 > >> I would prefer not to muck directly with the sql tables.
 > > 
 > > No, there is no way to do it from the GUI.  And I do not know of
 > > anything in the Services API that would allow you to do it either. The
 > > DAMAGED flag is a flag in the recordedprogram.videoprop field. There
 > > are other flags in that field, so when you turn off DAMAGED, you have
 > > to do it in a way that will retain the other flags.
 > > 
 > > Here is one of mine:
 > > 
 > > MariaDB [mythconverg]> select chanid,starttime,title,videoprop from
 > > recordedprogram where find_in_set('DAMAGED',videoprop) and title='Safe
 > > House';
 > > +--------+---------------------+------------+----------------------------------+
 > > | chanid | starttime           | title      | videoprop                        |
 > > +--------+---------------------+------------+----------------------------------+
 > > |   1003 | 2017-11-28 08:15:00 | Safe House | HDTV,WIDESCREEN,AVC,1080,DAMAGED |
 > > +--------+---------------------+------------+----------------------------------+
 > > 1 row in set (0.00 sec)
 > > 
 > > So to turn off the DAMAGED flag for that one the SQL might be:
 > > 
 > > update recordedprogram set videoprop='HDTV,WIDESCREEN,AVC,1080' where
 > > chanid=1003 and starttime='2017-11-28 08:15:00';
 > 
 > I see this quite often, too: a recording that plays acceptably but is 
 > marked as damaged.  It's not a major problem but it would be good to 
 > have a supported fix.
 > 

Thanks John.
This worked like a charm.
But agree there should be a GUI to toggle flags, similar to how you
can edit titles/subtitles/descriptions.
My guess is most people don't know how to or at least don't relish
playing with live SQL tables...

Thanks!
Jeff