[mythtv-users] How To Configure Channel Priorities

[DaveD]

I've been using mysql CLI for years so I prefer it.  Here's how I do it 
(I have no root password set on the database).  Disclaimer (like the 
Windows registry warning):  you could really mess things up if you make 
a mistake so backup the database first.

mysql -u root mythconverg

describe channel;   (shows all fields available in channel table)

The fields I like to use are listed with the following command. It gives 
me a concise comparison of all channels for callsign KCPQ:

select chanid,channum,freqid,sourceid,callsign,name,xmltvid,recpriority 
from channel where callsign like "%KCPQ%" order by convert(channum,integer);

Then, to set a priority:

update channel set recpriority=5 where chanid=6131;

I like to use chanid since the channum is a string and can be 13-1 or 
13.1 or anything you or the grabber set it to.

exit;  (exit the mysql cli)

There is also an interface via mythweb, but I'm not very familiar with it.

Dave D.


On 5/27/20 7:02 AM, Stephen Worthington wrote:
> On Wed, 27 May 2020 06:11:54 -0700, you wrote:
>
>> On 5/26/20 8:17 PM, Stephen Worthington wrote:
>>> On Tue, 26 May 2020 15:55:46 -0700, you wrote:
>>>
>>>> I am using MythTV 0.28.  I would like to change the recording priority
>>>> for one of my channels.
>>>>
>>>> For example, I have two different channels with the same call sign, and
>>>> I would like to raise the priority on one of them to prefer using it
>>>> instead of the other channel.
>>>>
>>>> I looked at the wiki
>>>> (https://www.mythtv.org/wiki/Scheduling_Recordings), but when I go to
>>>> the Recording Priorities->Channel Priorities configuration, it does not
>>>> show the associated channel numbers, only the call sign.  I cannot tell
>>>> one channel from another.
>>>>
>>>> Is there some mysql query that I can use to manually configure this?
>>>>
>>>> Jay
>>> You certainly could set the individual channel priorities using SQL
>>> commands, but there is no need as they are available in the
>>> mythtv-setup GUI.  You can adjust them without shutting down
>>> mythbackend.  On Ubuntu, where mythtv-setup is a script that runs
>>> mythtv-setup.real, go to a command prompt running as your frontend
>>> user and run mythtv-setup.real.  When mythtv-setup.real asks to stop
>>> mythbackend, tell it no.  Then on v30 I would do this:
>>>
>>> 6. Channel Editor > select the channel you want > Enter > Channel
>>> Options - Common > Scroll down to Priority (it is off the bottom of
>>> the screen)
>>>
>>> In 0.28 it will be a little different, but you can select the
>>> individual channels by number and the Priority setting should be
>>> there.
>>>
>> Thanks,  This method seemed to work.  I ended up using the MythTV
>> Backend Setup to do this and I needed to stop the backend and restart it
>> to get it to reschedule using the changed channel priority.
>> Jay
> Getting the scheduler to run again is easy:
>
> mythtutil --resched
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org