Opened 20 years ago
Closed 20 years ago
#525 closed defect (invalid)
MythWeb replaces the search string with program descriptions
Reported by: | Stuart Auchterlonie | Owned by: | xris |
---|---|---|---|
Priority: | minor | Milestone: | 0.19 |
Component: | mythweb | Version: | head |
Severity: | low | Keywords: | mythweb search |
Cc: | Ticket locked: | no |
Description
The scheduler causes SQL error whiles inserting into recordmatch due to bad quoting of event details.
2005-10-25 17:34:48.846 DB Error (UpdateMatches): Query was: INSERT INTO recordmatch (recordid, chanid, starttime, manualid) SELECT record.recordid, program.chanid, program.starttime, IF(search = 5, recordid, 0) FROM record, program INNER JOIN channel ON (channel.chanid = program.chanid) WHERE record.recordid = '208' AND program.manualid = 0 AND ( Recorded coverage of the Lords Science and Technology Committee hearing, including evidence from the Pandemic Planning Subgroup UVIG and the Health Protection Agency, from Tuesday 25th October. ) 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)) ) ) ) ) ) ) ) )) Driver error was [2/1064]: QMYSQL3: Unable to execute query Database error was: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'coverage of the Lords Science and Technology Committee hearing,
Change History (2)
comment:1 Changed 20 years ago by
Component: | mythtv → mythweb |
---|---|
Keywords: | mythweb search added; scheduler sql removed |
Owner: | changed from Isaac Richards to xris |
Summary: | scheduler SQL quoting → MythWeb replaces the search string with program descriptions |
comment:2 Changed 20 years ago by
Resolution: | → invalid |
---|---|
Status: | new → closed |
Mythweb doesn't support search-type schedules. Don't edit them with mythweb. It will eventually support search-type schedules and then you can edit them.
Note: See
TracTickets for help on using
tickets.
If a search rule is updated with mythweb, the search string stored in the record.description field is replaced by the description from the program being referenced. For instance: