[mythtv-users] Program Guide SegFautlts in Mythfrontend

[Ken Mandelberg]

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)