Opened 14 years ago

Closed 14 years ago

Last modified 14 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@…> 14 years ago.
Patch to fix single instance of query using bindValue

Download all attachments as: .zip

Change History (5)

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

Attachment: channelgroup.diff​ added

Patch to fix single instance of query using bindValue

comment:1 Changed 14 years ago by robertm

Owner: set to danielk
Status: new → assigned

comment:2 Changed 14 years ago by sphery

Owner: changed from danielk to sphery
Status: assigned → accepted

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

comment:3 Changed 14 years ago by sphery

Resolution: → fixed
Status: accepted → closed

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 14 years ago by stuartm

Milestone: unknown → 0.24
Note: See TracTickets for help on using tickets.