[mythtv] Update from 0.18 to SVN 7432

Kevin Kuphal kuphal at dls.net
Sat Oct 15 22:31:25 UTC 2005


Daniel Kristjansson wrote:

>On Mon, 2005-10-10 at 23:30 +0100, Graeme Hilton wrote:
>  
>
>>Hi all,
>>However, I do have one issue with my upgrade from 0.18.  Although all
>>the old shows appear in the recordings list, none of them are playable.
>>The frontend gives more information than the backend:
>>write -> 11 21      QUERY_RECORDINGS Play
>>read  <- 11 64675   88[]:[]Gattaca[]:[][]:[]Before....
>>Invalid file handle when opening /media/tv/. 4 retries remaining.
>>Invalid file handle when opening /media/tv/. 3 retries remaining.
>>Invalid file handle when opening /media/tv/. 2 retries remaining.
>>Invalid file handle when opening /media/tv/. 1 retries remaining.
>>Invalid file handle when opening /media/tv/. 0 retries remaining.
>>    
>>
>
>You somehow missed DB update 1095, perhaps you applied some patch
>that changed the DB version? Anyway, you need to run these two
>commands in mysql (run 'mysql -u mythtv -pmythtv mythconverg'):
>
>ALTER TABLE recorded ADD COLUMN basename varchar(128) NOT NULL DEFAULT;
>
>UPDATE recorded SET basename =
>           CONCAT(chanid, '_', DATE_FORMAT(starttime,
>                  '%Y%m%d%H%i00'), '_',
>                  DATE_FORMAT(endtime, '%Y%m%d%H%i00'), '.nuv');
>
>  
>
I had the exact same problem today when upgrading to the latest SVN from 
an earlier revision and I know that I didn't apply any patches that 
would have changed the DB version.  I did the same as you suggested and 
it fixed the problem but there might be something more here...

Kevin


More information about the mythtv-dev mailing list