>>
>> 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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
