[mythtv] [mythtv-commits] Ticket #1246: MythTV UTF-8 for 'Custom Record' query
Kevin Kuphal
kuphal at dls.net
Wed Feb 8 22:04:45 UTC 2006
MythTV wrote:
> #1246: MythTV UTF-8 for 'Custom Record' query
> ---------------------------------------+------------------------------------
> Reporter: Cougar <cougar at random.ee> | Owner: ijr
> Type: defect | Status: new
> Priority: minor | Milestone:
> Component: mythtv | Version:
> Severity: medium |
> ---------------------------------------+------------------------------------
> mythfrontend [8904] (almost latest). Found that when I have show where
> title has international characters in UTF-8 like '''Pealtnägija.''' then
> when I enter query '''title = 'Pealtnägija.' ''' I don't get any result.
> I think this is not a case for title but any MySQL query in mythtv.
>
> Here is result from mysql command line:
>
> {{{
> mysql> SELECT starttime,title FROM `program` where title = 'Pealtnägija.'
> and chanid = 1001;
> +---------------------+---------------+
> | starttime | title |
> +---------------------+---------------+
> | 2006-02-11 11:00:00 | Pealtnägija. |
> | 2006-02-08 20:05:00 | Pealtnägija. |
> +---------------------+---------------+
> }}}
>
> Here is what mythfrontend does (-v database):
>
> {{{
> sending IMStart with 0 chars to 0x8271d88
> sending IMEnd with 1 chars to 0x8271d88, text=ä
> receiving IMEnd with 1 chars
> 2006-02-08 23:07:32.470 MSqlQuery: SELECT NULL FROM program,channel WHERE
> title = 'Pealtn�ija.'
> 2006-02-08 23:07:32.789 MSqlQuery: SELECT DISTINCT program.chanid,
> program.starttime, program.endtime, program.title, program.subtitle,
> program.description, program.category, channel.channum,
> channel.callsign, channel.name, program.previouslyshown,
> channel.commfree, channel.outputfilters, program.seriesid,
> program.programid, program.airdate, program.stars,
> program.originalairdate, program.category_type, oldrecstatus.recordid,
> oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM
> program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN
> oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND
> channel.callsign = oldrecstatus.station AND program.starttime =
> oldrecstatus.starttime WHERE channel.visible = 1 AND program.endtime >
> '2006-02-08T23:07:50' AND ( title = 'Pealtnägija.' ) GROUP BY
> program.starttime, channel.channum, channel.callsign, program.title
> ORDER BY program.starttime, channum + 0 LIMIT 1000
> 2006-02-08 23:07:32.791 DB Error (ProgramList::FromProgram):
> Query was:
> SELECT DISTINCT program.chanid, program.starttime, program.endtime,
> program.title, program.subtitle, program.description,
> program.category, channel.channum, channel.callsign, channel.name,
> program.previouslyshown, channel.commfree, channel.outputfilters,
> program.seriesid, program.programid, program.airdate, program.stars,
> program.originalairdate, program.category_type, oldrecstatus.recordid,
> oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid FROM
> program LEFT JOIN channel ON program.chanid = channel.chanid LEFT JOIN
> oldrecorded AS oldrecstatus ON program.title = oldrecstatus.title AND
> channel.callsign = oldrecstatus.station AND program.starttime =
> oldrecstatus.starttime WHERE channel.visible = 1 AND program.endtime >
> '2006-02-08T23:07:50' AND ( title = 'Pealtnägija.' ) GROUP BY
> program.starttime, channel.channum, channel.callsign, program.title
> ORDER BY program.starttime, channum + 0 LIMIT 1000
> Driver error was [2/1052]:
> QMYSQL3: Unable to execute query
> Database error was:
> Column 'title' in where clause is ambiguous
> }}}
>
>
The error isn't UTF-8, but ambiguous title. Use program.title instead
of title and try again.
Kevin
More information about the mythtv-dev
mailing list