Melvin,<br><br>thanks for the tip, i'll try tonight.<br><br>it looks like also i fucked up my channel/listings table with an outdated sync script.<br><br><br>Greetz,<br>Ban<br><br><div><span class="gmail_quote">On 12/20/06,
<b class="gmail_sendername">Melvin J. Cureton</b> <<a href="mailto:melvincureton@melcrys.com">melvincureton@melcrys.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
You may want to try setting you starting channel to 3 or 4 (which ever your channels start at) in the setup. I had a similar problem then I changed mine to start at channel 3 and all worked fine.<br><br>Thank You<br>Melvin Cureton
<br><a href="mailto:melvincureton@melcrys.com">melvincureton@melcrys.com</a><br><br>________________________________<br><br>From: <a href="mailto:mythtv-users-bounces@mythtv.org">mythtv-users-bounces@mythtv.org</a> on behalf of sven waeyenbergh
<br>Sent: Wed 12/20/2006 8:15 AM<br>To: Discussion about mythtv<br>Subject: [mythtv-users] backend crashing when live tv on fedora 6<br><br><br>Hi,<br><br>I installed a new fedora core 6 (atrpms) backend machine and remote frontend machine.
<br>Installation went ok, was able to setup the backend and also to add tv listings that show up in mythweb.<br>Install of the frontend also went fine.<br><br>However, every time i try to access live tv, the backend crashes immediately.
<br>Much to my surprise, the reason seems to be database structure errors ???<br><br>I was able to replicate this problem again and again.<br>I also checked the files i used to import tv listings and channels.<br>The one that instaals the channels redefines the channel tables as such:
<br>CREATE TABLE channel (<br> chanid int(10) unsigned NOT NULL default '0',<br> channum varchar(5) NOT NULL default '',<br> freqid varchar(5) NOT NULL default '',<br> sourceid int(10) unsigned default NULL,
<br> callsign varchar(20) default NULL,<br> name varchar(20) default NULL,<br> icon varchar(255) default NULL,<br> finetune int(11) default NULL,<br> videofilters varchar(255) default NULL,<br> xmltvid varchar(64) default NULL,
<br> recpriority int(10) NOT NULL default '0',<br> contrast int(11) default '32768',<br> brightness int(11) default '32768',<br> colour int(11) default '32768',<br> hue int(11) default '32768',
<br> tvformat varchar(10) NOT NULL default 'Default',<br> commfree tinyint(4) NOT NULL default '0',<br> visible tinyint(1) NOT NULL default '1',<br> PRIMARY KEY (chanid)<br>) TYPE=MyISAM;<br>--> is that ok ?
<br><br>Version (for both) is <a href="http://mythtv-suite-0.20-148.fc6.at">mythtv-suite-0.20-148.fc6.at</a> <<a href="http://mythtv-suite-0.20-148.fc6.at/">http://mythtv-suite-0.20-148.fc6.at/</a>><br><br>This log shows startup of the backend, crash, and (manual) restart:
<br><br>2006-12-19 22:12:49.048 Using runtime prefix = /usr<br>2006-12-19 22:12:49.126 New DB connection, total: 1<br>2006-12-19 22:12:49.142 Connected to database 'mythconverg' at host: localhost<br>2006-12-19 22:12:
49.156 Current Schema Version: 1160<br>Starting up as the master server.<br>2006-12-19 22:12:49.182 New DB connection, total: 2<br>2006-12-19 22:12:49.187 Connected to database 'mythconverg' at host: localhost<br>
2006-12-19 22:12:49.190 EITHelper: localtime offset 1:00:00<br>2006-12-19 22:12:49.206 TVRec(1) Error: Start channel from DB is empty, setting to '1' instead.<br>2006-12-19 22:12:49.208 New DB connection, total: 3
<br>2006-12-19 22:12:49.219 Connected to database 'mythconverg' at host: localhost<br>2006-12-19 22:12:49.222 DB Error (get channels -- sourceid):<br>Query was:<br>SELECT channum, callsign, chanid, atsc_major_chan, atsc_minor_chan, name, icon, visible FROM channel WHERE sourceid='1'
<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'atsc_major_chan' in 'field list'<br><br>2006-12-19 22:12:49.239 DB Error (GetChannelData):<br>Query was:
<br>SELECT finetune, freqid, tvformat, freqtable, commfree, mplexid, atsc_major_chan, atsc_minor_chan, serviceid FROM channel, videosource WHERE vi<br>deosource.sourceid = channel.sourceid AND channum = '1' AND
channel.sourceid = 1<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'mplexid' in 'field list'<br><br>2006-12-19 22:12:49.245 TVRec(1) Error: Setting start channel '1' failed,
<br> and no other channels were found on input.<br>2006-12-19 22:12:49.280 EITHelper: localtime offset 1:00:00<br>2006-12-19 22:12:49.297 TVRec(2) Error: Start channel from DB is empty, setting to '1' instead.
<br>2006-12-19 22:12:49.299 DB Error (get channels -- sourceid):<br>Query was:<br>SELECT channum, callsign, chanid, atsc_major_chan, atsc_minor_chan, name, icon, visible FROM channel WHERE sourceid='1'
<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'atsc_major_chan' in 'field list'<br><br>2006-12-19 22:12:49.380 DB Error (GetChannelData):<br>Query was:
<br>SELECT finetune, freqid, tvformat, freqtable, commfree, mplexid, atsc_major_chan, atsc_minor_chan, serviceid FROM channel, videosource WHERE vi<br>deosource.sourceid = channel.sourceid AND channum = '1' AND
channel.sourceid = 1<br>Driver error was [2/1054]:<br>QMYSQL3: Unable to execute query<br>Database error was:<br>Unknown column 'mplexid' in 'field list'<br><br>2006-12-19 22:12:49.382 TVRec(2) Error: Setting start channel '1' failed,
<br> and no other channels were found on input.<br>2006-12-19 22:12:49.397 New DB scheduler connection<br>2006-12-19 22:12:49.423 Connected to database 'mythconverg' at host: localhost<br><br>
_______________________________________________<br>mythtv-users mailing list<br><a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br><a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
</a><br><br><br></blockquote></div><br>