[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