[mythtvnz] Problem with mythfilldatabase

[Paulgir]

On Sun, 05 Jun 2016 15:36:10 +1200, Stephen Worthington  
<stephen_agent at jsw.gen.nz> wrote:

> On Sun, 05 Jun 2016 15:06:56 +1200, you wrote:
>
>> On Sun, 05 Jun 2016 12:43:04 +1200, you wrote:
>>
>>> Hi all
>>>
>>> I have been having trouble with schedule updates over the last week.I  
>>> use
>>> a script run by cron to update with freeview.xml
>>> data.I decided to try to get tv_grab_nz-py to work.This was  
>>> unsuccessful
>>> (again).
>>> In the process I deleted and recreated my video sources and
>>> rescanned.Re-entered xmltv id for each channel in the channel editor.
>>>
>>> The problem is: when I run mythfilldatabase I get:
>>>
>>>  2016-06-05 12:29:16.181688 N  Unknown xmltv channel identifier:
>>> tv2.freeviewnz.tv - Skipping channel.
>>>
>>> messages for every channel.
>>>
>>> I think I may have missed a step in the process but I can find what.
>>>
>>> Any suggestions?
>>>
>>> _Paul
>>
>> Youn need to have a .xmltv config file in /home/<mythtv user>/.mythtv
>> for each source.  So for my FreeviewHD source, I have this file:
>>
>> root at mypvr:/home/stephen/.mythtv# cat FreeviewHD.xmltv
>> channel=tv1.freeviewnz.tv
>> channel=tv2.freeviewnz.tv
>> channel=tv3.freeviewnz.tv
>> channel=four.freeviewnz.tv
>> channel=maori-tv.freeviewnz.tv
>> channel=tv1-plus1.freeviewnz.tv
>> channel=tv2-plus1.freeviewnz.tv
>> channel=tv3-plus1.freeviewnz.tv
>> channel=four-plus1.freeviewnz.tv
>> channel=duke.freeviewnz.tv
>> channel=edge-tv.freeviewnz.tv
>> channel=prime.freeviewnz.tv
>> channel=choice.freeviewnz.tv
>> channel=shopping-channel.freeviewnz.tv
>> channel=parliament.freeviewnz.tv
>> channel!hope-channel.freeviewnz.tv
>> channel=aljazeera.freeviewnz.tv
>> channel=te-reo.freeviewnz.tv
>> channel!shine.freeviewnz.tv
>> channel=firstlight.freeviewnz.tv
>> channel=sommet-sports.freeviewnz.tv
>> channel=tvsn-shopping-channel.freeviewnz.tv
>> channel=chinese-tv8.freeviewnz.tv
>> channel=tv33.freeviewnz.tv
>> channel=yes-shop.freeviewnz.tv
>> channel=apna.freeviewnz.tv
>> channel=rnz-national.freeviewnz.tv
>> channel=rnz-concert.freeviewnz.tv
>> channel=basefm.freeviewnz.tv
>> channel!georgefm.freeviewnz.tv
>> channel!tvnz7.freeviewnz.tv
>> channel!tv9.freeviewnz.tv
>>
>> The = sign says to include the EPG data for that channel, and the ! to
>> exclude it.
>
> You can make your .xmltv file like this:
>
> root at mypvr:/home/stephen/.mythtv# mysql -s -N -p
> Enter password:
> mysql> tee /tmp/FreeviewHD.xmltv
> Logging to file '/tmp/FreeviewHD.xmltv'
> mysql> select concat('channel=',xmltvid) from channel where
> sourceid=1;
> channel=aljazeera.freeviewnz.tv
> channel=apna.freeviewnz.tv
> channel=basefm.freeviewnz.tv
> channel=chinese-tv8.freeviewnz.tv
> channel=choice.freeviewnz.tv
> channel=duke.freeviewnz.tv
> channel=edge-tv.freeviewnz.tv
> channel=firstlight.freeviewnz.tv
> channel=four-plus1.freeviewnz.tv
> channel=four.freeviewnz.tv
> channel=maori-tv.freeviewnz.tv
> channel=parliament.freeviewnz.tv
> channel=prime.freeviewnz.tv
> channel=rnz-concert.freeviewnz.tv
> channel=rnz-national.freeviewnz.tv
> channel=shopping-channel.freeviewnz.tv
> channel=te-reo.freeviewnz.tv
> channel=tv1-plus1.freeviewnz.tv
> channel=tv1.freeviewnz.tv
> channel=tv2-plus1.freeviewnz.tv
> channel=tv2.freeviewnz.tv
> channel=tv29.freeviewnz.tv
> channel=tv3-plus1.freeviewnz.tv
> channel=tv3.freeviewnz.tv
> channel=tv33.freeviewnz.tv
> channel=tvnz7.freeviewnz.tv
> channel=tvsn-shopping-channel.freeviewnz.tv
> channel=yes-shop.freeviewnz.tv
> mysql> notee
> Outfile disabled.
> mysql> quit
>
> You have to edit the file to remove the notee command on the end, then
> move it to the right directory.
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.linuxnut.co.nz
> http://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/

Thanks for that Stephen.I'll check it.
I got the database sorted by doing a full db restore from this morning's  
back up.

Cheers

Paul