Opened 16 years ago
Closed 16 years ago
#5130 closed patch (fixed)
bind a value to placeholder
| Reported by: | Owned by: | Isaac Richards | |
|---|---|---|---|
| Priority: | minor | Milestone: | unknown |
| Component: | mythtv | Version: | unknown |
| Severity: | medium | Keywords: | |
| Cc: | Ticket locked: | no |
Description
i have found 2 more occurences of placeholders:
Trying to bind a value to placeholder :NRST without occurance in the prepared query. Ignoring it.
Query was: "INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime, IF(search = 5, record.recordid, 0) FROM (record, program INNER JOIN channel ON channel.chanid = program.chanid) WHERE record.recordid = :NR0RECID AND program.manualid = 0 AND ( (program.title LIKE '%Cebit%'
OR program.subtitle LIKE '%Cebit%' OR program.description LIKE '%Cebit%') ) AND (NOT ((record.dupin & 32) AND program.previouslyshown)) AND (NOT ((record.dupin & 64) AND program.generic > 0)) AND (NOT ((record.dupin & 128) AND (program.previouslyshown OR program.first = 0))) AND channel.visible = 1 AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10) OR ((record.station = channel.callsign) AND ((record.type = 3) OR ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime)) AND ((record.type = 2) OR ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime) AND ((record.type = 5) OR ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime)) ) ) ) ) ) ) ) ))
Trying to bind a value to placeholder :NR0RECID without occurance in the prepared query. Ignoring it.
Query was: "INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime, IF(search = 5, record.recordid, 0) FROM (record, program INNER JOIN channel ON channel.chanid = program.chanid) WHERE record.search = :NRST AND program.manualid = 0 AND program.title = record.title AND (NOT ((record.dupin & 32) AND program.previouslyshown)) AND (NOT ((record.dupin & 64) AND program.generic > 0)) AND (NOT ((record.dupin & 128) AND (program.previouslyshown OR program.first = 0))) AND channel.visible = 1 AND ((record.type = 4 OR record.type = 6 OR record.type = 9 OR record.type = 10) OR ((record.station = channel.callsign) AND ((record.type = 3) OR ((TIME_TO_SEC(record.starttime) = TIME_TO_SEC(program.starttime)) AND ((record.type = 2) OR ((DAYOFWEEK(record.startdate) = DAYOFWEEK(program.starttime) AND ((record.type = 5) OR ((TO_DAYS(record.startdate) = TO_DAYS(program.starttime)) ) ) ) ) ) ) ) )) " 2008-04-03 10:20:21.448 Scheduled 19 items in 0.2 = 0.13 match + 0.11 place
patch to address problem