On 16/08/05, George Styles <[EMAIL PROTECTED]> wrote: > It was because the networkID in dtv_multiplex was null. > > I changed it to 9018 (for all mplexes) and it started getting listings :) :) > :) > > ANyone know where 9018 came from? (I just grepped the log file for any > SErviceID's and it came up with 9018...) i suspect I need different > values for different mplexes. > > Anyone on Crystal Palace who fancies dumping their channels and > dtv_multiplex tables for me??? > thanks > > george
Here you go - pretty much as they were scanned. I'd changed BBC3 to use xmltv (as a test).
-- phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- http://www.phpmyadmin.net -- -- Host: 192.168.0.10 -- Generation Time: Aug 17, 2005 at 10:54 PM -- Server version: 3.23.58 -- PHP Version: 4.3.11 -- -- Database: `mythconverg` -- -- -------------------------------------------------------- -- -- Table structure for table `channel` -- CREATE TABLE `channel` ( `chanid` int(10) unsigned NOT NULL default '0', `channum` varchar(5) NOT NULL default '', `freqid` varchar(10) default NULL, `sourceid` int(10) unsigned default NULL, `callsign` varchar(20) NOT NULL default '', `name` varchar(64) NOT NULL default '', `icon` varchar(255) NOT NULL default 'none', `finetune` int(11) default NULL, `videofilters` varchar(255) NOT NULL default '', `xmltvid` varchar(64) NOT NULL default '', `recpriority` int(10) NOT NULL default '0', `contrast` int(11) default '32768', `brightness` int(11) default '32768', `colour` int(11) default '32768', `hue` int(11) default '32768', `tvformat` varchar(10) NOT NULL default 'Default', `commfree` tinyint(4) NOT NULL default '0', `visible` tinyint(1) NOT NULL default '1', `outputfilters` varchar(255) NOT NULL default '', `useonairguide` tinyint(1) default '0', `mplexid` smallint(6) default NULL, `serviceid` mediumint(8) unsigned default NULL, `atscsrcid` int(11) default NULL, PRIMARY KEY (`chanid`), KEY `channel_src` (`channum`,`sourceid`) ) TYPE=MyISAM; -- -- Dumping data for table `channel` -- INSERT INTO `channel` VALUES (1000, '1', NULL, 1, 'BBC ONE', 'BBC ONE', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 1, 4164, 0); INSERT INTO `channel` VALUES (1001, '2', NULL, 1, 'BBC TWO', 'BBC TWO', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 1, 4228, 0); INSERT INTO `channel` VALUES (1002, '7', NULL, 1, 'BBC THREE', 'BBC THREE', 'none', NULL, '', 'choice.bbc.co.uk', 0, 32768, 32768, 32768, 32768, 'Default', 1, 1, '', 0, 1, 4351, 0); INSERT INTO `channel` VALUES (1003, '40', NULL, 1, 'BBC NEWS 24', 'BBC NEWS 24', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 1, 4415, 0); INSERT INTO `channel` VALUES (1004, '51', NULL, 1, 'BBCi', 'BBCi', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 1, 4479, 0); INSERT INTO `channel` VALUES (1005, '30', NULL, 1, 'CBBC Channel', 'CBBC Channel', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 1, 4671, 0); INSERT INTO `channel` VALUES (1006, '3', NULL, 1, 'ITV1', 'ITV1', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 2, 8261, 0); INSERT INTO `channel` VALUES (1007, '34', NULL, 1, 'ITV3', 'ITV3', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 2, 8294, 0); INSERT INTO `channel` VALUES (1008, '6', NULL, 1, 'ITV2', 'ITV2', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 2, 8325, 0); INSERT INTO `channel` VALUES (1009, '4', NULL, 1, 'Channel 4', 'Channel 4', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 2, 8384, 0); INSERT INTO `channel` VALUES (1010, '14', NULL, 1, 'E4', 'E4', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 2, 8448, 0); INSERT INTO `channel` VALUES (1011, '193', NULL, 1, '705', '705', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 2, 8452, 0); INSERT INTO `channel` VALUES (1012, '41', NULL, 1, 'ITV News', 'ITV News', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 2, 8581, 0); INSERT INTO `channel` VALUES (1013, '5', NULL, 1, 'five', 'five', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 3, 12866, 0); INSERT INTO `channel` VALUES (1014, '16', NULL, 1, 'QVC', 'QVC', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 3, 13120, 0); INSERT INTO `channel` VALUES (1015, '15', NULL, 1, 'abc1', 'abc1', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 3, 14208, 0); INSERT INTO `channel` VALUES (1016, '23', NULL, 1, 'bid tv', 'bid tv', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 3, 14272, 0); INSERT INTO `channel` VALUES (1017, '24', NULL, 1, 'price-drop tv', 'price-drop tv', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 3, 15616, 0); INSERT INTO `channel` VALUES (1018, '61', NULL, 1, 'Red Hot', 'Red Hot', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 3, 15680, 0); INSERT INTO `channel` VALUES (1019, '36', NULL, 1, 'Xtraview', 'Xtraview', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 3, 15744, 0); INSERT INTO `channel` VALUES (1020, '47', NULL, 1, 'Teachers'' TV', 'Teachers'' TV', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 3, 15808, 0); INSERT INTO `channel` VALUES (1021, '45', NULL, 1, 'BBC PARLMNT', 'BBC PARLMNT', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 4, 16768, 0); INSERT INTO `channel` VALUES (1022, '10', NULL, 1, 'BBC FOUR', 'BBC FOUR', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 4, 16832, 0); INSERT INTO `channel` VALUES (1023, '31', NULL, 1, 'CBeebies', 'CBeebies', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 4, 16960, 0); INSERT INTO `channel` VALUES (1024, '189', NULL, 1, '701', '701', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 4, 19456, 0); INSERT INTO `channel` VALUES (1025, '190', NULL, 1, '702', '702', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 4, 19520, 0); INSERT INTO `channel` VALUES (1026, '191', NULL, 1, '703', '703', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, 4, 19584, 0); INSERT INTO `channel` VALUES (1027, '46', NULL, 1, 'Community', 'Community', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 4, 19968, 0); INSERT INTO `channel` VALUES (1028, '42', NULL, 1, 'Sky News', 'Sky News', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 5, 22080, 0); INSERT INTO `channel` VALUES (1029, '43', NULL, 1, 'Sky Spts News', 'Sky Spts News', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 5, 22144, 0); INSERT INTO `channel` VALUES (1030, '11', NULL, 1, 'Sky Travel', 'Sky Travel', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 5, 22208, 0); INSERT INTO `channel` VALUES (1031, '12', NULL, 1, 'UKTV History', 'UKTV History', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 5, 22272, 0); INSERT INTO `channel` VALUES (1032, '39', NULL, 1, 'E4+1', 'E4+1', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 5, 22336, 0); INSERT INTO `channel` VALUES (1033, '18', NULL, 1, 'The HITS', 'The HITS', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 6, 25664, 0); INSERT INTO `channel` VALUES (1034, '21', NULL, 1, 'TMF', 'TMF', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 6, 25728, 0); INSERT INTO `channel` VALUES (1035, '19', NULL, 1, 'UKTV Br''tIdeas', 'UKTV Br''tIdeas', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 6, 25792, 0); INSERT INTO `channel` VALUES (1036, '20', NULL, 1, 'f tn', 'f tn', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 6, 25856, 0); INSERT INTO `channel` VALUES (1037, '22', NULL, 1, 'Ideal World', 'Ideal World', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 6, 25920, 0); INSERT INTO `channel` VALUES (1038, '38', NULL, 1, 'Men & Motors', 'Men & Motors', 'none', NULL, '', '', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 1, 6, 27072, 0); INSERT INTO `channel` VALUES (1039, '1', '1', 1, '1039', 'BBC1 London & South East', '', 0, '', 'london.bbc1.bbc.co.uk', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL); INSERT INTO `channel` VALUES (1040, '2', '2', 1, '1040', 'BBC2 London & South East', '', 0, '', 'london.bbc2.bbc.co.uk', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL); INSERT INTO `channel` VALUES (1041, '', '', 1, '1041', 'BBC4', '', 0, '', 'knowledge.bbc.co.uk', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL); INSERT INTO `channel` VALUES (1042, '4', '4', 1, '1042', 'Channel 4', '', 0, '', 'channel4.com', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL); INSERT INTO `channel` VALUES (1043, '5', '5', 1, '1043', 'Five', '', 0, '', 'channel5.co.uk', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL); INSERT INTO `channel` VALUES (1044, '3', '3', 1, '1044', 'ITV1 London', '', 0, '', 'carlton.com', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL); INSERT INTO `channel` VALUES (1045, 'ITV2', 'ITV2', 1, '1045', 'ITV2', '', 0, '', 'itv2.itv.co.uk', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL); INSERT INTO `channel` VALUES (1046, 'ITV3', 'ITV3', 1, '1046', 'ITV3', '', 0, '', 'itv3.itv.co.uk', 0, 32768, 32768, 32768, 32768, 'Default', 0, 1, '', 0, NULL, NULL, NULL);
-- phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- http://www.phpmyadmin.net -- -- Host: 192.168.0.10 -- Generation Time: Aug 17, 2005 at 10:56 PM -- Server version: 3.23.58 -- PHP Version: 4.3.11 -- -- Database: `mythconverg` -- -- -------------------------------------------------------- -- -- Table structure for table `dtv_multiplex` -- CREATE TABLE `dtv_multiplex` ( `mplexid` smallint(6) NOT NULL auto_increment, `sourceid` smallint(6) default NULL, `transportid` int(11) default NULL, `networkid` int(11) default NULL, `frequency` int(11) default NULL, `inversion` char(1) default 'a', `symbolrate` int(11) default NULL, `fec` varchar(10) default 'auto', `polarity` char(1) default NULL, `modulation` varchar(10) default 'auto', `bandwidth` char(1) default 'a', `lp_code_rate` varchar(10) default 'auto', `transmission_mode` char(1) default 'a', `guard_interval` varchar(10) default 'auto', `visible` smallint(1) NOT NULL default '0', `constellation` varchar(10) default 'auto', `hierarchy` varchar(10) default 'auto', `hp_code_rate` varchar(10) default 'auto', `sistandard` varchar(10) default 'dvb', `serviceversion` smallint(6) default '33', `updatetimestamp` timestamp(14) NOT NULL, PRIMARY KEY (`mplexid`) ) TYPE=MyISAM AUTO_INCREMENT=7 ; -- -- Dumping data for table `dtv_multiplex` -- INSERT INTO `dtv_multiplex` VALUES (1, 1, 4100, 9018, 505833330, 'a', 0, 'auto', '', 'auto', '8', '2/3', '2', '1/32', 0, 'qam_16', 'n', '3/4', 'dvb', 14, '20050803225952'); INSERT INTO `dtv_multiplex` VALUES (2, 1, 8197, 9018, 481833330, 'a', 0, 'auto', '', 'auto', '8', '1/2', '2', '1/32', 0, 'qam_64', 'n', '2/3', 'dvb', 15, '20050817224647'); INSERT INTO `dtv_multiplex` VALUES (3, 1, 12290, 9018, 561833330, 'a', 0, 'auto', '', 'auto', '8', '1/2', '2', '1/32', 0, 'qam_64', 'n', '2/3', 'dvb', 18, '20050803230030'); INSERT INTO `dtv_multiplex` VALUES (4, 1, 16384, 9018, 529833330, 'a', 0, 'auto', '', 'auto', '8', '2/3', '2', '1/32', 0, 'qam_16', 'n', '3/4', 'dvb', 23, '20050803230051'); INSERT INTO `dtv_multiplex` VALUES (5, 1, 20480, 9018, 578166670, 'a', 0, 'auto', '', 'auto', '8', '2/3', '2', '1/32', 0, 'qam_16', 'n', '3/4', 'dvb', 18, '20050803230110'); INSERT INTO `dtv_multiplex` VALUES (6, 1, 24576, 9018, 537833330, 'a', 0, 'auto', '', 'auto', '8', '2/3', '2', '1/32', 0, 'qam_16', 'n', '3/4', 'dvb', 3, '20050803230129');
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
