I've got an episode of NOVA from PBS that I had to reinsert into the database after an odd system problem back in November. I used the mythrebuilddatabase.pl script to get it back in and it worked.

Now, I'd like to use mpeg2 lossless transcoding to chop 5 minutes off the end of the show. The problem is that the seek table seems to be screwed up and I can't seem to rebuild it. I've been typing the commandAnd it responds with
But, when I go to look at the show, the On Screen Display says it's only 13:10 minutes long, and I know the file is 60 minutes long. Any idea why the seek file won't rebuild properly and how I can fix it?

Feb. 3 edit:
I looked at the video in that particular clip and there seem to have been some reception errors during recording. Somehow the original recording's seek file was good enough for playback, but a rescan after doing some cut-editing of the file could not produce a valid seek file.

It scares me to think that I know more about this process than anyone else on this forum - to the point that no one will even attempt a response.

Eric

_________________
KnoppMyth R5.5, Asus A8N-VM CSM (nvidia 6150 onboard video), AMD Athlon 64 dual-core 4200+, two 1GB sticks DDR 400, HD-3000 HDTV card, PVR-150 card, Iguanaworks RS-232 IR receiver/transmitter, Pioneer DVR-110 DVD burner

Thanks Eric,

I found http://mysettopbox.tv/phpBB2/viewtopic.php?t=6748&highlight=import+record and

I had some videos on R5D1 that I wanted on my new R5E0. I copied the file and used the insert into recorded table. I then saw the video in MY RECORDINGS, and I used the Myth GUI and selected the option to reflag the comercials. I was able to view the video, but I got NO SEEKTABLE when trying to edit.

I wanted to reedit the videos and flawlessly transcode out the commercials and you provided the needed code.

I was able to edit the reinserted video after that. Thanks to you.

Have you tried another mpg file? Maybe the Nova.mpg is damaged.

The answer to the 13 minute delema is:

mythcommflag looks at the recored database for information on the mpg you imported.

You must supply chanid, starttime, endtime, title, ETC... when you imported the MPG and that is the reported length you are seeing. If you update the TIMES in recorded database for that MPG to be 60 minutes and redid the mythcommflag --rebuild; you will see it as 60 minutes.

mythcommflag uses chanid and starttime as unique KEYS for the recordedmarkup database.

It can't be the recordedmarkup table that the system gets the 13 minutes from.

I copied some programs over from my previous hardware. I set one program manually to duplicate the data in recorded, oldrecorded, and recordedmarkup that was in the other database. I was getting the same kind of error, with the system thinking the show was over 3 hours long. (start time was 20:31)

I did a reschedule of the job for commercial autoskip, and still had the same problem. The recordedmarkup records for the program are identical, still over 3 hours.

I copied another program over, used the mythrebuilddatabase.pl, and it worked perfectly.

I just noticed though that the table record doesn't have the row for this recording however. I'll add a row to it and see if that works.

Edit: nope. Didn't work. I'll try to run the commflag program tomorrow. I don't really want to run it now since I have some shows recording at the moment.

I think this info is no longer current.
http://www.mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7

I'm reasonably sure it's not based on the recordedseek table either, because I discovered last night that my old systems recordedseek table didn't even exist. And yet, programs I recorded over the last month still work fine.

I'm guessing that the mythrebuilddatabase.pl process stores some data outside of mysql. I'll have to dig deeper into it. My old system, the mythrebuilddatabase.pl never worked under D1, but the new system with E50 it works great.

Edit: yep. Running commflag fixed the problem for me. It was actually setting it to nearly 4 hours rather than just over 3 as I'd misremembered.

So the length of the show is not stored in one of the time fields as far as I can tell.