LinHES Forums :: View topic - recording will not show up

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

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#

Author:	knopprob [ Sun Jun 15, 2008 2:52 am ]
Post subject:	recording will not show up
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

Author:	tjc [ Sun Jun 15, 2008 10:18 pm ]
Post subject:	Re: recording will not show up
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

Author:	knopprob [ Mon Jun 16, 2008 1:13 am ]
Post subject:
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'??

Author:	cliffsjunk [ Tue Jun 17, 2008 5:52 pm ]
Post subject:
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

LinHES Forums http://forums.linhes.org/

recording will not show up http://forums.linhes.org/viewtopic.php?f=11&t=18411	Page 1 of 1

Page 1 of 1	All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/