[mythtv-users] zap2it, mythfilldatabase issue, channels present, not filling

Mike Fenston altmcf at gmail.com
Mon Apr 16 03:36:15 UTC 2007


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.


More information about the mythtv-users mailing list