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

[Gary Buhrmaster <gary.buhrmaster@…>]

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

[Stuart Auchterlonie]

Closing all old tickets in trac.

If your issue still persists, please open an issue in Github ​https://github.com/MythTV/mythtv/issues

and reference the existing trac ticket.