Mailing List Archive: cleanup database

cleanup database

Jul 21, 2003, 2:41 PM

Post #1 of 4 (1182 views)

Is there an easy way to cleanup the database without having to redo ones
configuration?

I have a few shows that show up in the recorded items list but aren't
actually located on the disk anymore and I can seem to delete the entries
from the view recording page. I was content to live with this until I
installed MythWeb today and noticed that on the scheduled recording tab in
mythweb, it has shows listed from december 2002 which I also can't delete by
hitting the delete button next to the item.

Should I just wipe the database and start from scratch or is there an easier
less destructive way?
--
Harondel J. Sibble
Sibble Computer Consulting
Creating solutions for the small business and home computer user.
help@pdscc.com (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice/fax) (604) 686-2253 (pager)

_______________________________________________
mythtv-users mailing list
mythtv-users@snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

Re: cleanup database [ In reply to ]

help at pdscc

Jul 21, 2003, 2:44 PM

Post #2 of 4 (1171 views)

Permalink

Forgot to mention, I am using 0.10 of both myth and mythweb and I've upgraded
along from 0.7, 0.8, 0.9, then 0.9.1 and now .10

--
Harondel J. Sibble
Sibble Computer Consulting
Creating solutions for the small business and home computer user.
help@pdscc.com (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice/fax) (604) 686-2253 (pager)

_______________________________________________
mythtv-users mailing list
mythtv-users@snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

Re: cleanup database [ In reply to ]

bob at smalltime

Jul 21, 2003, 6:24 PM

Post #3 of 4 (1149 views)

Permalink

> I have a few shows that show up in the recorded items list but aren't
> actually located on the disk anymore and I can seem to delete the entries
> from the view recording page.

Why don't you just touch the file so that it has something to delete?

_______________________________________________
mythtv-users mailing list
mythtv-users@snowman.net
http://lists.snowman.net/cgi-bin/mailman/listinfo/mythtv-users

Re: cleanup database [ In reply to ]

help at pdscc

Jul 26, 2003, 10:15 PM

Post #4 of 4 (1161 views)

Permalink

On 21 Jul 2003 at 20:24, Robert Kulagowski wrote:

> > I have a few shows that show up in the recorded items list but aren't
> > actually located on the disk anymore and I can seem to delete the entries
> > from the view recording page.
>
> Why don't you just touch the file so that it has something to delete?

Doesn't work.... that just locks up the front end, only way out is to do an
alt-f4 and then restart the frontend.

Actually what does work (in 0.10) is to move to the non-existant show in the
recorded shows list. Hit d and acknowledge that yes you do want to delete
it. It then says there are no recorded shows to watch, esc to main main menu,
select watch recorded shows and voila, the phantom show is gone and the list
of recorded shows is back.

--
Harondel J. Sibble
Sibble Computer Consulting
Creating solutions for the small business and home computer user.
help@pdscc.com (use pgp keyid 0x3AD5C11D) http://www.pdscc.com
(604) 739-3709 (voice/fax) (604) 686-2253 (pager)