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

_________________
My Ziki

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.

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?

_________________
My Ziki

If it's MPEG-2 content, running the lossless transcoder can do wonders for rebuilding the seek tables...

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:

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

_________________
My Ziki

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.

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

_________________
My Ziki