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

Reply via email to