[mythtv-users] EPG empty, MySQL errors
Volker Bier
volker.bier at web.de
Mon Feb 15 11:39:08 UTC 2016
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
More information about the mythtv-users
mailing list