[mythtv-users] Still no recorded programs displayed in 'WatchRecording' dialog

[Robin Gilks]

>>
>> Greetings
>>
>> After changing tuners I've lost my existing recordings - well sort of.
>> They are in the database according to webmin and myth.rebuilddatabase.pl
>> (see below) can see them as well. In the 'Watch Recording' screen, all I
>> get is "Sorry, no recording available". mysql is running OK (settings,
>> epg, mp3 lists etc all accessed OK).
>>
>> I've tried starting with a new database (typing in all those channels
>> again!!) and importing the files but they all report zero length and
>> when
>> I try to then delete them after 5 seconds they re-appear in the delete
>> recording list again!! Weird or what...
>>
>> $ ./myth.rebuilddatabase.pl --show_existing
>>
>> Your myth database (mythconverg) is reporting the following programs as
>> being recorded:
>>
>> Channel:    1005
>> Start time: 06/04/2005 - 19:32:00
>> End time:   06/04/2005 - 20:03:00
>> Title:      Paul Mccartney In Red Square
>> Subtitle:
>> [blah blah]
>>
>> These are the files stored in (/mnt/store) and will be checked against
>> your database to see if the exist.  If they do not, you will be prompted
>> for a title and subtitle of the entry, and a record will be created.
>>
>> Found a match between file and database
>>     File: '/mnt/store/1005_20050604200400_20050604201800.nuv'
>>     Title: 'Paul Mccartney In Red Square'
>> [blah blah]
>>
>>
>> So I tried a new recording. Another gig of disk space later and still
>> nothing to watch.
>>
>> If I can't get the old stuff back, can someone suggest what stuff I
>> delete
>> from the mythconverg database so I can free up 30G of disk space.
>>
>> After 3 months of building this box, everything else is working, from
>> LCD
>> to FM radio (i.e. the difficult bits) but recordings have me beat :-(
>>
>
> Make sure you are looking at the All Recordings group in watch recordings.
> In the watch recordings area hit "Menu" on your remote or "M" on your
> keyboard then select Change Group Filter.
>
> If that does not work I want you to go into mysql and run the following
>
> select * from recorded;
>
> |   1004 | 2005-09-30 21:00:00 | 2005-09-30 22:00:00 | Threshold
> | The Burning                   | A routine search for an escaped
> psychiatric patient becomes a mystery when Molly and the Red Team learn
> the
> patient is having the same dreams as Caffrey, Cavennaugh and Pegg.
> | Drama           | yggdrasil | NULL     |       0 | NULL
> |          1 |           0 | Default  |      118 | SH753788 | EP7537880003
> |
> 20050930220000 | 2330650560 |     0 |               0 | 2005-09-30      |
> 0 |      0 |             0 |          0 |           1 |           0 |
> 1004_20050930210000.mpg                | 2005-09-30 21:00:00 | 2005-09-30
> 22:00:00 |
>
> See where it says Default above. That is your recording group.
> If it is blank you might need to update it to have a group there.
>
>

Thanks for the info. The Watch Recording group menu gives me the following
choices

All Programs
Default [11 items]
[11 items]

A bit odd that 11 items turn up in 2 places and one doesn't have a name...

The database looks like everything is there - here is one record...

|   1005 | 2005-06-04 19:32:00 | 2005-06-04 20:03:00 | Paul Mccartney In
Red Square   |                         | Paul McCartney's live 2003
concert in Red Square.                                                    
                                                                          
                                              |          | zeus     | NULL
    |       0 | 0 - 4727
29660 - 35597
43973 - 47010
 |          1 |           2 | Default  |        3 | 229575061 |          
| 20050921231625 | 3283229270 |     0 |               0 | 2005-06-04     
|        0 |      0 |          0 |           1 |           0 |
1005_20050604193200_20050604200300.nuv | 2005-06-04 19:32:00 | 2005-06-04
20:03:00 |

Does that look reasonable?

It did occur to me that I might have a rogue version from SVN - I'm
running 7283 as I've not updated for a while. The database was created
under 0.18.1 if that has any relevance...

Looks like its update to latest SVN and re-create the database from
scratch :-((

-- 
Robin Gilks