Mailing List Archive: MythTV: Users

Database Inconsistencies in 0.19

Index | Next | Previous | View Threaded

gavin at nodecaf

Mar 2, 2006, 11:16 AM

Post #1 of 6 (661 views)
Permalink

Database Inconsistencies in 0.19

Okay, just noticed this for the first time last night. Basically, I
upgraded to 0.19 with ATRPMS from 0.18.1. Everything works fine... but
there's one annoying little "feature" I've found.

Basically, some TV shows that were recorded months ago (sometimes as
long ago as a year) and deleted have suddenly reappeared in the
recording list. When I select them they tell me the files don't exist.

This isn't a huge deal... the problem only seems to have happened with
about a half dozen shows... but it is odd. Any thoughts on why this
would have happened? I presume that these are shows that were deleted,
but for some reason never cleaned up (perhaps deleted with the 0.18
version of Mythweb that would periodically drop my backend out when I
used it to schedule shows?).

Secondly... any ideas how to clean these up? I mean, other than editing
the database directly ;)

Gavin

mtdean at thirdcontact

Mar 2, 2006, 11:52 AM

Post #2 of 6 (638 views)
Permalink

Re: Database Inconsistencies in 0.19 [In reply to]

On 03/02/2006 02:16 PM, Gavin Haslett wrote:
> Basically, some TV shows that were recorded months ago (sometimes as
> long ago as a year) and deleted have suddenly reappeared in the
> recording list. When I select them they tell me the files don't exist.
>
> This isn't a huge deal... the problem only seems to have happened with
> about a half dozen shows... but it is odd. Any thoughts on why this
> would have happened? I presume that these are shows that were deleted,
> but for some reason never cleaned up (perhaps deleted with the 0.18
> version of Mythweb that would periodically drop my backend out when I
> used it to schedule shows?).
>
> Secondly... any ideas how to clean these up? I mean, other than
> editing the database directly ;)

You can just delete them (use the INFO or MENU key--I don't remember
which--then select Delete). You'll get a prompt saying that the file
doesn't exist and asking if you still want to delete the recording.
Answer yes and all is good.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

gavin at nodecaf

Mar 2, 2006, 5:21 PM

Post #3 of 6 (623 views)
Permalink

Re: Database Inconsistencies in 0.19 [In reply to]

About 9 times out of 10 it won't let me... First it just dispalys a box
that says "File not Available" with an "OK" checkbox, then it goes "dim"
and I can't get the menu up.

Backed out, went back in and tried it several more times and finally got
through. I think if you have preview turned on it tries to play the
file, finds the file doesn't exist and then flags it as deleted... But
never purges it. Could be a bug. I was only able to get a menu to delete
the recording when I hit on it REAL FAST before it usually has time to
open the preview.

Now, I probably could have turned off preview, but until I identify
another "dud file" I won't be able to confirm if this is the case.

Gavin

-----Original Message-----
From: mythtv-users-bounces [at] mythtv
[mailto:mythtv-users-bounces [at] mythtv] On Behalf Of Michael T. Dean
Sent: Thursday, March 02, 2006 1:53 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] Database Inconsistencies in 0.19

On 03/02/2006 02:16 PM, Gavin Haslett wrote:
> Basically, some TV shows that were recorded months ago (sometimes as
> long ago as a year) and deleted have suddenly reappeared in the
> recording list. When I select them they tell me the files don't exist.
>
> This isn't a huge deal... the problem only seems to have happened with

> about a half dozen shows... but it is odd. Any thoughts on why this
> would have happened? I presume that these are shows that were deleted,

> but for some reason never cleaned up (perhaps deleted with the 0.18
> version of Mythweb that would periodically drop my backend out when I
> used it to schedule shows?).
>
> Secondly... any ideas how to clean these up? I mean, other than
> editing the database directly ;)

You can just delete them (use the INFO or MENU key--I don't remember
which--then select Delete). You'll get a prompt saying that the file
doesn't exist and asking if you still want to delete the recording.
Answer yes and all is good.

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

ajlill at ajlc

Mar 5, 2006, 9:26 AM

Post #4 of 6 (591 views)
Permalink

Re: Database Inconsistencies in 0.19 [In reply to]

I was poking around in the database on my 0.18 system a while back and
I came across a couple of rows in the recorded table for recordings
that I know I watched and deleted. They've never popped back up for
me. Perhaps whatever bug hid them is fixed in 0.19.

If you use touch to create the file they're pointing at, you should be
able to delete them through the UI.

"Gavin Haslett" <gavin [at] nodecaf> writes:

> Okay, just noticed this for the first time last night. Basically, I
> upgraded to 0.19 with ATRPMS from 0.18.1. Everything works fine... but
> there's one annoying little "feature" I've found.
>
> Basically, some TV shows that were recorded months ago (sometimes as
> long ago as a year) and deleted have suddenly reappeared in the
> recording list. When I select them they tell me the files don't exist.
>
> This isn't a huge deal... the problem only seems to have happened with
> about a half dozen shows... but it is odd. Any thoughts on why this
> would have happened? I presume that these are shows that were deleted,
> but for some reason never cleaned up (perhaps deleted with the 0.18
> version of Mythweb that would periodically drop my backend out when I
> used it to schedule shows?).
>
> Secondly... any ideas how to clean these up? I mean, other than editing
> the database directly ;)
>
> Gavin
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users [at] mythtv
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

cardboil at gmail

Mar 5, 2006, 10:33 AM

Post #5 of 6 (601 views)
Permalink

Re: Database Inconsistencies in 0.19 [In reply to]

>
> > Basically, some TV shows that were recorded months ago (sometimes as
> > long ago as a year) and deleted have suddenly reappeared in the
> > recording list. When I select them they tell me the files don't exist.
> >
> <snip> > Secondly... any ideas how to clean these up? I mean, other than
> editing
>
> the database directly ;)
> >
> > Gavin
>
>
Have you tried hitting the "D" key using keyboard. If you don't have a
keyboard hooked to your mythbox, assign the D key to one of your remote
buttons and that will allow you to delete. Or, you can hit the "Return" key
(on keyboard or mapped to your remote) when on the recording list and it
will show you a popup menu from which you can select the Delete action.

mtdean at thirdcontact

Mar 5, 2006, 11:06 AM

Post #6 of 6 (608 views)
Permalink

Re: Database Inconsistencies in 0.19 [In reply to]

On 03/05/2006 01:33 PM, cardboil wrote:
>>> Basically, some TV shows that were recorded months ago (sometimes as
>>> long ago as a year) and deleted have suddenly reappeared in the
>>> recording list. When I select them they tell me the files don't exist.
>> <snip>
>>> Secondly... any ideas how to clean these up? I mean, other than
>>> editing the database directly ;)
> Have you tried hitting the "D" key using keyboard. If you don't have a
> keyboard hooked to your mythbox, assign the D key to one of your remote
> buttons and that will allow you to delete. Or, you can hit the "Return" key
> (on keyboard or mapped to your remote) when on the recording list and it
> will show you a popup menu from which you can select the Delete action.

And, with this approach, there's no need to "touch" the file first (or
even figure out the name of the missing file). :)

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads