Opened 11 years ago

Closed 11 years ago

#6078 closed defect (invalid)

Escaping needed in EIT DB queries

Reported by: otto at kolsi dot fi Owned by: Stuart Auchterlonie
Priority: minor Milestone: unknown
Component: eit Version: head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

If EIT data contains ' -characters, DB queries fail because those characters brake the query if not escaped.

Following shows an example where year is present with text 79':

2009-01-06 09:02:16.591 MSqlQuery::exec() "REPLACE INTO program (
chanid, title, subtitle, description, category, category_type,
starttime, endtime, closecaptioned, stereo, hdtv, subtitled,
subtitletypes, audioprop, videoprop, partnumber, parttotal,
syndicatedepisodenumber, airdate, originalairdate, listingsource,
seriesid, programid, previouslyshown)
VALUES ('1007', 'Jäähyväiset aseille', '',
'(A Farewell to Arms/USA 1932, 79') Ernest Hemingwayn romaaniin
perustuva rakkauselokuva sotilaasta ja sairaanhoitajattaresta
ensimmäisessä maailmansodassa. O: Frank Borzage. N: Gary Cooper,
Helen Hayes, Adolphe Menjou.', 'Movie', 'movie',
'2009-01-06T14:04:49', '2009-01-06T15:25:01', 'false',
'false', 'false', 'false', '0', '0', '0', '0', '0', '',
'0000', '', '1', '', '', 'false')"

Change History (2)

comment:1 Changed 11 years ago by otto at kolsi dot fi

This should be closed as invalid. There's something going on with EIT and overlapping programs. But once the details are clear, that should go to it's own ticket.

comment:2 Changed 11 years ago by Janne Grunau

Resolution: invalid
Status: newclosed
Note: See TracTickets for help on using tickets.