Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#8841 closed defect (fixed)

Channel Groups don't display channels if name contains an apostrophe

Reported by: Paul Stuttard <stutty@…> Owned by: sphery
Priority: minor Milestone: 0.24
Component: MythTV - General Version: 0.23-fixes
Severity: low Keywords: channelgroup apostrophe mysql
Cc: Ticket locked: no

Description

In the Program Guide selecting a channelgroup that contains an apostrophe the frontend returns a SQL error due to the three apostrophes (single quotes "'") in the query string.

Fault is in file libs/libmythtv/channelgroups.cpp.

Change to using bindValue fixes.

Attachments (1)

channelgroup.diff (709 bytes) - added by Paul Stuttard <stutty@…> 9 years ago.
Patch to fix single instance of query using bindValue

Download all attachments as: .zip

Change History (5)

Changed 9 years ago by Paul Stuttard <stutty@…>

Attachment: channelgroup.diff added

Patch to fix single instance of query using bindValue

comment:1 Changed 9 years ago by robertm

Owner: set to danielk
Status: newassigned

comment:2 Changed 9 years ago by sphery

Owner: changed from danielk to sphery
Status: assignedaccepted

(Since danielk has plenty of other stuff he's working on.)

comment:3 Changed 9 years ago by sphery

Resolution: fixed
Status: acceptedclosed

Fixed in [26005] and backported to 0.23-fixes in [26006].

Seems Trac missed the Fixes in [26005] and I missed the Refs in [26006]. Thanks for the patch, Paul.

comment:4 Changed 9 years ago by stuartm

Milestone: unknown0.24
Note: See TracTickets for help on using tickets.