Opened 7 years ago
Closed 4 years ago
#13019 closed Patch - Bug Fix (Unverified)
Patch progdetails.cpp to treat relevance column as the character it is
Reported by: | 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());
Note: See
TracTickets for help on using
tickets.
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.