[mythtv] Update from 0.18 to SVN 7432

[Daniel Kristjansson]

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');

-- Daniel