[mythtv-users] Changed chanid via SQL, now can't seek in older recordings

[Michael T. Dean]

On 01/09/2008 07:51 AM, David Whyte wrote:
> On Jan 8, 2008 3:48 AM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
>   
>>> If I work out when to use on over the other (with your help of
>>> course), I will update the wiki with the information.
>>>       
>> Thanks.
> Thanks for the help with this problem.  My box is all nice and tidy
> again now.  In return I thought it right to document our findings on
> the Wiki.  If possible, could you peruse
> http://www.mythtv.org/wiki/index.php/Repairing_the_Seektable and
> ensure it is not misleading in anyway.

You'll want to use --buildindex on the mythtranscode command, otherwise, 
you're actually transcoding it (not a problem--especially if doing an 
MPEG-2 to MPEG-2 "lossless" transcode, but it's just unnecessary work).  
Just adding that one argument to the command line you show should work.

Also, a corrupt seektable could be caused by crashed table(s) in MySQL 
(in which case all recordings since the table crashed will have 
corrupt/non-existent seektables).  And, I've gotten non-existent 
seektables when losing my network during recording (i.e. the slave 
backend was unable to contact the MySQL server on the master backend to 
write the seektable).

Thanks for updating the wiki.  It looks good.

Mike