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