id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc	mlocked
13019	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());
 
}}}"	Patch - Bug Fix	closed	minor	unknown	MythTV - General	Master Head	medium	Unverified			0