[mythtv-users] clearing out xmltv schedule for a couple of channels

Andre mythtv-list at dinkum.org.uk
Thu Oct 20 14:29:04 UTC 2011

On 20 Oct 2011, at 15:20, David Engel wrote:

> 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.

Ah, I thought that was too simple!

The only think there I use would be the seektable but that's easy to re-generate.

Thanks for the warning.


More information about the mythtv-users mailing list