Daniel Kristjansson wrote:
On Mon, 2005-10-10 at 23:30 +0100, Graeme Hilton wrote:
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
Not sure how I missed the DB update, but the column already existed, it
just didn't have any data in it.
Thanks, and keep up the good work on the DVB ;-)
--
Graeme
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev