[mythtv-users] How to rename a (mis)recorded program?
dan at milkcarton.com
Fri Jun 25 15:51:42 EDT 2004
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 :-)
More information about the mythtv-users