[mythtv-users] mythfilldatabase failing to fill up all channel programs (tv_grab_no)

Wed Mar 9 10:22:39 UTC 2005

To summarize some channels have no program information and tv_grab_no
seems to work OK when running on the command line.

Long story:
---------------
I had to manually add my channels because scantv is not working for my PVR350.

To do so I used mplayer on /dev/video0 and then use ptune-ui.pl to
identify the channel numbers and names. Then I went to mythtv-setup
and filled the channel information. Then ran mythfilldatabase
--manual. I had made a couple of mistakes, plus decided to add some
more channels. To fix that, I first tried to use mythtv setup, then
prefered to go directly in th DB and modify the channel table, where I
had a better overview and could easily see my duplicates. I tried to
run mythfilldatabase --update but it didn't fill the information
correctly. I then did a "delete from program;" to clean the program
information and ran mythfilldatabase again. It refilled some programs,
but didn't fix the ones that are not working correclty. So I still
have some channels with no program information. I also have some
channels with wrong program information, but that I will fix later,
hoping it is not related.

I can see for example which channels have no program information using
this query (for pre mysql 4.1):

mysql> select distinct channel.chanid, xmltvid from channel LEFT JOIN
program on channel.chanid = program.chanid where program.chanid IS
NULL;

In my case:

+--------+------------------------+
| chanid | xmltvid                |
+--------+------------------------+
|   1000 | 18.fredag.dagbladet.no |
|   1002 | 38.fredag.dagbladet.no |
|   1003 | 55.fredag.dagbladet.no |
|   1008 |                        |
|   1014 | 3.fredag.dagbladet.no  |
+--------+------------------------+
5 rows in set (0.00 sec)

I don't care about the 1008 (it's a static channel, with music), but
the others I would like them to be filled!

the .xmltv/tv_grab_no.conf of the user running the backend seems
correct. The channels for the 18, 38, 55 and 3 are commented out.

When I run tv_grab_no | tv_sort > listings.xml I get program
information for these channels.

But when I run mythfilldatabase with or without cleaning the program
table, I still don't get information for these channels.

Then I found out this:

mysql> select chanid, finetune from channel where icon = 'none';
+--------+----------+
| chanid | finetune |
+--------+----------+
|   1000 |     NULL |
|   1002 |     NULL |
|   1003 |     NULL |
|   1008 |     NULL |
|   1012 |     NULL |
+--------+----------+
5 rows in set (0.00 sec)

This looked almost like the same list. So I tried to clean that up:

update channel set icon = '', finetune=0 where icon='none';

then ran mythfilldatabase again. But that didn't solve it... Now
looking at the settings table:

| mythfilldatabaseLastRunStatus   | mythfilldatabase ran, but did not
insert any new data into the Guide.  This can indicate a potential
grabber failure. | NULL     |

but this could be because I run mythfilldatabase manually, hence it
doesn't find new updates when mythtv runs it.

Is there something that I do wrong, or could there be a bug somewhere?

Here's my channel table (which looks OK to me).

INSERT INTO `channel` VALUES (1000,'SE11','SE11',1,'NatGeo','National
Geographic','',0,'','18.fredag.dagbladet.no',0,327
68,32768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1,'','E7',1,'3Via','3
Viasat','',0,'','1.fredag.dagbladet.no',0,32768,32768,32768,32768,'D
efault',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (2,'E8','E8',1,'NRK1','NRK
1','',0,'','10.fredag.dagbladet.no',0,32768,32768,32768,32768,'D
efault',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(3,'SE8','SE8',1,'MTV','MTV','',0,'','17.fredag.dagbladet.no',0,32768,32768,32768,32768,'De
fault',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (4,'SE14','SE14',1,'NRK2','NRK
2','',0,'','2.fredag.dagbladet.no',0,32768,32768,32768,32768
,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (5,'S38','S38',1,'Sky','Sky
News','',0,'','25.fredag.dagbladet.no',0,32768,32768,32768,3276
8,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1002,'S29','S29',1,'BBC','BBC
World','',0,'','38.fredag.dagbladet.no',0,32768,32768,32768,
32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1003,'SE15','SE15',1,'Sport1','Sport1
Viasat','',0,'','55.fredag.dagbladet.no',0,32768,327
68,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1008,'SE19','SE19',1,'UPC','UPC','',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,N
ULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1012,'E5','E5',1,'TV2','TV2','',0,'','3.fredag.dagbladet.no',0,32768,32768,32768,32768,'De
fault',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1013,'S27','S27',1,'TV5','TV5
Fra','',0,'','27.fredag.dagbladet.no',0,32768,32768,32768,32
768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1014,'S37','S37',1,'TV2x','TV2
extra','',0,'','3.fredag.dagbladet.no',0,32768,32768,32768,
32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1015,'','',1,'ZSve','ZTV
Sve','',0,'','30.fredag.dagbladet.no',0,32768,32768,32768,32768,'
Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1016,'SE9','SE9',1,'TCM','TCM','',0,'','31.fredag.dagbladet.no',0,32768,32768,32768,32768,
'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1017,'E11','E11',1,'Travel','Travel','',0,'','33.fredag.dagbladet.no',0,32768,32768,32768,
32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1018,'','',1,'C+','Canal+','',0,'','39.fredag.dagbladet.no',0,32768,32768,32768,32768,'Def
ault',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1019,'E7','E7',1,'TV3','TV
3','',0,'','4.fredag.dagbladet.no',0,32768,32768,32768,32768,'D
efault',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1020,'S9','S9',1,'Cartoon','Cartoon','',0,'','41.fredag.dagbladet.no',0,32768,32768,32768,
32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1021,'SE7','SE7',1,'CNN','CNN','',0,'','43.fredag.dagbladet.no',0,32768,32768,32768,32768,
'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1022,'E46','E46',1,'Disco','Discovery
channel','',0,'','44.fredag.dagbladet.no',0,32768,32
768,32768,32768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1023,'E9','E9',1,'TVNorge','TVNorge','',0,'','5.fredag.dagbladet.no',0,32768,32768,32768,3
2768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1024,'SE13','SE13',1,'SVT1','SVT
1','',0,'','6.fredag.dagbladet.no',0,32768,32768,32768,32
768,'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES
(1025,'SE10','SE10',1,'Z','ZTV','',0,'','63.fredag.dagbladet.no',0,32768,32768,32768,32768,
'Default',0,1,'',0,NULL,NULL,NULL);
INSERT INTO `channel` VALUES (1026,'E10','E10',1,'SVT2','SVT
2','',0,'','7.fredag.dagbladet.no',0,32768,32768,32768,3276
8,'Default',0,1,'',0,NULL,NULL,NULL);

Running on mythtv 0.17 + xmltv 0.5.38 (Debian unstable)