[mythtv-users] 'Never Record' fails to work with some Custom (Power Search) Recording Schedules

Wed Apr 4 18:57:27 UTC 2007

One for bjm perhaps?

I've seen similar behaviour over several months, and normally resort
to just overriding a recording, rather than looking into this issue
further. I'm sure it comes down to dupe matching, but I just want some
clarification before I delve into the code and try to make some sense
of it :)

Trying to falsify a future recording using the 'Never Record' option
creates an entry in mythconverg.oldrecorded, but the scheduler still
schedules the recording to take place.

I have a custom recording rule, setup via MythWeb (Louis Theroux docs) using:

Record at any time on any channel
Power Search
Subtitle and Description duplicate checking

and SQL details of:

mysql> SELECT * FROM record WHERE title LIKE '%louis theroux%';
+----------+------+--------+-----------+------------+----------+------------+--------------------------------------------+----------+--------------------------------------+------------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+----------+-----------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+--------------+
| recordid | type | chanid | starttime | startdate  | endtime  |
enddate    | title                                      | subtitle |
description                          | category         | profile |
recpriority | autoexpire | maxepisodes | maxnewest | startoffset |
endoffset | recgroup | dupmethod | dupin | station | seriesid |
programid | search | autotranscode | autocommflag | autouserjob1 |
autouserjob2 | autouserjob3 | autouserjob4 | findday | findtime |
findid | inactive | parentid | transcoder | tsdefault | playgroup |
prefinput | next_record         | last_record         | last_delete
     | storagegroup |
+----------+------+--------+-----------+------------+----------+------------+--------------------------------------------+----------+--------------------------------------+------------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+----------+-----------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+--------------+
|     1566 |    4 |     75 | 13:01:57  | 2007-03-31 | 13:01:58 |
2007-03-31 | Louis Theroux Documentaries (Power Search) |          |
program.title LIKE '%Louis Theroux%' | Custom recording | Default |
       0 |          0 |           0 |         0 |           0 |
 0 | Default  |         6 |    15 | BBC1    |          |           |
   1 |             0 |            0 |            0 |            0 |
        0 |            0 |       1 | 13:03:57 | 733131 |        0 |
    0 |          0 |         1 | Default   |         0 | 2007-04-04
23:20:00 | 2007-04-01 20:58:32 | 0000-00-00 00:00:00 | Default      |
+----------+------+--------+-----------+------------+----------+------------+--------------------------------------------+----------+--------------------------------------+------------------+---------+-------------+------------+-------------+-----------+-------------+-----------+----------+-----------+-------+---------+----------+-----------+--------+---------------+--------------+--------------+--------------+--------------+--------------+---------+----------+--------+----------+----------+------------+-----------+-----------+-----------+---------------------+---------------------+---------------------+--------------+

Here, last_record points to the successful recording and next_record
points to the recording that I cannot override with 'never record'.

This seems to work as intended, picking up matches across channels.
However, the most recent showing (which recorded a couple of days ago
successfully) is repeated tonight. As such, I have used the 'Never
Record' option in both mythfrontend and mythweb to try and falsify the
recording to stop it re-recording tonight:

mysql> SELECT * FROM oldrecorded WHERE title LIKE '%louis theroux%';
+--------+---------------------+---------------------+-------------------------------------------------+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+-----------+--------+----------+---------+---------+-----------+-----------+------------+---------+
| chanid | starttime           | endtime             | title
                                | subtitle      | description

                                            | category    | seriesid
| programid | findid | recordid | station | rectype | duplicate |
recstatus | reactivate | generic |
+--------+---------------------+---------------------+-------------------------------------------------+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+-----------+--------+----------+---------+---------+-----------+-----------+------------+---------+
|     76 | 2007-04-01 21:00:00 | 2007-04-01 22:00:00 | Louis Theroux:
The Most Hated Family in America |               |The 70 or so members
of the Westboro Baptist Church in Topeka, Kansas, are a gift to Louis
Theroux. They are the kind of crackpot religious zealots - their
mottoes include "God Hates America" and "God Hates Fags" - that are
perfect subjects for his affable, fauxpuzzled documentary-maker
persona. Much of this is hilariously funny, and that's probably the
best way to confront the despised Phelps family, the bedrocks of the
Westboro baptists: laugh at them. Their patriarch...               |
Documentary | 171902257 |           |      0 |     1566 | BBC2    |
   4 |         1 |        -3 |          0 |       0 |
|     76 | 2007-04-02 17:50:24 | 2007-04-02 17:50:24 | Louis Theroux:
The Most Hated Family in America |               |Louis Theroux
struggles to come to terms with the infamous Phelps family from
Topeka, Kansas who picket the funerals of soldiers killed in Iraq as a
protest against an America that tolerates homosexuality. The family
members wave slogans with messages such as 'God Hates Fags', 'Thank
God for 9/11' and 'God Hates You' at pickets all over the States. The
last documentary filmmaker to enter their world was so enamoured by
the Phelps that he joined them. What does the future hold for Louis? |
Documentary | 171902257 |           |      0 |     1566 |         |
   4 |         1 |        11 |          0 |       0 |
|     76 | 2007-04-02 20:38:07 | 2007-04-04 23:20:00 | Louis Theroux:
The Most Hated Family in America |               |Louis Theroux
struggles to come to terms with the infamous Phelps family from
Topeka, Kansas who picket the funerals of soldiers killed in Iraq as a
protest against an America that tolerates homosexuality. The family
members wave slogans with messages such as 'God Hates Fags', 'Thank
God for 9/11' and 'God Hates You' at pickets all over the States. The
last documentary filmmaker to enter their world was so enamoured by
the Phelps that he joined them. What does the future hold for Louis? |
Documentary | 171902257 |           |      0 |     1566 | BBC2    |
   4 |         1 |        11 |          0 |       0 |
+--------+---------------------+---------------------+-------------------------------------------------+---------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------+-----------+-----------+--------+----------+---------+---------+-----------+-----------+------------+---------+

(Apologies for the line breaks - they do line up correctly in fixed-width)

The old recorded table contains three matches for this rule:

i) the first entry is the real recording that took place
ii) the second entry is the 'never record' entry from mythweb - note
that start/end times are set to the time the override was created
iii) the third entry is the 'never record' entry from mythfrontend -
note here that the start time is the time the override was created,
yet the end time is the real *start* time of the future recording I am
overriding.

Any ideas?

I have seen the Subtitle then Description ticket, but this rule uses
Subtitle and Description, and these fields are both the same (even
though subititle for this particular episode is missing, but is not
always). I don't want to rely on a subtitle then description matcher
in case a subtitle is generic (but not missing).

Cheers,
Nick
-- 
MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin