Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Users

zap2it, mythfilldatabase issue, channels present, not filling

 

 

MythTV users RSS feed   Index | Next | Previous | View Threaded


altmcf at gmail

Apr 15, 2007, 8:36 PM

Post #1 of 3 (802 views)
Permalink
zap2it, mythfilldatabase issue, channels present, not filling

Hi All,

Running a FC5 mythtv box. Channel updates were working fine via
mythfilldatabase until recently. Maybe something changed due to all
the timezone problems which I finally got sorted out a few weeks ago?
Anyway ... when I run mythfilldatabase I get the output below. I went
into mythtvsetup and verified all my channels were there so not sure
what the problem is.

I tried deleting out the program data from the database as follows:
$ mysql -u mythtv -pmythtv mythconverg
mysql > delete from program;
mysql > quit
mythfilldatabase

I also tried the --do-channel-updates and --only-update-channels
options but no luck ... nothing seems to get pulled. My zap2it
membership is up to date. Any help appreciated - unhappy wife
currently :)

2007-04-15 20:34:03.873 Using runtime prefix = /usr
2007-04-15 20:34:03.903 New DB connection, total: 1
2007-04-15 20:34:03.911 Connected to database 'mythconverg' at host: localhost
2007-04-15 20:34:03.918 New DB connection, total: 2
2007-04-15 20:34:03.918 Connected to database 'mythconverg' at host: localhost
2007-04-15 20:34:03.919 Updating source #1 (zap2it) with grabber datadirect
2007-04-15 20:34:03.920
2007-04-15 20:34:03.920 Checking day @ offset 0, date: Sun Apr 15 2007
2007-04-15 20:34:03.922 Data refresh needed because no data exists for
day @ offset 0 from 6PM - midnight.
2007-04-15 20:34:03.922 Refreshing data for Sun Apr 15 2007
2007-04-15 20:34:03.923 New DB DataDirect connection
2007-04-15 20:34:03.923 Connected to database 'mythconverg' at host: localhost
2007-04-15 20:34:03.925 Retrieving datadirect data.
2007-04-15 20:34:03.925 Grabbing data for Sun Apr 15 2007 offset 0
2007-04-15 20:34:03.925 From Sun Apr 15 07:00:00 2007 to Mon Apr 16
07:00:00 2007 (UTC)
2007-04-15 20:34:03.925 Grabbing listing data
2007-04-15 20:34:04.399 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:04.400 Main temp tables populated.
2007-04-15 20:34:04.400 Updating myth channels.
2007-04-15 20:34:04.402 New DB connection, total: 3
2007-04-15 20:34:04.403 Connected to database 'mythconverg' at host: localhost
2007-04-15 20:34:04.404 Updating icons for sourceid: 1
2007-04-15 20:34:04.406 Channels updated.
2007-04-15 20:34:04.408 Did not find any new program data.
2007-04-15 20:34:04.408
2007-04-15 20:34:04.408 Checking day @ offset 1, date: Mon Apr 16 2007
2007-04-15 20:34:04.408 Refreshing data for Mon Apr 16 2007
2007-04-15 20:34:04.409 Retrieving datadirect data.
2007-04-15 20:34:04.409 Grabbing data for Sun Apr 15 2007 offset 1
2007-04-15 20:34:04.409 From Mon Apr 16 07:00:00 2007 to Tue Apr 17
07:00:00 2007 (UTC)
2007-04-15 20:34:04.410 Grabbing listing data
2007-04-15 20:34:04.816 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:04.816 Main temp tables populated.
2007-04-15 20:34:04.819 Did not find any new program data.
2007-04-15 20:34:04.819
2007-04-15 20:34:04.819 Checking day @ offset 2, date: Tue Apr 17 2007
2007-04-15 20:34:04.820 Data refresh needed because no data exists for
day @ offset 2 from 6PM - midnight.
2007-04-15 20:34:04.821 Refreshing data for Tue Apr 17 2007
2007-04-15 20:34:04.822 Retrieving datadirect data.
2007-04-15 20:34:04.822 Grabbing data for Sun Apr 15 2007 offset 2
2007-04-15 20:34:04.822 From Tue Apr 17 07:00:00 2007 to Wed Apr 18
07:00:00 2007 (UTC)
2007-04-15 20:34:04.822 Grabbing listing data
2007-04-15 20:34:05.223 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:05.223 Main temp tables populated.
2007-04-15 20:34:05.226 Did not find any new program data.
2007-04-15 20:34:05.226
2007-04-15 20:34:05.226 Checking day @ offset 3, date: Wed Apr 18 2007
2007-04-15 20:34:05.227 Data refresh needed because no data exists for
day @ offset 3 from 6PM - midnight.
2007-04-15 20:34:05.228 Refreshing data for Wed Apr 18 2007
2007-04-15 20:34:05.228 Retrieving datadirect data.
2007-04-15 20:34:05.228 Grabbing data for Sun Apr 15 2007 offset 3
2007-04-15 20:34:05.228 From Wed Apr 18 07:00:00 2007 to Thu Apr 19
07:00:00 2007 (UTC)
2007-04-15 20:34:05.228 Grabbing listing data
2007-04-15 20:34:05.644 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:05.644 Main temp tables populated.
2007-04-15 20:34:05.647 Did not find any new program data.
2007-04-15 20:34:05.647
2007-04-15 20:34:05.647 Checking day @ offset 4, date: Thu Apr 19 2007
2007-04-15 20:34:05.648 Data refresh needed because no data exists for
day @ offset 4 from 6PM - midnight.
2007-04-15 20:34:05.648 Refreshing data for Thu Apr 19 2007
2007-04-15 20:34:05.649 Retrieving datadirect data.
2007-04-15 20:34:05.649 Grabbing data for Sun Apr 15 2007 offset 4
2007-04-15 20:34:05.649 From Thu Apr 19 07:00:00 2007 to Fri Apr 20
07:00:00 2007 (UTC)
2007-04-15 20:34:05.649 Grabbing listing data
2007-04-15 20:34:06.049 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:06.049 Main temp tables populated.
2007-04-15 20:34:06.051 Did not find any new program data.
2007-04-15 20:34:06.051
2007-04-15 20:34:06.051 Checking day @ offset 5, date: Fri Apr 20 2007
2007-04-15 20:34:06.053 Data refresh needed because no data exists for
day @ offset 5 from 6PM - midnight.
2007-04-15 20:34:06.053 Refreshing data for Fri Apr 20 2007
2007-04-15 20:34:06.054 Retrieving datadirect data.
2007-04-15 20:34:06.054 Grabbing data for Sun Apr 15 2007 offset 5
2007-04-15 20:34:06.054 From Fri Apr 20 07:00:00 2007 to Sat Apr 21
07:00:00 2007 (UTC)
2007-04-15 20:34:06.054 Grabbing listing data
2007-04-15 20:34:06.471 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:06.471 Main temp tables populated.
2007-04-15 20:34:06.474 Did not find any new program data.
2007-04-15 20:34:06.474
2007-04-15 20:34:06.474 Checking day @ offset 6, date: Sat Apr 21 2007
2007-04-15 20:34:06.475 Data refresh needed because no data exists for
day @ offset 6 from 6PM - midnight.
2007-04-15 20:34:06.475 Refreshing data for Sat Apr 21 2007
2007-04-15 20:34:06.476 Retrieving datadirect data.
2007-04-15 20:34:06.476 Grabbing data for Sun Apr 15 2007 offset 6
2007-04-15 20:34:06.476 From Sat Apr 21 07:00:00 2007 to Sun Apr 22
07:00:00 2007 (UTC)
2007-04-15 20:34:06.476 Grabbing listing data
2007-04-15 20:34:06.895 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:06.896 Main temp tables populated.
2007-04-15 20:34:06.898 Did not find any new program data.
2007-04-15 20:34:06.898
2007-04-15 20:34:06.898 Checking day @ offset 7, date: Sun Apr 22 2007
2007-04-15 20:34:06.900 Data refresh needed because no data exists for
day @ offset 7 from 6PM - midnight.
2007-04-15 20:34:06.900 Refreshing data for Sun Apr 22 2007
2007-04-15 20:34:06.900 Retrieving datadirect data.
2007-04-15 20:34:06.900 Grabbing data for Sun Apr 15 2007 offset 7
2007-04-15 20:34:06.900 From Sun Apr 22 07:00:00 2007 to Mon Apr 23
07:00:00 2007 (UTC)
2007-04-15 20:34:06.901 Grabbing listing data
2007-04-15 20:34:07.313 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:07.314 Main temp tables populated.
2007-04-15 20:34:07.316 Did not find any new program data.
2007-04-15 20:34:07.316
2007-04-15 20:34:07.316 Checking day @ offset 8, date: Mon Apr 23 2007
2007-04-15 20:34:07.318 Data refresh needed because no data exists for
day @ offset 8 from 6PM - midnight.
2007-04-15 20:34:07.318 Refreshing data for Mon Apr 23 2007
2007-04-15 20:34:07.318 Retrieving datadirect data.
2007-04-15 20:34:07.318 Grabbing data for Sun Apr 15 2007 offset 8
2007-04-15 20:34:07.318 From Mon Apr 23 07:00:00 2007 to Tue Apr 24
07:00:00 2007 (UTC)
2007-04-15 20:34:07.318 Grabbing listing data
2007-04-15 20:34:07.729 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:07.730 Main temp tables populated.
2007-04-15 20:34:07.732 Did not find any new program data.
2007-04-15 20:34:07.732
2007-04-15 20:34:07.732 Checking day @ offset 9, date: Tue Apr 24 2007
2007-04-15 20:34:07.734 Data refresh needed because no data exists for
day @ offset 9 from 6PM - midnight.
2007-04-15 20:34:07.734 Refreshing data for Tue Apr 24 2007
2007-04-15 20:34:07.735 Retrieving datadirect data.
2007-04-15 20:34:07.735 Grabbing data for Sun Apr 15 2007 offset 9
2007-04-15 20:34:07.735 From Tue Apr 24 07:00:00 2007 to Wed Apr 25
07:00:00 2007 (UTC)
2007-04-15 20:34:07.735 Grabbing listing data
2007-04-15 20:34:08.139 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:08.139 Main temp tables populated.
2007-04-15 20:34:08.141 Did not find any new program data.
2007-04-15 20:34:08.142
2007-04-15 20:34:08.142 Checking day @ offset 10, date: Wed Apr 25 2007
2007-04-15 20:34:08.143 Data refresh needed because no data exists for
day @ offset 10 from 6PM - midnight.
2007-04-15 20:34:08.143 Refreshing data for Wed Apr 25 2007
2007-04-15 20:34:08.144 Retrieving datadirect data.
2007-04-15 20:34:08.144 Grabbing data for Sun Apr 15 2007 offset 10
2007-04-15 20:34:08.144 From Wed Apr 25 07:00:00 2007 to Thu Apr 26
07:00:00 2007 (UTC)
2007-04-15 20:34:08.144 Grabbing listing data
2007-04-15 20:34:08.546 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:08.546 Main temp tables populated.
2007-04-15 20:34:08.548 Did not find any new program data.
2007-04-15 20:34:08.549
2007-04-15 20:34:08.549 Checking day @ offset 11, date: Thu Apr 26 2007
2007-04-15 20:34:08.550 Data refresh needed because no data exists for
day @ offset 11 from 6PM - midnight.
2007-04-15 20:34:08.550 Refreshing data for Thu Apr 26 2007
2007-04-15 20:34:08.551 Retrieving datadirect data.
2007-04-15 20:34:08.551 Grabbing data for Sun Apr 15 2007 offset 11
2007-04-15 20:34:08.551 From Thu Apr 26 07:00:00 2007 to Fri Apr 27
07:00:00 2007 (UTC)
2007-04-15 20:34:08.551 Grabbing listing data
2007-04-15 20:34:08.954 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:08.954 Main temp tables populated.
2007-04-15 20:34:08.956 Did not find any new program data.
2007-04-15 20:34:08.956
2007-04-15 20:34:08.956 Checking day @ offset 12, date: Fri Apr 27 2007
2007-04-15 20:34:08.958 Data refresh needed because no data exists for
day @ offset 12 from 6PM - midnight.
2007-04-15 20:34:08.958 Refreshing data for Fri Apr 27 2007
2007-04-15 20:34:08.958 Retrieving datadirect data.
2007-04-15 20:34:08.958 Grabbing data for Sun Apr 15 2007 offset 12
2007-04-15 20:34:08.959 From Fri Apr 27 07:00:00 2007 to Sat Apr 28
07:00:00 2007 (UTC)
2007-04-15 20:34:08.959 Grabbing listing data
2007-04-15 20:34:09.360 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:09.361 Main temp tables populated.
2007-04-15 20:34:09.363 Did not find any new program data.
2007-04-15 20:34:09.363
2007-04-15 20:34:09.363 Checking day @ offset 13, date: Sat Apr 28 2007
2007-04-15 20:34:09.365 Data refresh needed because no data exists for
day @ offset 13 from 6PM - midnight.
2007-04-15 20:34:09.365 Refreshing data for Sat Apr 28 2007
2007-04-15 20:34:09.365 Retrieving datadirect data.
2007-04-15 20:34:09.365 Grabbing data for Sun Apr 15 2007 offset 13
2007-04-15 20:34:09.365 From Sat Apr 28 07:00:00 2007 to Sun Apr 29
07:00:00 2007 (UTC)
2007-04-15 20:34:09.366 Grabbing listing data
2007-04-15 20:34:09.771 Grab complete. Actual data from to (UTC)
2007-04-15 20:34:09.772 Main temp tables populated.
2007-04-15 20:34:09.774 Did not find any new program data.
2007-04-15 20:34:09.786 New DB connection, total: 4
2007-04-15 20:34:09.787 Connected to database 'mythconverg' at host: localhost
2007-04-15 20:34:09.789 New DB connection, total: 5
2007-04-15 20:34:09.790 Connected to database 'mythconverg' at host: localhost
2007-04-15 20:34:09.792 Failed to fetch some program info
2007-04-15 20:34:09.792 Adjusting program database end times.
2007-04-15 20:34:09.792 0 replacements made
2007-04-15 20:34:09.792 Marking generic episodes.
2007-04-15 20:34:09.792 Found 0
2007-04-15 20:34:09.793 Marking repeats.
2007-04-15 20:34:09.794 Found 0
2007-04-15 20:34:09.794 Unmarking new episode rebroadcast repeats.
2007-04-15 20:34:09.794 Found 0
2007-04-15 20:34:09.794 Marking episode first showings.
2007-04-15 20:34:09.795 Found 0
2007-04-15 20:34:09.795 Marking episode last showings.
2007-04-15 20:34:09.795 Found 0
2007-04-15 20:34:09.796 Grabbing next suggested grabbing time
2007-04-15 20:34:10.189
===============================================================
| Attempting to contact the master backend for rescheduling. |
| If the master is not running, rescheduling will happen when |
| the master backend is restarted. |
===============================================================
2007-04-15 20:34:10.193 Connecting to backend server: 127.0.0.1:6543
(try 1 of 5)
2007-04-15 20:34:10.195 Using protocol version 31
2007-04-15 20:34:10.207 mythfilldatabase run complete.
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


