[mythtv-users] Unset "damaged" flag
mythtv at kosowsky.org
mythtv at kosowsky.org
Mon Apr 22 12:21:39 UTC 2019
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
More information about the mythtv-users
mailing list