[mythtv-users] Myth is now recording when I exit Live TV

[Mike Perkins]

On 19/07/16 11:59, Gary Buhrmaster wrote:
> On Tue, Jul 19, 2016 at 9:49 AM, Mike Perkins
> <mikep at randomtraveller.org.uk> wrote:
>
>> Except this sounds like a bug.
>
> Well, I suspect there may be a bug (but different
> than you mention) in that some code presumes
> some specific id values are associated with
> some specific labels, and it (a) did not generate
> them as such(*), and/or (b) does not look up
> the ids based on the labels for the "well known"
> labels rather than hard-coding the ids.  Although
> the reality of those codes could mean yet a
> different option would be appropriate (I am not
> familiar with that code area).
>
>
>
> (*) Even for auto-increment tables you can set
> the column explicitly, and if you need something
> to be set as 1, 2, 3, you should do likely do it
> explicitly (or at least check your work).
>
Maybe I'm missing something here, but I don't think anybody has said that the DB was deliberately 
modifed to pursue some strategy which would require the user understanding the entire way the schema 
functions.

What I said was that the setting of the auto-increment to two could be a bug, probably during the 
database upgrade.

Any subsequent proposed modifications to the DB would be an attempt to "work round" the already 
existing problem rather than finding out what happened and correcting the error.

Of course, as always, the use of "magic numbers" is often frowned upon and should not be required 
here. If you want to select the "LiveTV" records, why not just supply that string?

-- 

Mike Perkins