[mythtv-users] Program Guide SegFautlts in Mythfrontend

[Peter Bennett]

On 11/7/22 18:02, Ken Mandelberg wrote:
> Just recently I noticed that selecting the proram guide from 
> mythfrontend causes it to segfault. I have used it in the past without 
> problem, but since I rarely use it I don't know when the problem 
> started. Mythweb doesn't have a problem with "listings" which displays 
> the same guide, and everything else seems to be working fine.
>
> I'm running
>
> MythTV Version : v33-Pre-899-g06da3119d5-dirty
> MythTV Branch : master
> Network Protocol : 91
> Library API : 33.20220201-1
> QT Version : 5.15.3
>
> on Ubuntu 22.04 with mysql.
>
> Below is the error output, apparently the query fails but I'm not sure 
> why. Any help?
>
>
> 2022-11-07 17:40:48.988893 E  Driver error was [2/1064]:
> QMYSQL3: Unable to prepare statement
> Database error was:
> You have an error in your SQL syntax; check the manual that 
> corresponds to your MySQL server version for the right syntax to use 
> near 'groups     ON channel.chanid = groups.chanid JOIN 
> capturecard     ON capturecard' at line 1
>
> 2022-11-07 17:40:48.988915 E  DB Error (ChannelInfo::Load()):
> Query was:
> SELECT  channum, freqid, channel.sourceid, callsign, name, icon, 
> finetune, videofilters, xmltvid, channel.recpriority, 
> channel.contrast, channel.brightness, channel.colour, channel.hue, 
> tvformat, visible, outputfilters, useonairguide, mplexid, serviceid, 
> atsc_major_chan, atsc_minor_chan, last_record, default_authority, 
> commmethod, tmoffset, iptvid, channel.chanid, GROUP_CONCAT(DISTINCT 
> groups.groupids), GROUP_CONCAT(DISTINCT 
> capturecard.cardid              ORDER BY livetvorder), 
> MIN(livetvorder) livetvorder FROM channel LEFT JOIN (     SELECT 
> chanid ,           GROUP_CONCAT(grpid ORDER BY grpid) groupids FROM 
> channelgroup     GROUP BY chanid ) groups     ON channel.chanid = 
> groups.chanid JOIN capturecard     ON capturecard.sourceid = 
> channel.sourceid        AND capturecard.parentid = 0 WHERE 
> channel.deleted IS NULL AND channel.visible > 0 GROUP BY 
> channel.chanid ORDER BY LPAD(CAST(channel.channum AS UNSIGNED), 10, 
> 0), LPAD(channel.channum,  10, 0)
> No error type from QSqlError?  Strange...
> 2022-11-07 17:40:48.988925 E  GuideGrid:
>             You don't have any channels defined in the database.
>             Guide grid will have nothing to show you.
> 2022-11-07 17:40:48.988993 C  Received Segmentation fault: Code 1, PID 
> 0, UID 0, Value 0x00000000
> Segmentation fault (core dumped)
>
>
It seems that this was fixed on October 2nd in master, that is in 
v33-Pre-913-g9cacc903e6, fixing bug #647

channelutil: interim fix for MariaDB reserved GROUPS keyword

Upgrade to a version v33-Pre-913 or later.