[mythtv-users] Previous recordings have disappeared

[Darby Vicker]

On Wed, Jan 30, 2019 at 8:45 PM Bill Meek <keemllib at gmail.com> wrote:
>
> On 1/30/19 9:20 PM, Darby Vicker wrote:
> > On Wed, Jan 30, 2019 at 9:06 AM Bill Meek <keemllib at gmail.com> wrote:
> >>
> >> On 1/29/19 10:48 PM, Darby Vicker wrote:
> >> ...
> >>
> >>>>
> >>>>        http://yourBackendIPorHostname:6544/Dvr/GetRecordedList
> >>>>        http://yourBackendIPorHostname:6544/Myth/GetHostName
> >>>>
> >>
> >> ...
> >>
> >>>
> >>> Progress!  The first URL returns a list of the recordings, but this is
> >>> at the top:
> >>>
> >>> This page contains the following errors:
> >>> error on line 1 at column 256491: Char 0x0 out of allowed range
> >>> Below is a rendering of the page up to the first error.
> >>>
> >>> What follows that is a very long list of unformatted text.  Here is
> >>> the last part of that:
> >>
> >> A single line is expected. I'd do this:
> >>
> >>     curl --output /tmp/recordinglist.out --silent yourBackendIPorHostname:6544/Dvr/GetRecordedList
> >>
> >> The /tmp/recordinglist.out will have the single line. Using an editor,
> >> find the 256491th character. Then look at the surrounding text to locate
> >> the offending recording. You should see keys like: <Title> and <StartTime>
> >> nearby. In vi, 25648l would position on it, if starting at the 1st character.
> >>
> >> Above if Roger's suggestion doesn't locate the error. It's also very possible
> >> that there's another problem after this one, and the column # would change. If
> >> you end up chasing too many faults, restoring from an old backup may be the
> >> solution.
> >
> > It looks like this is the problem:
> >
> > <ChannelName>KQD^@</ChannelName>
> >
> > I looked at the http://yourBackendIPorHostname:6544/Dvr/wsdl and its
> > not immediately clear how to use that to delete a recording. If anyone
> > has some pointers to identifying and then deleting those recordings,
> > that would be helpful.
>
> See: https://www.mythtv.org/wiki/DVR_Service#DeleteRecording
>
> You can use curl again. If the <RecordedId> is in available, it's easier.
> Otherwise, you need ChanId and StartTime. Something like:
>
>    curl --data RecordedId=fromYourDump yourBackendIPorHostname:6544/Dvr/DeleteRecording
>
> I assume KQD is one of the "other channels" you cleaned up in a previous
> post.
>

Excellent - thanks for reference to delete the recording.

I think KQD is one of the other channels I cleaned up.  I've got a
recording going on now but when its done I'm going to check.

It looks like I have quite a few showings recorded from the KQD
channel - its in the list output from curl 10+ times.  Can I perform
surgery on the SQL database to remove the problem character and save
the recordings or is that going to cause other problems?  I can think
of two ways to do this - 1) straight SQL commands or 2) make a backup
(which I'll do anyway), make a copy of that, modify the copy and the
restore the copy.