[mythtv-users] clearing out xmltv schedule for a couple of channels
David Engel
david at istwok.net
Thu Oct 20 14:20:27 UTC 2011
On Thu, Oct 20, 2011 at 10:09:25AM +0100, Andre wrote:
> For the record and risking developer ire... this is the SQL I used to fix my changed sources:
>
> UPDATE recorded SET chanid = chanid - 11000 WHERE chanid > 12000;
>
> My old source was 12, the new one is 1, so the old chanid was offset by 12000 the new one by 1000, the other source was 2 before and is 2 now so no change required.
>
> It all looks fine and recordings play but If anyone thinks I've broken something crucial please tell me.
You disconnected your recordings from useful (but non-critical) data
such as the seektable, commercial flags, credits and ratings in other
tables which still use the old chanid.
David
--
David Engel
david at istwok.net
More information about the mythtv-users
mailing list