[mythtv-users] Why is Mythfilldatabase deleting channels

tbaca at heritagewifi.com tbaca at heritagewifi.com
Mon Nov 20 05:59:15 UTC 2006 

> ------------------------------
>
> Message: 8
> Date: Tue, 31 Oct 2006 12:29:26 -0500
> From: Daniel Kristjansson <danielk at cuymedia.net>
> Subject: Re: [mythtv-users] Why is Mythfilldatabase deleting channels
> To: Discussion about mythtv <mythtv-users at mythtv.org>
> Message-ID: <1162315766.14675.66.camel at cuy.kristjansson.com>
> Content-Type: text/plain; charset=UTF-8
>
> On Tue, 2006-10-31 at 09:42 -0700, tbaca at heritagewifi.com wrote:
>> As for the 4DTV, it is a C-Band Satellite receiver and comes into Myth
>> via S-Video.  I have it only connected to the S-video input in
>> Myth-Setup.  Strange thing is that when I first created the line up,
>> it did not find most of the channels; I should have checked, but I bet
>> it only found the same 14 channels it wants to keep now.
>>  Until the present issue happened, I forgot how I got all the other
>>  channels in there before.  As many a mother will tell you, they
>>  forget the pain of childbirth once they see the baby.  That is
>>  kind-of where I was.  I had forgotten that I had hand entered some
>>  100 channels via the channel editor.
>> On a side note, maybe someone with better skill than I could help
>> create a basic SQL script that I could populate and then run to fill
>> the database with this information.
>> Back to main story, after I entered the channels via Channel Editor,
>> mythfilldatabase worked great.  As I said above, I ran
>> ¡§¡Xdo-channel-updates¡¨ and that is when things went wrong?  Looks
>> like I will need to re-hand enter the channels ?¼
>
> Ok, so what you need to do is get mythfilldatabase to insert these
> 'analog' channels for you.
>
> First go to the zap2it website and select all the channels you get,
> then run this:
>  mythfilldatabase --sourceid sourceid-of-4dtv-source \
>      --only-update-channels --do-channel-updates
>
> This will insert all the channels you have selected in the zap2it
> website for the 4DTV source.
>
> Then for the nightly run use this:
>  mythfilldatabase --remove-new-channels
> That will prevent MythTV from adding any new channels when they
> are added to the 4DTV lineup (since you most likely won't be
> able to get these).
>
> If you have any conventional analog sources, such as a OTA analog, then
> run this before running the above to get the listings:
>  mythfilldatabase --sourceid id-of-ota-analog-source \
>                   --only-update-channels
>
> BTW There appears to be something wrong with your mail reader,
> it looks like it is not setting "References:" header properly,
> so your replies drop out of the thread they were in.
>
> -- Daniel
>
>
>
Tried the above, but it did not fix the problem; still deleting the channels?
Mythfilldatabase output:

Mythtv:/var/log/mythtv # mythfilldatabase --sourceid 3 
--only-update-channels --do-channel-updates2006-11-19 22:45:13.054 Using runtime prefix = /usr
2006-11-19 22:45:13.070 New DB connection, total: 1
2006-11-19 22:45:13.076 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:45:13.083 mythfilldatabase: Listings Download Started
2006-11-19 22:45:13.083 Running for sourceid 3 ONLY because --sourceid was
given on command-line2006-11-19 22:45:13.084 New DB connection, total: 2
2006-11-19 22:45:13.085 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:45:13.215 Updating source #3 (4dtv) with grabber datadirect
2006-11-19 22:45:13.215 Grabbing login cookies and lineups
2006-11-19 22:45:14.499 Grabbing lineup 4DTV:- for modification
2006-11-19 22:45:17.019 Grabbing channel data
--22:45:17--  http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
           => `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80...
connected.HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to datadirect.webservices.zap2it.com:80.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

    [          <=>                                    ] 27,655       
    18.10K/s
22:45:24 (3.93 KB/s) - `-' saved [27655]

