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)
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
