Hi

Mythtv is a very cool piece of software, the dokumentation is ... let's say short

Okay my problem was I had to do "mythfilldatabase --manual" and I hab some problems with it.

First problem what data do I have to enter?

After some sleepless nigths I finaly got it to work.

I received my frequence ids (freqid) from the program "scantv" I d't know where I got it from, sorry.

I had to enter a TV norm (TVformat) because the script need something to work and there is no default value set.

So here is a dump of my channel.db I hope it can help someone.


<pre>
- phpMyAdmin SQL Dump
-- version 2.6.1-rc1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 04. Februar 2005 um 16:58
-- Server Version: 4.0.23
-- PHP-Version: 4.3.10-2
--
-- Datenbank: `mythconverg`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `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 '',
PRIMARY KEY (`chanid`),
KEY `channel_src` (`channum`,`sourceid`)
) TYPE=MyISAM;

--
-- Daten für Tabelle `channel`
--

INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (1, '3sat', 'SE12', 1, '1', '3SAT', '/root/.mythtv/channels/3sat.gif', 0, '', 'C3sat.de', 0, 32768, 32768, 32768, 32768, 'PAL', 1, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (2, 'ARD', 'E2', 1, '2', 'ARD', '/root/.mythtv/channels/ard.gif', 0, '', 'ard.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (3, 'BR3', 'C06', 1, '3', 'BAYERN', '/root/.mythtv/channels/bayern.gif', 0, '', 'C3.br-online.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (4, 'DSF', 'SE14', 1, '4', 'DSF', '/root/.mythtv/channels/dsf.gif', 0, '', 'dsf.com', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (5, 'Euros', 'SE11', 1, '5', 'Eurosport', '/root/.mythtv/channels/eurosport.gif', 0, '', 'eurosport.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (6, 'Kabel', 'S07', 1, '6', 'KABEL 1', '/root/.mythtv/channels/kabel1.gif', 0, '', 'kabel1.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (7, 'MDR', 'S25', 1, '7', 'MDR', '/root/.mythtv/channels/mdr.gif', 0, '', 'mdr.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (8, 'MTV', 'SE18', 1, '8', 'MTV', '/root/.mythtv/channels/mtv.gif', 0, '', 'mtv.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (9, 'ORF 1', 'E7', 1, '9', 'ORF 1', '/root/.mythtv/channels/orf1.gif', 0, '', 'C1.orf.at', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (10, 'ORF 2', 'E8', 1, '10', 'ORF 2', '/root/.mythtv/channels/orf2.gif', 0, '', 'C2.orf.at', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (11, 'PRO 7', 'E9', 1, '11', 'PRO 7', '/root/.mythtv/channels/pro7.gif', 0, '', 'prosieben.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (12, 'RTL', 'E10', 1, '12', 'RTL', '/root/.mythtv/channels/rtl.gif', 0, '', 'rtl.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (14, 'SF1', 'SE10', 1, '14', 'SF1', '/root/.mythtv/channels/drs.gif', 0, '', 'C1.sfdrs.ch', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (15, 'Super', 'SE16', 1, '15', 'Super RTL', '/root/.mythtv/channels/superrtl.gif', 0, '', 'superrtl.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (16, 'SWR', 'E5', 1, '16', 'SW III', '/root/.mythtv/channels/swiii.gif', 0, '', 'swr.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (17, 'VIVA', 'SE6', 1, '17', 'VIVA', '/root/.mythtv/channels/viva.gif', 0, '', 'viva.tv', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (18, 'VOX', 'SE17', 1, '18', 'VOX', '/root/.mythtv/channels/vox.gif', 0, '', 'vox.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (19, 'WDR', 'SE15', 1, '19', 'WDR', '/root/.mythtv/channels/west.gif', 0, '', 'wdr.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');
INSERT INTO `channel` (`chanid`, `channum`, `freqid`, `sourceid`, `callsign`, `name`, `icon`, `finetune`, `videofilters`, `xmltvid`, `recpriority`, `contrast`, `brightness`, `colour`, `hue`, `tvformat`, `commfree`, `visible`, `outputfilters`) VALUES (20, 'ZDF', 'E3', 1, '20', 'ZDF', '/root/.mythtv/channels/zdf.gif', 0, '', 'zdf.de', 0, 32768, 32768, 32768, 32768, 'PAL', 0, 1, '');

</pre>