2006-11-19 22:45:24.771 New DB DataDirect connection
2006-11-19 22:45:24.771 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:45:24.785 DataDirect: Your subscription expires on
12/16/2006 03:23:09 PM2006-11-19 22:45:24.893 New DB connection, total: 3
2006-11-19 22:45:24.893 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:45:24.894 sourceid 3 has lineup type: Satellite
2006-11-19 22:45:24.900 sourceid 2 has lineup type: LocalBroadcast
2006-11-19 22:45:24.912 sourceid 1 has lineup type: LocalBroadcast
2006-11-19 22:45:25.570 SaveLineupToCache(4DTV:-) -- success
2006-11-19 22:45:25.832 Data fetching complete.
Mythtv:/var/log/mythtv # mythfilldatabase --sourceid 3  --remove-new-channels
2006-11-19 22:45:50.166 Using runtime prefix = /usr
2006-11-19 22:45:50.183 New DB connection, total: 1
2006-11-19 22:45:50.188 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:45:50.195 mythfilldatabase: Listings Download Started
2006-11-19 22:45:50.195 Running for sourceid 3 ONLY because --sourceid was
given on command-line2006-11-19 22:45:50.197 New DB connection, total: 2
2006-11-19 22:45:50.197 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:45:50.327 Updating source #3 (4dtv) with grabber datadirect
2006-11-19 22:45:50.327
2006-11-19 22:45:50.327 Checking day @ offset 0, date: Sun Nov 19 2006
2006-11-19 22:45:50.400 Data is already present for Sun Nov 19 2006, skipping
2006-11-19 22:45:50.400
2006-11-19 22:45:50.400 Checking day @ offset 1, date: Mon Nov 20 2006
2006-11-19 22:45:50.400 Refreshing data for Mon Nov 20 2006
2006-11-19 22:45:50.401 New DB DataDirect connection
2006-11-19 22:45:50.401 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:45:50.402 Retrieving datadirect data.
2006-11-19 22:45:50.402 Grabbing data for Sun Nov 19 2006 offset 1
2006-11-19 22:45:50.402 From Mon Nov 20 07:00:00 2006 to Tue Nov 21
07:00:00 2006 (UTC)2006-11-19 22:45:50.403 Grabbing listing data
--22:45:50--  http://datadirect.webservices.zap2it.com/tvlistings/xtvdService
           => `-'
Resolving datadirect.webservices.zap2it.com... 206.18.98.160
Connecting to datadirect.webservices.zap2it.com|206.18.98.160|:80...
connected.HTTP request sent, awaiting response... 401 Unauthorized
Reusing existing connection to datadirect.webservices.zap2it.com:80.
HTTP request sent, awaiting response... 200 OK
Length: unspecified [text/xml]

    [                        <=>                      ] 300,310      
    54.61K/s
22:46:02 (34.30 KB/s) - `-' saved [300310]

