[mythtv-users] How to rename a (mis)recorded program?

[Dan Morphis]

Chris Pinkham wrote:

> > So Sky decided to change things at the last minute and switched a
> > couple of programs round: 24 and Cold Case. It ended up that 24 was
> > played in Cold Case's slot so we only missed one :) But now it's
> > mis-labelled :(
> >
> > How do I fix that?
> >
> > Happy to dig into the DB tables but not sure which ones to edit.
> > Also not sure what side effects may ensue?
> >
> > David
>
>
>  update recorded set starttime = starttime, title = "new title",
>  subtitle = "new subtile", description = "new description" where
>  chanid = 1010 and starttime = 20040601203000;

David, the starttime = startime part of the SQL is very important, if 
you don't do that, you'll end up with a messed up recorded table.  I 
speak from experience on that one :-)

-dan