Opened 12 years ago

Closed 12 years ago

#5130 closed patch (fixed)

bind a value to placeholder

Reported by: l-case@… 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

Attachments (1)

5130-v1.patch (683 bytes) - added by danielk 12 years ago.
patch to address problem

Download all attachments as: .zip

Change History (3)

Changed 12 years ago by danielk

Attachment: 5130-v1.patch added

patch to address problem

comment:1 Changed 12 years ago by danielk

Type: defectpatch

comment:2 Changed 12 years ago by danielk

Resolution: fixed
Status: newclosed

(In [17827]) Fixes #5130. Only bind variables we use in Scheduler (using 5130-v1.patch from last week).

Note: See TracTickets for help on using tickets.