[mythtv] Update from 0.18 to SVN 7432

Graeme Hilton graeme.hilton at fishter.org.uk
Sat Oct 15 10:48:24 UTC 2005


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


More information about the mythtv-dev mailing list