LinHES Forums :: View topic - Program is too short (seektable)

A few programs that I've recorded (off DTV) have had corrupted seektables.

I followed these instructions and now have seektables, BUT the table thinks that the program goes for ~2mins, when it really goes for 30!

Other than re-running mythcommflag, what can I do so that I can get a valid seektable for editing/skipping etc.

Daniel

So what kind of things should i look for or change?

Is there a field "length" or "time" that will be set to "2mins" and I can change to "35mins" (or maybe 2100secs)?

Is there no script or menu option available to make the database entries valid?

- Use myth.rebuilddatabase.pl to get the recordings back in the DB. This is kind of tedious but be careful to get the info as close to correct as you can. I blew a couple and it toook a certain amount of manual poking at the DB to get them back where they belonged

Author:	funkydan2 [ Thu Apr 05, 2007 2:02 am ]
Post subject:	Program is too short (seektable)
A few programs that I've recorded (off DTV) have had corrupted seektables. I followed these instructions and now have seektables, BUT the table thinks that the program goes for ~2mins, when it really goes for 30! Other than re-running mythcommflag, what can I do so that I can get a valid seektable for editing/skipping etc. Daniel

Author:	borgednow [ Thu Apr 05, 2007 1:16 pm ]
Post subject:	Re: Program is too short (seektable)
funkydan2 wrote: A few programs that I've recorded (off DTV) have had corrupted seektables. I followed these instructions and now have seektables, BUT the table thinks that the program goes for ~2mins, when it really goes for 30! Other than re-running mythcommflag, what can I do so that I can get a valid seektable for editing/skipping etc. Daniel Check the various mysql tables for the recording and look at the time fields. Record, Program, recordings, oldrecordings, etc. You can use Show Tables; to see what tables there are. If you change anything, you'll want to either restart the backend/frontend or rerun commflag, otherwise the be/fe system won't go look I think. I'd just check the fields and then rerun commflag from a terminal window rather than from the menu system.

Author:	funkydan2 [ Thu Apr 05, 2007 3:41 pm ]
Post subject:
So what kind of things should i look for or change? Is there a field "length" or "time" that will be set to "2mins" and I can change to "35mins" (or maybe 2100secs)? Is there no script or menu option available to make the database entries valid?

Author:	tjc [ Thu Apr 05, 2007 5:47 pm ]
Post subject:
If it's MPEG-2 content, running the lossless transcoder can do wonders for rebuilding the seek tables...

Author:	borgednow [ Thu Apr 05, 2007 11:19 pm ]
Post subject:
funkydan2 wrote: So what kind of things should i look for or change? Is there a field "length" or "time" that will be set to "2mins" and I can change to "35mins" (or maybe 2100secs)? Is there no script or menu option available to make the database entries valid? Look for the start time and end time fields. I haven't found any length fields yet. When I've had weird problems like this, fixing the end time fields in various tables and then running commflag from a terminal window is the only thing that worked for me. And no, tjc, running the transcoder or commflag from the menus never worked for me at all. Commflag, from the terminal window, with it's arms wide. Wait, that last part was from ST:TNG and is only optional. Here's a sample command to use for commflag: mythcommflag --rebuild -f /myth/tv/1015_20070229110000.mpg If you want a script to fix the database entries, you could do this: manually copy the mpg file of the program out of the tv directory; delete the recording using the menu; move the file back to the tv directory; run the script that finds any programs sitting there without any database info and adds it back. The only drawback to this script is that it prompts you for all the info, such as the length of the show, the description, etc. I can't remember the name of the script offhand. Let me see if I can dig it up. Edit: found the post by tjc on the subject. The script is myth.rebuilddatabase.pl. It works great but to quote tjc: Quote: - Use myth.rebuilddatabase.pl to get the recordings back in the DB. This is kind of tedious but be careful to get the info as close to correct as you can. I blew a couple and it toook a certain amount of manual poking at the DB to get them back where they belonged

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

Program is too short (seektable) http://forums.linhes.org/viewtopic.php?f=17&t=14821	Page 1 of 1

Author:	funkydan2 [ Fri Apr 06, 2007 8:54 pm ]
Post subject:
Looks like i'm not going to have much luck with this. @tjc - I've tried transcoding (http://www.mythtv.org/wiki/index.php/Mythtranscode) but I'm not exactly sure how to do a lossless transcode. In my transcoding profiles, the profiles are either using the RTJpeg or the MPEG4 codec, not the MPEG2 one. However, I tried transcoding using both the "Autodetect" and the "default" transcoders, and both of them failed with error 247 which I think has something to do with broken codecs. How do I run a lossless transcoding job? (I assume from the wiki page that running mythtranscode from the command line doesn't do anything to the database.) Daniel

Author:	tjc [ Fri Apr 06, 2007 10:10 pm ]
Post subject:
This old thread contains the steps needed to set it up: http://mysettopbox.tv/phpBB2/viewtopic.php?t=9124&highlight=lossless+transcoding No need to upgrade if you're on R5E50, since it already contains support for this.

Author:	funkydan2 [ Sat Apr 07, 2007 3:44 pm ]
Post subject:
Thanks guys, (I am running R5E50, sorry for not mentioning it earlier ) Anyway, after a number of permutations of "Lossless Transcode" and "Commercial Detection" the shows now come out at 35ish minutes and commercials have been flagged correctly. Thanks for your help! Daniel

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