[mythtv] Record new shows broken

Tony Lill ajlill at ajlc.waterloo.on.ca
Wed Sep 22 19:36:48 EDT 2004


This bit of sql from scheduler.cpp will always return true if there
are ANY entries in the oldrecorded table without a programid. This makes
all shows come up as repeats.

"oldrecorded.endtime IS NOT NULL AS oldrecduplicate,"
...
" LEFT JOIN oldrecorded ON "
"  ( "
"    record.dupmethod > 1 AND "
"    program.title = oldrecorded.title "
"     AND "
"     ( "
"      (program.programid <> '' AND program.programid NOT LIKE 'SH%0000' "
"       AND program.programid = oldrecorded.programid) "

This is false because it is a new show

"      OR "
"      ( "
"       (program.programid = '' OR oldrecorded.programid = '') "

This is true because there does exist entries in oldrecorded without programid

"       AND "
"       (((record.dupmethod & 0x02) = 0) OR (program.subtitle <> '' "
"          AND program.subtitle = oldrecorded.subtitle)) "
"       AND "
"       (((record.dupmethod & 0x04) = 0) OR (program.description <> '' "
"          AND program.description = oldrecorded.description)) "

Both these are true because dupmethod = 8

"      ) "
"     ) "
"  ) "


More information about the mythtv-dev mailing list