On Dec 20, 2006, at 7:14 AM, sven waeyenbergh wrote:
ooops, that is a very bad cross-post,
sorry guys, got the wrong mailinglist,
let the flaming begin .. :p
Flame. Oh well, comments below.
Ban
On 12/20/06, sven waeyenbergh <[EMAIL PROTECTED]> wrote:
Hi,
I installed a new fedora core 6 (atrpms) backend machine and remote
frontend machine.
Installation went ok, was able to setup the backend and also to add
tv listings that show up in mythweb.
Install of the frontend also went fine.
However, every time i try to access live tv, the backend crashes
immediately.
Much to my surprise, the reason seems to be database structure
errors ???
I was able to replicate this problem again and again.
I also checked the files i used to import tv listings and channels.
The one that instaals the channels redefines the channel tables as
such:
What kind of importer / installer do you use for channels? That
sounds weird to me.
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;
--> is that ok ?
No, thats not ok at all. Why would your channel importer recreate
the table? You should have left the table structure the way it was,
as it should have quite a few more fields than that. Myth won't work
with that table.
Keith C
_______________________________________________
ivtv-users mailing list
[email protected]
http://ivtvdriver.org/mailman/listinfo/ivtv-users
