[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