[mythtv-users] V31, switching to xmltv on fedora

[Bill Meek]

On 4/12/20 9:39 AM, Jay Harbeston wrote:
> 
> 
>> On Apr 12, 2020, at 10:04 AM, Richard Shaw <hobbes1069 at gmail.com> wrote:
>>
>> Glad you got it figured out!
>>
>> So a follow up question to the group. Does mythfilldatabase need access to the SchedulesDirect sqlite database or just the grabber script?
>>
>> And when running mythfilldatabase I get these but when I look in MythWeb all the xmltvids are filled:
>>

...

>> 2020-04-12 09:01:40.341471 N [55795/55795] CoreContext programdata.cpp:1494:HandlePrograms  Unknown xmltv channel identifier: I88797.json.schedulesdirect.org <http://i88797.json.schedulesdirect.org/> - Skipping channel.
>>
>> Thanks,
>> Richard
> 
> I have the same thing, and they are channels that I don’t actually receive, but are included for the area the I am in.  If you check the report for the lineup in SD, you can verify the numbers above with the numbers in the report to see if you care about them. For me they are channels that are out of range of my antenna.
> 
> I just ignore the messages that I get similar to the above.

Ignoring the Notice is OK.

tl;dr

I suspect if you try this:

   mysql --user=mythtv --password --execute="SELECT sourceid,chanid,xmltvid,visible  \
     FROM channel WHERE xmltvid LIKE '%88797%'" mythconverg

You'll get nothing or an xmltvid that's just an integer. The actual query
used before the log message above includes the sourceid.

Then (using your actual DB file name):

   echo "SELECT * FROM channels WHERE station='88797';" | \
   sqlite3 --column --header ~mythtv/.xmltv/SchedulesDirect.DB

'selected' will be set to 1, and you really want it to be 0.

The Wiki has some commands of interest:

   https://www.mythtv.org/wiki/XMLTV#Channel_selection_shortcut_2

-- 
Bill