[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 Engel
david at istwok.net

More information about the mythtv-users mailing list