[mythtv-users] Deleting a recording deletes the wrong one!

Robert Tsai rtsai1111 at comcast.net
Sun Apr 16 04:59:20 UTC 2006


On Sun, Apr 16, 2006 at 12:24:59AM -0400, f-myth-users at media.mit.edu wrote:
> While attempting to figure out what happened, I looked in the
> oldrecorded table and was startled to discover that the last four
> episodes of the relevant program ALL had the same recordid field.
> Isn't this field supposed to be unique and increment for each
> recording, or am I confused?  (I hadn't deleted -any- of those
> episodes---I was deleting stuff on entirely different channels
> unrelated to the one being recorded---so I doubt that even if
> these are supposed to be unique, that this is the whole story.)
> That recordid (694) doesn't appear on anything but those four
> recordings (which span from 3/4 to tonight).
> 
> [Actually, having now looked at something else, I'm beginning
> to believe that recordid isn't unique after all---for example,
> oldrecorded's recordid for the last several Novas have values
> of 274 479 524 524 524 524 524 524 524.]

I believe the "recordid" field is the key for the "record" table - the
"scheduled recordings" rule that generated that recording.

--Rob
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20060416/a12e1924/attachment-0001.pgp 


More information about the mythtv-users mailing list