mtdean at thirdcontact

Apr 15, 2007, 8:48 PM

Post #2 of 3 (679 views)
Permalink
Re: zap2it, mythfilldatabase issue, channels present, not filling [In reply to]

On 04/15/2007 11:36 PM, Mike Fenston wrote:
> Running a FC5 mythtv box. Channel updates were working fine via
> mythfilldatabase until recently. Maybe something changed due to all
> the timezone problems which I finally got sorted out a few weeks ago?
> Anyway ... when I run mythfilldatabase I get the output below. I went
> into mythtvsetup and verified all my channels were there so not sure
> what the problem is.
>
> I tried deleting out the program data from the database as follows:
> $ mysql -u mythtv -pmythtv mythconverg
> mysql > delete from program;
> mysql > quit
> mythfilldatabase
>
> I also tried the --do-channel-updates and --only-update-channels
> options but no luck ... nothing seems to get pulled. My zap2it
> membership is up to date. Any help appreciated - unhappy wife
> currently :)

If that's really the output you got (i.e. you didn't cut anything), my
guess is that all the channels in your lineup got removed. Check the
lineup first (and, if empty, you may need to delete it from the website
and create another with the same name).

If that's not the issue, the "Delete All" fallback should work.
http://www.gossamer-threads.com/lists/mythtv/users/261405#261405

Mike
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users


malban at mail

Apr 16, 2007, 8:03 AM

Post #3 of 3 (672 views)
Permalink
Re: zap2it, mythfilldatabase issue, channels present, not filling [In reply to]

Mike Fenston wrote:
> I tried deleting out the program data from the database as follows:
> $ mysql -u mythtv -pmythtv mythconverg
> mysql > delete from program;
> mysql > quit
> mythfilldatabase
>
> I also tried the --do-channel-updates and --only-update-channels
> options but no luck ... nothing seems to get pulled. My zap2it
> membership is up to date. Any help appreciated - unhappy wife
> currently :)
Maybe part of the database got corrupted? Try running
optimize_mythdb.pl in the contrib directory and then running
mythfilldatabase again.

Marc
_______________________________________________
mythtv-users mailing list
mythtv-users[at]mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

MythTV users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.