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');
-- Daniel
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
