View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 4 posts ] 
Print view Previous topic   Next topic  
Author Message
Search for:
PostPosted: Sun Jun 15, 2008 2:52 am 
Offline
Joined: Tue Dec 12, 2006 9:52 am
Posts: 139
km r5e50

i have the following problem:
the system has a recording that i recovered(??) a long time ago -so i don't know what and how i did...

using the menu i get the info:
see pictures:

when i want to play the recording;

when i use the -> key ;

when i want to see the program details after b2.jpg

so the recording appears to be UNavailable...

BUT:
when i look in /myth/tv
i see the file with the same name listed (*.mpg), and i can play it using:
vlc <filename>.mpg

the *.mpg.png file is not present though...

how can i get the recording back in the menu list so i can edit it...??

thanks


Top
 Profile  
 
PostPosted: Sun Jun 15, 2008 10:18 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
knopprob wrote:
how can i get the recording back in the menu list so i can edit it...??

See the DB repair pages on the wiki. They include directions on how to do this. It's the 2nd half of this page http://www.knoppmythwiki.org/index.php?page=RepairingMythConvergDB


Top
 Profile  
 
 Post subject:
PostPosted: Mon Jun 16, 2008 1:13 am 
Offline
Joined: Tue Dec 12, 2006 9:52 am
Posts: 139
thank you for the suggested wiki-page.

but oops:
Quote:
root@mythtv:/myth/tv# mythcommflag --rebuild 30394_20070928181700.mpg
2008-06-16 08:53:19.472 Illegal option: '30394_20070928181700.mpg' (use --help)


so wiki may not be 'spot-on'

did again with:
Quote:
root@mythtv:/myth/tv# mythcommflag --rebuild --file 30394_20070928181700.mpg
2008-06-16 08:56:15.846 Using runtime prefix = /usr
2008-06-16 08:56:15.954 New DB connection, total: 1
mythcommflag: ERROR: Unable to find DB info for 30394_20070928181700.mpg


did (which should have done first(?):
Quote:
root@mythtv:/myth/tv# myth.rebuilddatabase.pl --try_default

These are the files stored in (/myth/tv) 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.

.................

Unknown file /myth/tv/30394_20070928181700.mpg found.
Do you want to import? [y]: y
Found an orphaned file, initializing database record
Channel: 0394
Start time: 09/28/2007 - 18:17:00
End time: // - ::
Enter channel [0394]:
... title [30394 20070928181700]: EssenTrinken_Pasta
... subtitle:
Description [Recovered file 30394_20070928181700.mpg]: pasta
... start time (YYYY-MM-DD HH:MM:SS) [20070928181700]:
... duration (in minutes) [60]: 30
DBD::mysql::st execute failed: Duplicate entry '394-2007-09-28 18:17:00' for key 1 at /usr/local/bin/myth.rebuilddatabase.pl line 394, <DATA> line 1.
Could not execute (insert into recorded (chanid, starttime, endtime, title, subtitle, description, hostname, basename, progstart, progend) values ((?), (?), (?), (?), (?), (?), (?), (?), (?), (?)))
root@mythtv:/myth/tv#


seems i am doing something wrong, but what??

edit: could it be this:
i took the first 5 digits of the file name for being the channel-number (here 30394)

but: when i use mythweb (from another machine) and look at the page 'recorded programs', i see the station from where i recorded the above file listed in the channel number column as: '29394'

should i give that last number as myth.rebuilddatabase.pl asks me 'enter channel'??


Top
 Profile  
 
 Post subject:
PostPosted: Tue Jun 17, 2008 5:52 pm 
Offline
Joined: Fri Sep 15, 2006 12:16 pm
Posts: 292
From your error messages, it looks like you will need to delete
this recording before you can add it back using myth.rebuilddatabase.pl

I suggest that you copy this recording into your /myth/video
directory with something like:
Code:
cp /myth/tv/30394_20070928181700.mpg /myth/video
You should do this logged in as user mythtv.

Then delete the recording using the frontend. Then copy it
back to /myth/tv Then re-run your myth.rebuilddatabase.pl

It should insert into the database properly and allow you
to play it. If not, you may have database corruption and need
some database fixing which you can find help for on the wiki.

One last thing, if you did copies as I suggested (not moves)
then you still have a copy of this in your videos directory.
Rescan your videos as you normally do after you put in a
new video and watch it that way with mythfrontend if all else
fails.

Cliff


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 


All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 13 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu