ooops, that is a very bad cross-post, sorry guys, got the wrong mailinglist, let the flaming begin .. :p Flame. Oh well, comments below.
ready for it, got my fire-resistant foil hat .. :p 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.
Apparently i very bad one (i'm guessing not up to date with the latest version of mythtv) i got it from this page: http://nerdhero.org/index.php/Howtos/MythTV but now i found another one that looks the same, but does a bunch of ALTER TABLE stuff afterwards (to fix tables maybe ?) the second one is here : http://ramses.smeyers.be/varia/mythtv-cvs/ Reason for this 'special' channel / tv listings stuff is because i live in belgium, so i don't think the zap2it stuff will work. It didn't for my previous myth install (but that was years ago) 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.
Thought so. maybe this one is beter (the one from the second page i mentioned): http://ramses.smeyers.be/varia/mythtv-cvs/channels.sql Keith C
_______________________________________________ ivtv-users mailing list [email protected] http://ivtvdriver.org/mailman/listinfo/ivtv-users
