[mythtv-users] need help with manual mythfilldatabase

[Simon]

Hi,
I'm trying to do a manual install based on instructions on a Belgian
website, but they are not working and this may be because they are up to
date.

My channels file reads:

drop table channel;

CREATE TABLE channel (
  chanid int(10) unsigned NOT NULL default '0',
  channum varchar(5) NOT NULL default '',
  freqid varchar(5) NOT NULL default '',
  sourceid int(10) unsigned default NULL,
  callsign varchar(20) default NULL,
  name varchar(20) default NULL,
  icon varchar(255) default NULL,
  finetune int(11) default NULL,
  videofilters varchar(255) default NULL,
  xmltvid varchar(64) default NULL,
  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',
  PRIMARY KEY  (chanid)
) TYPE=MyISAM;

INSERT INTO channel VALUES
(1002,'2','SE14',1,'BBC2','bbc2','/home/mythtv/.mythtv/channels/BBC2.gif',0,'','bbc2',0,28000,30000,31000,30500,'Default',0,1);
INSERT INTO channel VALUES
(1003,'3','SE8',1,'MTV','mtv','/home/mythtv/.mythtv/channels/MTV.gif',0,'','mtv',0,28000,30000,31000,30500,'Default',0,1);
INSERT INTO channel VALUES
(1004,'4','E10',1,'TV1','tv1','/home/mythtv/.mythtv/channels/TV1.gif',0,'','tv1',0,28000,30000,31000,30500,'Default',0,1);
INSERT INTO channel VALUES
(1005,'5','SE10',1,'CANVAS','canvas','/home/mythtv/.mythtv/channels/canvas.gif',0,'','canvas',0,28000,30000,31000,30500,'Default',0,1);

And my program info comes in the form:
  <channel id="raiuno">
    <icon src="http://www.teveblad.be/gfx/logos/RAIUNO.gif";>
    </icon>
    <display-name>raiuno</display-name>
  </channel>
  <programme start="200503110900 +0100" stop="200503111530 +0100"
channel="canvas">
    <title>Lentebeelden</title>
  </programme>

I wonder about the reference to channel="canvas" but simply know nothing
about sql

Hoping someone can help

Sim


_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users