Opened 4 years ago

Closed 6 months ago

#13019 closed Patch - Bug Fix (Unverified)

Patch progdetails.cpp to treat relevance column as the character it is

Reported by: Gary Buhrmaster <gary.buhrmaster@…> Owned by:
Priority: minor Milestone: unknown
Component: MythTV - General Version: Master Head
Severity: medium Keywords:
Cc: Ticket locked: no


The table programgenres contains the column relevance which is a single character. progdetails.cpp treats it as a number, which does not work well with high relevance values.

Completely untested (not even compile tested) proposed patch follows:

diff --git a/mythtv/programs/mythfrontend/progdetails.cpp b/mythtv/programs/mythfrontend/progdetails.cpp
index 1132e41..388efb8 100644
--- a/mythtv/programs/mythfrontend/progdetails.cpp
+++ b/mythtv/programs/mythfrontend/progdetails.cpp
@@ -428,7 +428,7 @@ void ProgDetails::loadPage(void)
     query.prepare("SELECT genre FROM programgenres "
                   "WHERE chanid = :CHANID AND starttime = :STARTTIME "
-                  "AND relevance > 0 ORDER BY relevance;");
+                  "AND relevance <> '0' ORDER BY relevance;");
     query.bindValue(":CHANID",    m_progInfo.GetChanID());
     query.bindValue(":STARTTIME", m_progInfo.GetScheduledStartTime());

Change History (1)

comment:1 Changed 6 months ago by Stuart Auchterlonie

Resolution: Unverified
Status: newclosed

Closing all old tickets in trac.

If your issue still persists, please open an issue in Github

and reference the existing trac ticket.

Note: See TracTickets for help on using tickets.