[mythtv-users] Program Guide SegFautlts in Mythfrontend
km at mathcs.emory.edu
Mon Nov 7 23:02:20 UTC 2022
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.
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()):
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)
More information about the mythtv-users