<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p><br>
</p>
<div class="moz-cite-prefix">On 12/16/18 10:00 PM, Mike Holden
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAKfgc2+LGJC_Df9tja9a8nkPSZGo9wwgQ==oz9-6BvCeP8waFQ@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div dir="ltr">On Mon, 17 Dec 2018 at 14:37, Scot Kreienkamp
<<a href="mailto:skreien@wcnet.org" moz-do-not-send="true">skreien@wcnet.org</a>>
wrote:<br>
</div>
<div class="gmail_quote">
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div dir="ltr">
<div dir="ltr">
<div dir="ltr">
<div>Hi,</div>
<div><br>
</div>
<div>I'm trying to understand why my duplicate
detection isn't working like I think it should. I
record much of my stuff by power search including
the example in this email, "Modern Family". I have
"Duplicate Check method" set to subtitle and
description, and "Check for duplicates in" set to
"All recordings". As I understand it, that should
mean that I don't ever record any Modern Family
shows a second time. Using those settings I have
three instances of the same show in oldrecorded, and
it's due to record another instance soon. It seems
like the oldrecorded table isn't being consulted at
all when considering which shows to record. It does
seem to be working for shows that are still in the
recorded table. </div>
<div><br>
</div>
<div>MariaDB [mythconverg]> select
title,subtitle,episode,seriesid,programid,duplicate
from oldrecorded where subtitle like '%parade' order
by title,subtitle;</div>
<div>+---------------+-----------------+---------+------------+----------------+-----------+</div>
<div>| title | subtitle | episode |
seriesid | programid | duplicate |</div>
<div>+---------------+-----------------+---------+------------+----------------+-----------+</div>
<div>| Modern Family | I Love a Parade | 0 |
EP01158124 | EP011581240251 | 0 |</div>
<div>| Modern Family | I Love a Parade | 0 |
EP01158124 | EP011581240251 | 0 |</div>
<div>| Modern Family | I Love a Parade | 0 |
EP01158124 | EP011581240251 | 0 |</div>
<div>+---------------+-----------------+---------+------------+----------------+-----------+</div>
<div>3 rows in set (0.01 sec)</div>
<div><br>
</div>
<div><br>
</div>
<div>Why isn't it matching against the oldrecorded
table? Any way to get it to?</div>
</div>
</div>
</div>
</blockquote>
<div><br>
</div>
Try changing it to "subtitle THEN description"
<div><br>
</div>
<div>If the subtitle is the same, but the description changes,
your current rule will record it again. <br>
</div>
</div>
</div>
</blockquote>
<p>I was just thinking the same then. Maybe just have it check the
subtitle only.</p>
</body>
</html>