[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.
Andre
More information about the mythtv-users
mailing list