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 bjm

Component: mythtvmythweb
Keywords: mythweb search added; scheduler sql removed
Owner: changed from Isaac Richards to xris
Summary: scheduler SQL quotingMythWeb replaces the search string with program descriptions

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:

   recordid: 208
     search: 3
      title: Technology (Keyword Search)
description: Technology

after making a change through mythweb would become:

   recordid: 208
     search: 3
      title: Technology (Keyword Search)
description: Recorded coverage of the Lords Science and Technology Committee...

comment:2 Changed 20 years ago by xris

Resolution: invalid
Status: newclosed

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.