[mythtv-users] Again duplicates in recordings, I dont get it

[Michael T. Dean]

On 09/28/2009 02:33 PM, Richard Morton wrote:
> I just pasted into a text editor to find

Thank you /very/ much, Richard.  I hadn't gotten around to doing that, 
yet (and wasn't looking forward to doing so :).

>  programid is empty. seriesID
> is populated on the middle one but empty on the others (stereo flag is
> set on the two that are not populated with SeriesID - 1st and 3rd
> entry)
> Airdate; empty on 1st and 3rd, 2009 on 2nd
>
> Category type; movie on 1st and 3rd;empty on 2nd
> category: movie on 1st and 3rd; Sci-Fi on 2nd
> description populated on 1st and 3rd, empty on 2nd
> hope that helps

Where "progamid is empty" (on all 3) and "description populated on 1st 
and 3rd, empty on 2nd" means that there are actually 2 different shows 
listed according to the "default" duplicate matching method, "Subtitle 
and description" or "Subtitle then description".  Therefore, with that 
duplicate matching method selected for the rule, it would record 2 showings.

Oh, and to the OP, instead of using:

SELECT * FROM program WHERE title = 'Apollo 13';

to post to an e-mail list, using:

SELECT * FROM program WHERE title = 'Apollo 13'\G

will give much more readable results.

Mike