[mythtv-users] EPG empty, MySQL errors

[Volker Bier]

Hello everybody,

since my last mythtv update (from 0.28 ubuntu repo), my EPG is empty and 
I have lots of the following errors in the log.
I have tried to issue the select statement directly in mysql, and get 
the same error. It goes away when I change the
statement to have the GROUP BY part in front of the ORDER BY.

Is this a problem with my MySQL version or has this been changed in the 
code? I am wondering that nobody else seems
to have the problem.

What do I have to do to make the EPG work again?

Thanks for you help,
   Volker

> Feb 14 12:16:30 Mini mythbackend: mythbackend[15594]: E HttpServer45
> mythdb.cpp:183 (DBError) DB Error (LoadFromProgramQuery):#012Query
> was:#012SELECT program.chanid, program.starttime, program.endtime,
> program.title, program.subtitle, program.description,
> program.category, channel.channum, channel.callsign, channel.name,
> program.previouslyshown, channel.commmethod, channel.outputfilters,
> program.seriesid, program.programid, program.airdate, program.stars,
> program.originalairdate, program.category_type, oldrecstatus.recordid,
> oldrecstatus.rectype, oldrecstatus.recstatus, oldrecstatus.findid,
> program.videoprop+0, program.audioprop+0, program.subtitletypes+0,
> program.syndicatedepisodenumber, program.partnumber,
> program.parttotal, program.season, program.episode,
> program.totalepisodes  FROM program LEFT JOIN channel ON
> program.chanid = channel.chanid LEFT JOIN oldrecorded AS oldrecstatus
> ON     oldrecstatus.future = 0 AND     program.title =
> oldrecstatus.title AND     channel.callsign = oldrecstatus.station
> AND     program.starttime = oldrecstatus.starttime WHERE
> program.chanid = 12170 AND program.endtime >= '2016-02-14T11:00:00Z'
> AND program.starttime < '2016-02-14T12:59:59Z' AND program.starttime
> >= '2016-02-13T11:00:00Z' AND program.manualid = 0 ORDER BY
> program.starttime  GROUP BY program.starttime,
> channel.channum,           channel.callsign, program.title  LIMIT
> 20000 #012Bindings were:#012:CHANID=12170,
> :ENDDATE=2016-02-14T12:59:59Z,
> :STARTDATE=2016-02-14T11:00:00Z,#012:STARTDATELIMIT=2016-02-13T11:00:00Z#012Driver
> error was [2/1064]:#012QMYSQL: Unable to execute query#012Database
> error was:#012You have an error in your SQL syntax; check the manual
> that corresponds to your MySQL server version for the right syntax to
> use near 'GROUP BY program.starttime, channel.channum,
> channel.callsign, program' at line 1