2006-11-19 22:46:02.890 DataDirect: Your subscription expires on
12/16/2006 03:23:09 PM2006-11-19 22:46:02.997 New DB connection, total: 3
2006-11-19 22:46:02.998 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:46:02.999 sourceid 3 has lineup type: Satellite
2006-11-19 22:46:03.004 sourceid 2 has lineup type: LocalBroadcast
2006-11-19 22:46:03.016 sourceid 1 has lineup type: LocalBroadcast
2006-11-19 22:46:13.405 Grab complete.  Actual data from Mon Nov 20
07:00:00 2006 to Tue Nov 21 07:00:00 2006 (UTC)2006-11-19 22:46:13.405 Main temp tables populated.
2006-11-19 22:46:13.406 Updating myth channels.
2006-11-19 22:46:13.461 DataDirect: Not adding channel CineMAX (MAX).
2006-11-19 22:46:13.462 DataDirect: Not adding channel CineMAX (MAX).
2006-11-19 22:46:13.463 DataDirect: Not adding channel MoreMAX (MOMAX).
2006-11-19 22:46:13.464 DataDirect: Not adding channel KUON (KUON).
2006-11-19 22:46:13.465 DataDirect: Not adding channel Lifetime (LIFE).
2006-11-19 22:46:13.466 DataDirect: Not adding channel (EduCable) Nebraska
Educational Telecomm (NET2).2006-11-19 22:46:13.467 DataDirect: Not adding channel Nickelodeon (NIK).
2006-11-19 22:46:13.468 DataDirect: Not adding channel Nickelodeon
(Pacific) (NIKP).2006-11-19 22:46:13.469 DataDirect: Not adding channel Sci-Fi Channel
(SCIFI).2006-11-19 22:46:13.470 DataDirect: Not adding channel SPIKE TV (SPIKETV).
2006-11-19 22:46:13.471 DataDirect: Not adding channel Turner Network TV
(TNT).2006-11-19 22:46:13.472 DataDirect: Not adding channel The Weather Channel
(TWC).2006-11-19 22:46:13.473 DataDirect: Not adding channel USA Network (USA).
2006-11-19 22:46:13.474 DataDirect: Not adding channel World Harvest
Television (WHMBSAT).2006-11-19 22:46:13.474 DataDirect: Not adding channel Turner Broadcasting
System (TBS).2006-11-19 22:46:13.475 DataDirect: Not adding channel Cartoon Network
(TOON).2006-11-19 22:46:13.476 DataDirect: Not adding channel CineMAX (Pacific)
(MAXP).2006-11-19 22:46:13.477 DataDirect: Not adding channel CineMAX (Pacific)
(MAXP).2006-11-19 22:46:13.478 DataDirect: Not adding channel Food Network (FOOD).
2006-11-19 22:46:13.479 DataDirect: Not adding channel Turner Classic
Movies (TCM).2006-11-19 22:46:13.480 DataDirect: Not adding channel PBSX (PBSX).
2006-11-19 22:46:13.481 DataDirect: Not adding channel PBSX (PBSX).
2006-11-19 22:46:13.482 DataDirect: Not adding channel The Outdoor Channel
(OUTDOOR).2006-11-19 22:46:13.483 DataDirect: Not adding channel ESPN Classic (ESPNCL).
2006-11-19 22:46:13.484 DataDirect: Not adding channel VERSUS (VERSUS).
2006-11-19 22:46:13.484 DataDirect: Not adding channel VERSUS (VERSUS).
2006-11-19 22:46:13.485 DataDirect: Not adding channel Speed Channel (SPEED).
2006-11-19 22:46:13.486 DataDirect: Not adding channel MTV2: Music
Television (MTV2).2006-11-19 22:46:13.487 DataDirect: Not adding channel ESPNEWS (ESPNEWS).
2006-11-19 22:46:13.488 DataDirect: Not adding channel The Science Channel
(SCIENCE).2006-11-19 22:46:13.489 DataDirect: Not adding channel MoreMAX (Pacific)
(MOMAXP).2006-11-19 22:46:13.490 DataDirect: Not adding channel Northwest Cable
News (NWCN).2006-11-19 22:46:13.491 DataDirect: Not adding channel WGN/UVTV Satellite
Group (WGNSAT).2006-11-19 22:46:13.492 DataDirect: Not adding channel Toon Disney (TOOND).
2006-11-19 22:46:13.493 DataDirect: Not adding channel The Military
Channel (MILI).2006-11-19 22:46:13.494 DataDirect: Not adding channel ThrillerMAX (THMAX).
2006-11-19 22:46:13.495 DataDirect: Not adding channel ThrillerMAX
(Pacific) (THMAXP).2006-11-19 22:46:13.496 DataDirect: Not adding channel MTV Tres (MTV3S).
2006-11-19 22:46:13.497 DataDirect: Not adding channel VH1 Soul (VH1SOUL).
2006-11-19 22:46:13.498 DataDirect: Not adding channel Noggin & The N (NOGN).
2006-11-19 22:46:13.499 DataDirect: Not adding channel The Learning
Channel (Pacific) (TLCP).2006-11-19 22:46:13.500 DataDirect: Not adding channel Nickelodeon Games
and Sports (GAS).2006-11-19 22:46:13.500 DataDirect: Not adding channel TV Games Network
(TVG).2006-11-19 22:46:13.501 DataDirect: Not adding channel The History Channel
(Pacific Feed) (HISTP).2006-11-19 22:46:13.502 DataDirect: Not adding channel VH1 Classic (VH1CL).
2006-11-19 22:46:13.503 DataDirect: Not adding channel National Geographic
Channel (NGC).2006-11-19 22:46:13.504 DataDirect: Not adding channel RFD TV (RFDTV).
2006-11-19 22:46:13.505 DataDirect: Not adding channel W MAX--WOMAX (WOMAX).
2006-11-19 22:46:13.506 DataDirect: Not adding channel OuterMAX (OMAX).
2006-11-19 22:46:13.508 DataDirect: Not adding channel MTV Hits (U.S.)
(MTVHIT).2006-11-19 22:46:13.509 DataDirect: Not adding channel MTV Jams (MTVJAMS).
2006-11-19 22:46:13.510 DataDirect: Not adding channel Nicktoons Network
(NIKTON).2006-11-19 22:46:13.511 DataDirect: Not adding channel Bravo (Pacific
Feed) (BRAVOP).2006-11-19 22:46:13.512 DataDirect: Not adding channel KLNEDT (KLNE-DT)
(KLNEDT).2006-11-19 22:46:13.513 DataDirect: Not adding channel WEALTH TV (WEALTH).
2006-11-19 22:46:13.514 DataDirect: Not adding channel LOGO (LOGO).
2006-11-19 22:46:13.514 Updating icons for sourceid: 3
2006-11-19 22:46:13.515 Grabbing login cookies for listing update
2006-11-19 22:46:13.515 Grabbing login cookies and lineups
2006-11-19 22:46:14.784 Grabbing listing for listing update
2006-11-19 22:46:14.784 Grabbing lineup 4DTV:- for modification
2006-11-19 22:46:17.274 Saving updated DataDirect listing
2006-11-19 22:46:17.275 Saving lineup 4DTV:- with 77 channels
2006-11-19 22:46:20.359 Removed 56 channel(s) from lineup.
2006-11-19 22:46:20.359 Channels updated.
2006-11-19 22:46:20.535 Clearing data for source.
2006-11-19 22:46:20.535 Clearing from Mon Nov 20 00:00:00 2006 to Tue Nov
21 00:00:00 2006 (localtime)2006-11-19 22:46:20.536 New DB connection, total: 4
2006-11-19 22:46:20.537 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:46:21.509 Data for source cleared.
2006-11-19 22:46:21.509 Updating programs.
2006-11-19 22:46:22.962 Program table update complete.
2006-11-19 22:46:22.962
2006-11-19 22:46:22.962 Checking day @ offset 2, date: Tue Nov 21 2006
2006-11-19 22:46:23.034 Data is already present for Tue Nov 21 2006, skipping
2006-11-19 22:46:23.034
2006-11-19 22:46:23.034 Checking day @ offset 3, date: Wed Nov 22 2006
2006-11-19 22:46:23.105 Data is already present for Wed Nov 22 2006, skipping
2006-11-19 22:46:23.105
2006-11-19 22:46:23.105 Checking day @ offset 4, date: Thu Nov 23 2006
2006-11-19 22:46:23.175 Data is already present for Thu Nov 23 2006, skipping
2006-11-19 22:46:23.175
2006-11-19 22:46:23.175 Checking day @ offset 5, date: Fri Nov 24 2006
2006-11-19 22:46:23.245 Data is already present for Fri Nov 24 2006, skipping
2006-11-19 22:46:23.246
2006-11-19 22:46:23.246 Checking day @ offset 6, date: Sat Nov 25 2006
2006-11-19 22:46:23.315 Data is already present for Sat Nov 25 2006, skipping
2006-11-19 22:46:23.315
2006-11-19 22:46:23.315 Checking day @ offset 7, date: Sun Nov 26 2006
2006-11-19 22:46:23.385 Data is already present for Sun Nov 26 2006, skipping
2006-11-19 22:46:23.385
2006-11-19 22:46:23.385 Checking day @ offset 8, date: Mon Nov 27 2006
2006-11-19 22:46:23.455 Data is already present for Mon Nov 27 2006, skipping
2006-11-19 22:46:23.455
2006-11-19 22:46:23.455 Checking day @ offset 9, date: Tue Nov 28 2006
2006-11-19 22:46:23.524 Data is already present for Tue Nov 28 2006, skipping
2006-11-19 22:46:23.524
2006-11-19 22:46:23.524 Checking day @ offset 10, date: Wed Nov 29 2006
2006-11-19 22:46:23.593 Data is already present for Wed Nov 29 2006, skipping
2006-11-19 22:46:23.593
2006-11-19 22:46:23.593 Checking day @ offset 11, date: Thu Nov 30 2006
2006-11-19 22:46:23.662 Data is already present for Thu Nov 30 2006, skipping
2006-11-19 22:46:23.662
2006-11-19 22:46:23.662 Checking day @ offset 12, date: Fri Dec 1 2006
2006-11-19 22:46:23.730 Data is already present for Fri Dec 1 2006, skipping
2006-11-19 22:46:23.730
2006-11-19 22:46:23.730 Checking day @ offset 13, date: Sat Dec 2 2006
2006-11-19 22:46:23.798 Data is already present for Sat Dec 2 2006, skipping
2006-11-19 22:46:24.261 New DB connection, total: 5
2006-11-19 22:46:24.262 Connected to database 'mythconverg' at host:
localhost2006-11-19 22:46:24.264 Data fetching complete.
2006-11-19 22:46:24.264 Adjusting program database end times.
2006-11-19 22:46:25.305     0 replacements made
2006-11-19 22:46:25.307 mythfilldatabase: Listings Download Finished
2006-11-19 22:46:25.307 Marking generic episodes.
2006-11-19 22:46:25.563     Found 392
2006-11-19 22:46:25.563 Marking repeats.
2006-11-19 22:46:25.794     Found 1218
2006-11-19 22:46:25.794 Unmarking new episode rebroadcast repeats.
2006-11-19 22:46:26.019     Found 1
2006-11-19 22:46:26.490 Marking episode first showings.
2006-11-19 22:46:32.715     Found 11117
2006-11-19 22:46:32.715 Marking episode last showings.
2006-11-19 22:46:38.931     Found 11117
2006-11-19 22:46:39.041 Grabbing next suggested grabbing time
2006-11-19 22:46:39.604 DataDirect: BlockedTime is: 2006-11-19T22:46:39
2006-11-19 22:46:39.605 DataDirect: NextSuggestedTime is: 2006-11-20T04:27:20
2006-11-19 22:46:39.607
===============================================================
| Attempting to contact the master backend for rescheduling.  |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted.                            |
===============================================================
2006-11-19 22:46:39.612 Connecting to backend server: 127.0.0.1:6543 (try
1 of 5)2006-11-19 22:46:39.613 Using protocol version 31
2006-11-19 22:46:39.788 mythfilldatabase run complete.
Mythtv:/var/log/mythtv # mythfilldatabase

More information about the mythtv-users mailing list