[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