Opened 3 years ago

#13019 new Patch - Bug Fix

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

Description

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 (0)

Note: See TracTickets for help on using tickets.