[mythtv-users] Duplicate matching methods - make program ID an explicit choice
Michael T. Dean
mtdean at thirdcontact.com
Thu May 19 18:22:50 UTC 2016
On 05/19/2016 01:53 PM, Neil Bird wrote:
> On 19/05/16 17:13, Michael T. Dean wrote:
>> <snip> Now,
>> if you're switching to Schedules Direct (or some other provider that
>> provides a program ID encoded using the dd_progid system, this won't
>> help to fix duplicate matching for previous episodes--but if nothing
>> else, it should convince you that there's no harm removing the broken
>> program ID data from your database.
>
> Thanks for that, Michael - illuminating.
>
> Could you please confirm my suspicions that “all” we need to do is
> NULL (blank string?) the programid¹ from the oldrecorded and recorded
> tables?
Blank it (set it equal to '' (empty single or double quotes)), don't
NULL it (the column is a NOT NULL column), in recorded and oldrecorded.
You should probably also blank it from recordedprogram (which is just
the program information for your existing recordings).
>
> ¹ - I've not checked the actual field name.
That's the right name.
Mike
More information about the mythtv-users
mailing list