[mythtv-users] Mythtv is recording shows that have already been recorded?

[Michael T. Dean]

On 11/29/2007 08:32 PM, Anthony Messina wrote:
> As far as my issue with "Scrubs" is concerned, I do use SchedulesDirect and do 
> have the same seriesid and corresponding programid in recorded programs and 
> programs to be recorded, but i still get tons of dupes--again, only with this 
> show.  would deleting and recreating the recording rule make a difference?

This sounds like a broken DB.  I've seen similar issues where the
VARCHAR(20) programid becomes a VARCHAR(6) (or, now, a VARCHAR(40)
programid would become a VARCHAR(13)) because someone/something (such as
an upgrade) messes with the encoding of the DB.  Once this happens, the
truncated value makes everything look like a dup.

Since deleting and recreating the rule is easy, it wouldn't hurt to try
that.  But, if you can check out your oldrecorded/recorded/program
tables to verify the programid columns (and values), you might be able
to figure out exactly what's wrong.

Mike